I have a sheet where I enter text and values into various cells. After all
cells are entered, I want to copy certain cells into 1 row in another sheet
in the same book.
Every time I enter information in the cells in the first sheeet, I want to
put those values in the next available row in the second sheet.
ie: Sheet1! A1,B15,B16,B17,G7,B22 (always the same cell numbers) Copy into
Sheet2! A1,B1,C1,D1,E1,F1 the first time, then the new values into cells
A2,B2,C2,D2,E2,F2
And so on.
Does anyone have a macro or know where to look to read up on how to do it.
Any info would be great.
Thanks,
Joe