Previous Topic Next Topic

Excel- A Macro to copy data from one sheet to another

Closed
solosis - Apr 7, 2015 at 12:53 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 7, 2015 at 03:20 AM
Hello,

Could anyone help me with this.

I am trying to write a macro with following criteria.

1. Every week a set of data is entered into sheet 1 which should get copied to the next sheet (Sheet2) below the previous weeks data in sheet 2.
2. That is, say in week1 I upload a data in sheet1 it shld get copied to sheet2,next when I erase the data in sheet1 and upload the data of week 2, this data should get copied to sheet2 below the 1st weeks data and so on.
3. The data range in sheet 1 is (94Rx16C)

Regards,
solo

1 response

Answer 1 / 1
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Apr 7, 2015 at 03:20 AM
Hello Solo,

So it appears that you are wanting to transfer a "block" of data at a time [Range("A2:P94")] from sheet 1 to sheet 2 with the data in sheet 1 being deleted when it is transferred to sheet 2. Is this correct?
I assume that you have headings in Row 1.

I helped a Poster a few weeks ago with a similar query. Have a look at the test work book here:-

https://www.dropbox.com/s/s0vl47o25tb924l/Sweety%20Pradhan.xlsm?dl=0

and let us know if this is similar to your query.

Cheerio,
vcoolio.
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses