Previous Topic Next Topic

How to copy data using macros?

Closed
xtrememenace - 21 May 2010 à 02:20
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 21 May 2010 à 11:05
Hello,

I have a sheet which has data,
Sheet 1
A B C D
1 2 3 4
1 2 3 4
-- -- -- --
Now i need the logic for the macro such that, when i enter the values in the 3rd Row and press the ADD Macro button, the data entered shld get copied into a different on the same or another worbook.

Sheet 2
A B C D
1 2 3 4
1 2 3 4
4 5 6 7


1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
21 May 2010 à 09:17
So next time when you run this macro, the sheet1 will no longer have the previously copied values ?
x
21 May 2010 à 11:00
Well, it will have the previously copied value, along with the new values that i would further enter into it. it just that, whatever i enter into it, shld get stored in some another worksheet or workbook.
x
21 May 2010 à 11:00
Well, it will have the previously copied value, along with the new values that i would further enter into it. it just that, whatever i enter into it, shld get stored in some another worksheet or workbook.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
21 May 2010 à 11:05
so how one can say this row was copied in the last run and this time start doing from this row ?

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses