View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mallers Mallers is offline
external usenet poster
 
Posts: 1
Default 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.