Auto adjusting # rows between 2 worksheets
 

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

Kevin,

You can have Spreadsheet B adjust the number of formula's programattically
by cycling through the maximum used range in Spreadsheet A and inspecting
individual cells for formula's.

The following property will return the total number of rows in Spreadsheet A

sheet1.UsedRange.Rows.Count

You can then cycle through each of the cells in that range to determine if
there is data in those cells.

http://ForPicks.com

"kevin mckellar" wrote:

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