Excel macro - Is this possible

IrishChr1s · 15 May 2013 at 11:44

Hi guys,

I've a template that's identical across multiple sheets in excel, roughly 40 sheets in total. My question is, If I wanted to pull data from 1 cell from each sheet, and compile this in another sheet, is this possible.

For example,

If cell D2 had protein content of a specific food, and each sheet had a different food, could I pull the data from cell D2 from each sheet and have this displayed in the final sheet?

Random macro I know, If it cant be done, no worries, but would save a lot of time.

Cheers,
Chris

namnoc · 15 May 2013 at 12:14

DaleTheWhale · 15 May 2013 at 12:30

It can be done quite easily without the need for a macro either, you can merge the data across all the sheets into the final one. I'll dig out some excel work from a while ago and see if I can help some more.

IrishChr1s · 15 May 2013 at 13:41

ThaReaperGuy said:
It can be done quite easily without the need for a macro either, you can merge the data across all the sheets into the final one. I'll dig out some excel work from a while ago and see if I can help some more.

That sounds great, Ill also Google how to do this in the mean time,

Thanks so much for the pointers bud!

Chris

feriso · 15 May 2013 at 13:45

Yes, don't just have the 'main' sheet with the cell point to the info cell on another sheet:

=Sheet2!B4

Where Sheet2 is the name of the sheet and b4 the cell,

type = on the cell where you want the info then navigate to the info cell and press enter?

IrishChr1s · 15 May 2013 at 14:33

feriso said:
Yes, don't just have the 'main' sheet with the cell point to the info cell on another sheet:

=Sheet2!B4

Where Sheet2 is the name of the sheet and b4 the cell,

type = on the cell where you want the info then navigate to the info cell and press enter?

This is also helpful, and as I know the cell number I need each time will speed the process up, but do you have any idea why, when I put in that formula and change it to the cell and sheet I need its just giving me the SaveAs screen

Thank you

EDIT
Scrap what I said above, it wasn't prompting the save as screen, it was looking for me to find the file I'm using, its working now, quiet long winded, but still definitely faster this way.

Cheers