Previous Topic Next Topic

Data Replication using macro

Solved/Closed
Chandra - Dec 1, 2011 at 12:06 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Dec 8, 2011 at 12:15 PM
Hello Experts,

I have a requirement as follows:

User data Entry:
Column1 Column2 Column3 Colulmn4 TIME JAN FEB MAR
INDIA Bangalore Salary Admin 100 200 300
USA Newyork Rent Project 200 300 400
INDIA Delhi Revenue Project 400 500 600

By executing the macro, the above data should replicated be as follows:

Column1 Column2 Column3 Colulmn4 TIME AMOUNT
INDIA Bangalore Salary Admin JAN 100
USA Newyork Rent Project JAN 200
INDIA Delhi Revenue Project JAN 400
INDIA Bangalore Salary Admin FEB 200
USA Newyork Rent Project FEB 300
INDIA Delhi Revenue Project FEB 500
INDIA Bangalore Salary Admin MAR 300
USA Newyork Rent Project MAR 400
INDIA Delhi Revenue Project MAR 600


Hence the data should be replicated just below the actuals. and the amounts should be part of the single column. Time should become row filed instead of a column.

Note: The number rows may vary, as it is the choice of the user to enter the data

Can anyone help me in building this macro. It would be very helpful. Thanks in advance.

Regards,
Chandra

1 reply

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Dec 1, 2011 at 06:34 AM
see this
https://ccm.net/faq/7316-excel-moving-row-values-into-column-values
0
Chandra
Dec 7, 2011 at 03:41 AM
Hi rizvisa,

Thank you very much, It worked.

Can u please also, let me know whether thourgh a macro, we can store an excel file with the user name and Time stamp.

It is like everytime we open the file from a server, we make some changes. when we execute a macro, it should save a copy of the file on desktop with "User name time(At that particular point)".

Let me know if this possible, any macro of this kind would be great for us.

Thanks in Advance
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Dec 8, 2011 at 12:15 PM
you can add a macro to do that

for that you need to know where is the location of deskop is
0