Auto adjusting # rows between 2 worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kevin mckellar - 30 Dec 2004 14:38 GMT

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

Reply to this Message

galimi - 30 Dec 2004 15:01 GMT

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

> I have a spreadsheet where I import daily data into
> worksheet A. Sometimes there will be 5 rows of data and
[quoted text clipped - 5 lines]
>
> Please help or give me some direction! thanks

Reply to this Message