Previous Topic Next Topic

How to copy data using macros?

Closed
xtrememenace - May 21, 2010 at 02:20 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 21, 2010 at 11:05 AM
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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 09:17 AM
So next time when you run this macro, the sheet1 will no longer have the previously copied values ?
x
May 21, 2010 at 11:00 AM
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
May 21, 2010 at 11:00 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 11:05 AM
so how one can say this row was copied in the last run and this time start doing from this row ?

Similar discussions

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