Rows

[Frankie needs HELP]

I need to keep three lines between my table and the one below it.

The data that I have in the top table may change (so more rows maybe taken up). How do I keep the two tables three rows apart?

 

[Mark W.]

Are you referring to PivotTables? If so, why don't you keep them on separate worksheets?

 

[Frankie needs HELP]

No, I can only have one worksheet. In the top table I am extracting data and putting it into the one below (this is all done via a macro). But I must take into account that there may be changes the next time I run the macro, so I can't just assign it to a cell three rows below the top table.

Got any ideas???

 

[Al Chara]

Try the following:

Dim StartPoint As Range
Set StartPoint = Range("a1").End(xlDown).Offset(4, 0)
StartPoint.Select

A1 is the start point for table 1.

 

[Frankie needs HELP]

That's Brilliant Al, you're a life saver, Thank you