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


Related:

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 ?
0
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.
0
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.
0
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 ?
0

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response
how to open file safe in vivo v11 without password
shivaraju -
Man -

3 responses