in excel one sheet to specific column of data save to another sheet...how can it possible in macro

[kissudears]

s.no	comp. name	bank name	branch	chq.no	chq date	deposit date	amount

<tbody>
</tbody>

this is the first sheet and i want to auto save this sheet in sheet 2 when i click a save button in sheet 1. and in sheet 2 data will save and when 1 column complete 2nd column auto generate.please help me excel expert...thanking you...

 

[VoG]

Duplicate http://www.mrexcel.com/forum/excel-...ave-another-sheet-how-can-possible-macro.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).