Hi All,
I am new in VBA, and I want to learn it. I want to know how I can write the VBA code to copy and paste the data from 3 workbooks in a workbook. My problem is every time when I will receive the data columns would be fixed but row number would not be fixed.
Please help me to write a macro for the same.
Regards
Nisha
Could u please provide sample source workbook file and master workbook where u want to copy it will make easy to provide perfect macro
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi, Nisha,
you would need to be more specific about what you want to do: copy to only one worksheet (summarize on that sheet) or dfifferent worksheets (add new ones if needed or fill up existing ones).
A Google search should have brought up links like https://sites.google.com/a/madrocket...s-to-one-sheet or https://sites.google.com/a/madrocket.../wbs-to-sheets.
Ciao,
Holger
Last edited by JBeaucaire; 12-26-2019 at 04:28 PM.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi,
Please find the attached data, I have putted the 3 workbook's data in a workbook in different sheets.
Hi Nisha,
looks to me as if the first link I posted will suit your needs.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks