ambientsbs
asked on
Excel 2010 - Copy data from specific cells in one worksheet to new row in another worksheet
Hi Experts,
I'm looking for some Excel VBA help to accomplish the following task. I have an Excel worksheet with information in random cells. If it helps, I'll say that I have information in cells G1:G3, J2, K3, E10, E12, E14, E16, E18, J11:J16, G19, I19, and G21. As you can see, it's not a specific range of cells.
What I'm looking to do is create a macro that I can tie to a button which will take the data from the cells I specify (listed above) and copy the VALUES (some of the cells use formulas) into a row in another worksheet called "Data" when the button is clicked.
Every time I enter new data into these cells and click the button, I'd like the macro to copy the most recent data entered into a new row below the previous row that was copied to in the "Data" sheet.
Is there any way to do this? Please help! : )
I'm looking for some Excel VBA help to accomplish the following task. I have an Excel worksheet with information in random cells. If it helps, I'll say that I have information in cells G1:G3, J2, K3, E10, E12, E14, E16, E18, J11:J16, G19, I19, and G21. As you can see, it's not a specific range of cells.
What I'm looking to do is create a macro that I can tie to a button which will take the data from the cells I specify (listed above) and copy the VALUES (some of the cells use formulas) into a row in another worksheet called "Data" when the button is clicked.
Every time I enter new data into these cells and click the button, I'd like the macro to copy the most recent data entered into a new row below the previous row that was copied to in the "Data" sheet.
Is there any way to do this? Please help! : )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi there, loving this
but really need to see if i can get the information into a defined order.
i.e. say i have created a front sheet that looks like a form i will want to take the information entered into the random cells (data will change but cells remain the same) and create a list as stated above, this list then becomes my log of the front form.
to give you back ground i am creating a Monitoring form and wish to create a log off teh back of it to track results.
ideally there would be a button on teh front page that creates the log.
Can you help?
but really need to see if i can get the information into a defined order.
i.e. say i have created a front sheet that looks like a form i will want to take the information entered into the random cells (data will change but cells remain the same) and create a list as stated above, this list then becomes my log of the front form.
to give you back ground i am creating a Monitoring form and wish to create a log off teh back of it to track results.
ideally there would be a button on teh front page that creates the log.
Can you help?
ASKER