General

External Referance over Network
I need to take a total from one workbook and link it to another book on the same network. The 2nd book will be edited by other users and i need to be able to have their amounts added to my total from the first workbook. I've tried paste link but all I get is an image that shows the value of the cell in the li... 7 Apr 2010 02:26

Import XML
Is there anyway I can suppress creation of Aggregate columns when I open/import XML into Excel? I'm using Excel 2002 and 2003. Many thanks in advance. ... 6 Apr 2010 23:11

Subtract 12 hours from date/time
I am trying to subtract 12 hours from a date/time cell if the date in B1 is greater than A1. A1 3/3/2010 2030 (formatted: m/d/yyyy hh:mm) B1 3/4/2010 1030 (formatted: m/d/yyyy hh:mm) No matter how I format A1, B1 and C1 I still get a #Value error. I am obviously missing something or leaving som... 7 Apr 2010 14:40

Sorting and COUNTIF
This may be a double post; apologies. This problem seems to happen only when my RANGE is on a different worksheet than my CRITERIA. When I run a COUNTIF, if I sort the table, the criteria returns the count of whatever is in the position of where the CURRENT criteria USED to be. I don't want that. I never kn... 7 Apr 2010 11:14

Problems with merged cells
I have merged a fair few cells so that I can enter paragraphs, once I type past a certain point it wont bring up everything I have entered in the cell, it cuts half of it off & it wont print it either, but when i click on the cell all the information is there......can anyone help me out with this??? ... 6 Apr 2010 22:05

Countif, Sorting => Two Sheets
This may be a double post; apologies. This problem seems to happen only when my RANGE is on a different worksheet than my CRITERIA. When I run a COUNTIF, if I sort the table, the criteria returns the count of whatever is in the position of where the CURRENT criteria USED to be. I don't want that. I never kn... 6 Apr 2010 19:53

Repetitive macros
I have a large mailing listing that I have to delete names from. I have created a macro that "finds" CPA and deletes the entire row from the spreadsheet. How do I make this macro continue throughout the spreadsheet without running it by hand every time? I am running Excel 2007. Thanks, -- rcarolina ... 6 Apr 2010 19:53

COUNTIF, Sorting, Two Sheets
The RANGE and CRITERIA for my COUNTIF are on two separate tabs of the same file. When I set it up, nice. But if I sort any other field in that column, the CRITERIA refers back to its ORIGINAL position, and returns in its new cell the count of the data that occupies the ORIGINAL position. In other words: ... 6 Apr 2010 18:45

Mask Account Number
I have a spreadsheet with tons of accounts numbers, and I need them to show up as 1234567 on my spreadsheet, but need them to show up XXX4567 how do I do this? ... 6 Apr 2010 17:36

Combine Descriptions
I have various items in a spreadsheet. There are many different items in various rows. Some items have the same reference number, just a different description. I want to combine all of one reference number's descriptions into one cell. I am doing vlookup, but it is only putting in the first occurance. Is the... 6 Apr 2010 17:36