I need some helping in excel macro. I have two sheets in a workbook. Sheet1 is for summary and Sheet2 is for the raw data. I need to update/insert/copy data in Sheet2 to Sheet1. Below is the sample macro code:
The code above is working but everytime I change data in Sheet2, the Sheet1 only replace its data. What I need is everytime I change data in Sheet2, it should be added (append) in Sheet1. Please help me.
Appreciate your help.
I tried this and it worked if you only need to append a data once.
Please help me out. What macro code should I use so that everytime I click on a button after adding a data on a single cell it compiles to a list. I want the top of my worksheet to look like this on top:
Data: ___________ +
so everytime I put data on the space and click on +, the data will be added to a list...Pease help!