Software

Ask something
Question Locked

Excel Summary sheet

0 helpful
3 replies

by amandajgallagher

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All,

I am urgently trying to find out how you would set up a automated update from 6 tabs within a spreadsheet to one summary tab. The data has uniques refs for each line but the data is dates and not calculations. the 6 workstream tabs are updated daily and then I have to cut and past all the info over to the summary sheet on a daily basis.

I have tried special paste but this does not update if an new line is added out of the original chosen rows.

Has anyone got any ideas? ? ?

Pulling hair out as i speak ,, Amanda :-(

3 replies

by thumbsup2

VB Script can do it. You can write it so that it parses through each sheet searching for the last line, set a variable with that cell reference, then copy the data from that sheet, manipulate it if you want, then put it in the summary sheet. Once one sheet is procesed, it moves to the next and does it again.

Of course, you have to know how to write VB.

by amandajgallagher

brilliant, thank you, I have used VB in the past but am a bit rusty so didnt want to start thrashing it out in VB to find that it isnt possible.

Many thanks for yiour quick response, you are a star :-)

Amanda

This discussion is closed to new replies.