Set up a macro in one row and then return to fill in next row?
I have 2 sheets in an Excel file. One is simply a data sheet that will be
used again and again. The second sheet is where I want to store the
information that is entered. The info on sheet one is vertical. I need to
copy the info to sheet 2 horizontally AND then move down one row for the next
time data is entered into sheet 1.
I would also like to put one of those of buttons on the page as this file
will be passed back and forth.
|