General

what is the formular to use from one wokesheet to a new workbook
I WOULD LIKE THE FORMULAR TO USE SO THAT WHEN I ENTER AN AMOUNT IN ONE WORKBOOK IT WILL GO TO ANOTHER WORKSHEETBUT TO A DIFFERENT CELL EACH TIME ... 5 Jul 2008 06:24

The Instruction at "0x749860a0" referenced memory at "0x00000000"
Why do I get this message TWICE each time I close Windows XP? Is it because I updated my Excel? ... 4 Jul 2008 20:15

Copying different cells from one list to another
If anyone can advise me I would greatly appreciate your help. I have to take individual number from a large list and put them into a smaller list of their own. I can highlight my list but when I go to copy them I get the message: 'That command cannot be used on multiple selections' There must be a way to ... 9 Jul 2008 06:31

how do I copy an entire worksheet to another with text & format?
Try clicking in the upper left hand corner of the sheet to highlight the entire sheet. Then do the copy command Then open the workshhet in to which you want to copy Then click paste speacial (default choice is "ALL" which is ok Say OK I just went through the same thing and this seems to work. You may have to ... 4 Jul 2008 17:11

INDEX/MATCH #REF! error
I have a worksheet pulls values from a source worksheet ('Jurisdiction Entries'!$C$2:$C$35) based on a date I fill in on the target worksheet (A5) and a state code (B3..). It brings in a couple of fields when it matches the date ('Jurisdiction Entries'!$A$2:$A$35,0) and state code (Entries'!$B$2:$B$35,0) in the... 4 Jul 2008 17:11

Sum formular using vlookup
I am trying to create a formula that will sum up the values of a cell on multiple lines. i.e. The product name "Twix" appears on multiple lines in a worksheet, to the right of the cell is a value that varies. I want a formula that looks for all references of the word "Twix" in a worksheet and then sums up th... 4 Jul 2008 20:15

menu bar
I have developed a spreadsheet that contains every control I need, including save and exit etc, as buttons embeded within the sheet. Is there a way to remove the menu column (File edit view insert etc) from the top of the page?? I suspect the answer is a unresounding NO! but hey worth trying! ... 10 Jul 2008 07:13

Were is the Tools menu in EXCEL 2007?
I installed Office 2007, but I can't find the Tools menu, or any way of adding it to the toolbar. I did find a way to add tools to the "quick access toolbar", but it not the complete "tools menu". I want to add to the regular toolbar. ... 4 Jul 2008 16:09

grabbing data from another website
Good afternoon, Thanks in advance to whoever can help me, i am very, very interested in a solution if one can be given. I run a detailed statistical database of sports statistics, which is required to be updated each morning. I have dozens of tabs within the excel sheet, which, as of right now, I manually update b... 4 Jul 2008 16:09

Locked for editing problem...
Evening/Afternoon all I think I may have created myself a nice little pickle. I have hijacked the default CTRL+V functionality in my workbook to implement paste special> paste text only, to preserve the formatting of my worksheet. Anyway, it worked fine for a while, but now when I use CTRL+V i get a "filenam... 4 Jul 2008 16:09