Copy and paste data
Hi,
I have many files on my desktop. I have a separate excel file which has a sheet with name “Raw Data”
I want a macro to ask me which file and which sheets data to copy to this “Raw Data” and should copy the data to that “Raw Data”. Is It possible?
Browsing the file and sheet may help me (I think)…
Please help..
Last edited by kishoremcp; 05-28-2012 at 06:39 AM.
Do you want this macro to run when you open Raw Data?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi
Upload the files... with that it will be very easy to understand the problem...
Click *, if my suggestion helps you. Have a good day!!
Yes. I will run that macro after I open the file in which "Raw Data" sheet is....
Can you provide me the range that needs to be copied? Or should the macro check which is the last row with data and copy accordingly? Should the headers be copied?
Do you need the macro to ask for the sheetname to be copied? Or will there always be 1 sheet?
Yes. The headers to be copied and the entire sheet to be copied. I want the macro to ask me to browse and ask for the sheet name to be copied or it can also be like display the sheet names and then I will select the requied sheet which has to be copied to Raw Data
Try this codePress Alt+F11 on your file. On the left hand side, you will see ThisWorkbook. Double click on that and copy the above code in the right hand side code window.
Please Login or Register to view this content.
It will prompt you to open the workbook and then it will display the sheets available in the workbook that you open. By default, the first sheet name will be shown, which you can change accordingly. Then it copies the entire contents and closes the opened workbook.
Hope this is what you are looking for.
It is working good and it is working the way I want. But the only problem is it is not letting me to select the sheet name. It is listing out the sheet names and I have to type manually the required sheet name. It there any possiblity to select the sheet name also instead of typing it..?
I cannot explain all the steps here so am attaching what i have tried for you.
Save this file anywhere and then open it. It will automatically prompt you for the file and proceed.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks