View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F[_2_] F[_2_] is offline
external usenet poster
 
Posts: 46
Default Button to copy row to first empty row on another sheet

I have a workbook with two sheets: 'Sheet A' and 'Sheet B'. 'Sheet B'
holds checkboxes with which to enter responses and the responses are
aggregated into A83:AS83.

I need to use a button to copy A83:AS83 and paste it into the first
empty row below row 500 in 'Sheet A'. As the process would be repeated
more than a few times, the number of the row into which A83:AS83 would
be pasted would need to increment automatically.

I would be grateful for any pointers on how I might be able to do this!

TIA

--
F