auto adjusting # rows between 2 worksheets

[kevin mckellar]

I have a spreadsheet where I import daily data into
worksheet A. Sometimes there will be 5 rows of data and
sometimes 1000+. Then inside the spreadsheet I have
Worksheet B that runs some formulas based on Worksheet A.

My question is how do I get Worksheet B to automatically
extend or reduce the # of rows to match Worksheet A?

Please help or give me some direction! thanks

 

[David French]

I think that I would create the formulas on SheetB no matter how many rows
there may be on A.
If the information is on SheetA to make the formula work...great! If there
is no corresponding data then there will be no information change.
You may want to append your formulas with an IF statement to leave the cell
blank if nothing shows up on SheetA.

Dave French
MOS XP Master Instructor

 

[kevin mckellar]

Thanks for the response.

Yes I thought of doing a mass IF statement that would
provide blanks if there is no data in Worksheet A. The
problem I ran across is that sometimes the # of rows of
data in Sheet A can go to the Excel maximum of 65k and
having Sheet B filled with IF statments for all 65k rows
makes the spreadsheet quite large. In addition, my pivot
table that runs off of Sheet B will show "blanks" as an
option.

Any other ideas you would have are welcome. thanks
Kevin

 

[Guest]

Have you tried using a reference to the column containing the data?
If you want a sum of the data in column D of worksheet A you might enter the
formula "=SUM(SheetA!D)"

I may be oversimplifying the problem, though.

Rick