Hi,
Need your expertise.
I have an excel sheet where in i need to paste the values from another different excel file every time.
A macro which would ask to select an excel file, to copy the cells (B2, B7,C3) of the selected file and then paste the values in current worksheet, would be helpful.
Thank you.
Have a Nice Day!
Where would you like the copied cells to go in your current worksheet. Will they overwrite the existing cell values or not. More specific information is needed to provide you with a solution. Are the cells being copied, formulas that will require paste special or are they text or values that can simply be pasted. Help us to help you by giving us specific information about your project.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
The copied cells be pasted in A1, A2, A3 of current worksheet and will overwrite the existing values if any. Cells being copied are to be pasted as values.
Thank you!
Try this code: Put it in the target workbook as a module.
Please Login or Register to view this content.
THANK YOU VERY MUCH ALAN.
Have a great weekend!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Hi,
The excel files which i open also contain a checkbox. Based on which i am trying to insert some text in current worksheet.
So, i have added the following lines to the above code.
But it is resulting in a error "The item with specified name was not found"Please Login or Register to view this content.
Can you please help on how to fix this.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks