I have one sheet that I want to give me an overview of what the other sheets say. I only need the second row from each sheet as that will give me the most updated info, but I can't find what formula I need to accomplish that.

The only way I can think of is to use a Macro,

unfortunately, my Macro skills are just above nil.But here is a site that may offer something you can use:

http://en.kioskea.net/faq/4668-exce...

MIKE

Maybe I'm missing something, but why won't a simple SheetName!CellReference formula work? Assumptions, modify as required:

1 - Sheet1 is your summary sheet

2 - Sheet1!Row 1 contains Column headings

3 - Sheet2, Sheet3, etc. contain your dataIn Sheet1!A2 enter:

=Sheet2!A2

In Sheet1!A3 enter:

=Sheet3!A2

Continue down Column A until all of your sheets have been referenced.

Select the entire range of formulas and drag them to the right as far as required.

If Row 2 of the various sheets are of different lengths, enhance the formula to return a blank cell if a cell in Row 2 is empty and then drag the formula as far right as the longest Row 2 requires...

=IF(Sheet2!A2="","",Sheet2!A2)

I can provide a macro if required, but I don't see a need for one - unless I'm missing some detail of your requirements.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

DerbyDad03, Thanks for your reply. Your assumptions were correct and what you said looked like it should work, but for some reason I couldn't get that formula to work. So I looked over it again, I had made a mistake while I was putting that formula in, so after I corrected that I was able to get it to work.

Thanks again.

message edited by sc1

Ask Your Question

Weekly Poll