I am trying to import a text file that is larger than the number of rows in a worksheet. Excel imports the data into the first column only, then gives me a...

I do hope somebody can help me! I've used Excel 2002 since it was released, and have never met this problem before. Basically, I have a very simple...

Hello from Steved I have an index in Columns which has a Label the cell below has a Label and below that a Constant. The index is C4:AT125 In A1 and A2 I type...

Although the two columns I am comparing in my VLOOKUP look exactly the same (for example, both say MMM 001), they came from different sources and so must look...

I am missing probably a simple step in creating a macro for a worksheet. The problem seem to be when I "carry out the actions I want to record." Objective:...

Thanks so much to all of you who take time to help us out! You have no idea how much we appreciate it! I have two different sets of data. One is a complete...

Dear all, Suppose i have a workbook containing a worksheet, whose cells r linked to another a worksheet in another workbook. now the problem is, i want...

hi all, I want to write in an existing excel sheet which is on server side. its a template.. and has a standard format.. so i want to write in that excel...

Is there a way to insert the current date into a cell and not have it update the following day? For example, an invoice number is keyed in cell A1, and when...

Why does the page down/up distance change from time to time. I try to set up a repeatable system for moving in a spread sheet and when the page down or page...

I can't use the formula below because this data links to several different graphs and charts. If there are blanks, it still shows in the graphs. Don't know...

Hi! I'm learning how to link worksheets for a master report. When the master worksheet gathers the figures from the subworksheets, all blank cells show as...

Hi Tom Ogilvy, Thank you very much for your help but unforshenetly this macro did not work I want to explain my procedure to do your macro if it is correct or...

Hi, I am trying to count the number of times a specific date value occurs for a specific team. Basically, column A "Team" contains multiple entries of a team...

Hi All, Any help with this one would be really appreciated. I want to create a worksheet that will calculate split times, for each km, for a marathon run...

Assuming the data is in A2:B6 (with row 1 = col headers) col A = team name, col B = startdates Put in F1: =SUMPRODUCT(($A$2:$A$6=D1)*($B$2:$B$6=E1)) where in...

When I query an excel database using the get external data function I have a problem with the data returned. I have columns with both numberic and alpha...

If someone can help you will save my hand from carpal tunnel. I imported some data from a warehouse program and it gives me item # and all transactions...

Hello Group i have this rather simple equation , but cant seem to figure out how to write it in excel x1=x2=x3=x4=x5=x6=x7=x8=x9=x10 These are just initial...

I am keeping scores on a weekly basis for different persons entering as well the date in a reference cell . In same workbook I have a range with dates of 52...