Hello, I spent a day trying to merge columns from different sheets into one sheet. My case is: I have 52 sheets named: 1,2,3,4,5 ...52 with the same format. I...

Hi Is there a way to call the AutoFit function of Excel using one of the macros defined in the XLCALL.h file? I am trying to do this from inside a VC++...

Dave, I just wanted to say thanks. I was using a shortcut that included the Shift Key. The macro works when started from the Macro Menu. I tried to say...

What is the NNTP for this newsgroup? Thanks EM

Have seen examples similar to what I am asking but my problem is it can be ANY number. I want to read (from left to right) the contents of a cell and once I...

I have three columns with entries like below. Column B (Courtview (Original)) is hidden from view in my final version. Column A has the following formula...

Hello, I want to add a query criteria using the 'begins with' option. I cannot get the syntax right. Choosing --- begins with ----- does not...

I have a formula to calculate the percentage of profit on a line item: =(F2/G2) Now I want to make it so that if the percentage falls below 133%, the cell...

I am trying a conditional statement to return "yes" if the date is in 2005. I have used this =IF(M2=YEAR(2005),"yes","") or =IF(M2=YEAR(AA2),"yes",""). The...

I'm tracking data for three products on a master sheet but want to link the complete row/line item data to individual sheets for each product.

Hi out there Please I need help with working between worksheets. I have some values in work sheet 2 which I need to correspond with results in worksheet 1....

I have Excel 2003. I have a workbook with several worksheets in it. I needed to add two lines to all the worksheets so I selected them all and added the...

I have entered several functions in my spreadsheet, however the cells they are dependant on do not currently have data entered in them. Is there a way to...

As per title really I am making a temporary database in excel which will also be a functional model for one we are having made externally. However because...

When I put this in a cell: =IF(C8="","",B7+1) it is displayed exactly as typed rather than acting as a formula (which it is). This has happened to me in the...

I have to produce a recap that shows any store that is producing =5%. For the recap, I need to return the store #, store name, actual % achieved that is...

What is the correct feature and term used to change a value of non-contiguous cells all at once. I would like to equate a particular number to a name (text)...

I created IF functions for both the outcome and fee columns. Now I need to be able to get the sum of the fees and wehen I try to use the sum function, it...

I have cells C2, D2 and G2, H2 with numerical values in them. In K2 I want an If statement that returns 'Yes' when C2, and G2's values match and also when D2...

I have tabulated data that has filters applied. I have another template that create vouchers from this data. Is there a formula I can put into the fields in...