Thread: macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joel Joel is offline
external usenet poster
 
Posts: 1
Default macro

Hello,

I want to run a macro that does this"

On sheet 1, I fill in A1 with data. I click a button and it copies it over to A1 on sheet 2.

Then, on sheet 1, I fill in A1 with something else. I click the button again and it copies it into the next available row which would be A2.

Can someone please point me in the right direction.

Thanks so much,
Joel