I am new to Macro/VBA. I need a macro that when it runs, it will ask the user to enter which row the user would like to copy and it will paste the values of each cells to specific cells in a template. hope someone can help. thank you in advance!
I am new to Macro/VBA. I need a macro that when it runs, it will ask the user to enter which row the user would like to copy and it will paste the values of each cells to specific cells in a template. hope someone can help. thank you in advance!
Hi majana54
Try this...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
In your scenario I would use two macros.
Right Click on the sheet name at the bottom of excel and select view code to see the sheet specific macro
It runs the second macro when you click on an item no.
Please Login or Register to view this content.
The second macro does the work.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
@ mehmetcik
Nice one...
Try this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks