General

chart Templates in Excel
Hi, am creating some chart templates (2007) and am wondering if anyone knows if the chart size can be included in this. ... 18 Apr 2010 21:57

copy a pivot table to another sheet in a macro
Hi there, I created a macro that will copy copy the information from a created pivot table to another sheet. I seemed ok when I recorded the macro. But there's no pivot table on the new sheet when I run the macro. What should I do to correct the problem? Thanks, Aline -- Aline ... 18 Apr 2010 21:57

Pivot Table Groupings Fail if 1of the items isn't in the next data
I am Grouping items together in a Pivot Table and everything works fine until I use the next months data. For example, I have different types of earning codes and I am grouping as follows. Codes 1, 3 & 5 = Group A 2, 4 = Group B 6 = Group C If in the next pay period, I do no... 18 Apr 2010 20:51

how can i make a line inserted in excel be straight
I have created a form in excel. There are lines in it where you would leave space for instance for your name to be written. When I draw a line - sometimes I can get it perfectly straight, but more often it is slightly crooked. Any tips on how to guarantee it to be straight? ... 18 Apr 2010 20:51

Excel (2002) slow after deleting some macros
Hello, Having created a series of macros, my worksheet and macros work fine. But when I looked at the list in the left hand pane I have found that I had many Modules that were empty and deleted them. Everything still is OK but Excel seems to be opening, saving and closing more slowly than before. Any adv... 18 Apr 2010 16:25

How do I use standard notepad (unicode) font for special character
I am trying to find the best way to create an excel file which will be using special characters like what you see for pronunciation in a dictionary like long and short vowels. I will need to export this to a tab delemented TXT file for InDesign to import. We have basically been using the Insert Character in E... 18 Apr 2010 23:03

VBA selecting an input range of cells
Hi I have a small request for help with code. I need a simple macro to have popups request the first and last cells in a range , and then to select the range indicated in the popups. Can someone help? Grateful for any assistance ... 18 Apr 2010 21:57

Count
Hi, I would like to know how which formula I should use to count some codes & to ignore the duplicated codes, for example in column A: Code 1234 4321 4321 1234 1234 3214 Now, I want Excel to count & the result is 3 which are: 1234-4321-3214 Yes I can use PivotTable, but I would like to use a formula b... 18 Apr 2010 17:32

UTF-8 Delimited
Hi, I had this problem too. Don't open the file... create a new sheet, go to the data tab and use 'from text'. Then you can select the encoding. simple wrote: Open UTF-8 in Excel 2007 22-Apr-08 I have UTF-8 encoded tab delimited data files. They have the UTF-8 header "EF BB BF". These files woul... 18 Apr 2010 15:18

Vlookup with sums
I have the following spreadsheet. 1609719837 M51410 10 Ser - 5/8" x 50 Ft. 2000 1609710593 2058100 5/8 X 100 Platinum 100 1609718669 10TNSGF 10 Ser - 1/2" x 50 Ft 1609719839 M51470 25 Ser - Industrial 3/4" x 75 Ft. 500 Column A is Product Number, Column B is a Description and Column C is the ... 18 Apr 2010 11:58