Summary page that automatically adds new row when a new tab is created.

[STEFANIEJORDAN87]

I'm not having much luck wading through the hundreds of excel forums trying to find the solution to my problem.

I'm over inventory of a small lab and have been recently tasked with creating a summary page that shows, at a glance, all the individual lots we have available for sale with their appropriate weights and tax liabilities. I know i can just manually add in the data but i would much rather have it automatically populate said data into a new row on a summary page.


I have a basic template that I work with for every lot so the information I need will always been in the same cells on each new tab. I have some experience with macros, so I know enough to create a mess for myself!

I've included a sample of what information i need - on the summary tab, in yellow are the cells that i need to pull the information from each time a new tab is created.

[oeldere]

J1=G3
K1=L5
L1=R5

C6=INDIRECT("'FP"&$B6&"'!"&J$1) and drag across.

See the yellow cells in the attached file.

[STEFANIEJORDAN87]

This worked perfectly! Thank you!

[oeldere]

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.