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.
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.
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
- Posts
-
4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
768for that you need to know where is the location of deskop is