How to make a near static sheet continually add rows of info on another sheet

**gbastasch** · 06-08-2010, 04:15 PM

I have a sheet that contains equations and specific formats. I want some of those results to be added in successive rows on another sheet.

So on SHEET 1, A1 through A10 has info that I want copied to SHEET 2, B1 through B10. Then SHEET 1 A1 through A10 have info copied onto SHEET 2 C1 through C10 then D1 through D10. But always keeping the same cells in SHEET 1.

I know how to copy the information for one row for example: ='###'!B1

But I do not know how to make it keep adding new rows of information. So when SHEET 1 A1 through A10 stays the same the rows are always being added downward in SHEET 2.

**royUK** · 06-09-2010, 01:18 AM

maybe the Contacts Form example might help

http://excel-it.com/vba_examples.htm

If not attach an example workbook

**gbastasch** · 06-10-2010, 03:16 PM

In Sheet 1 there is a specific format with information and equations. I need that info to be brought over to Sheet 2.

The part where this gets complicated is that I need Sheet 1 to basically stay the same format, unchanged except for slightly new information. When new information is added to Sheet 1, I need it to be added to a new row or in other words Week 2, Week 3 and so on.

Is there a macro or function that can keep Sheet 1 nearly static but Sheet 2 continues on with new rows of copied info?

Thank you very much for the help.