• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Macro: Transfer Worksheet Data to Multiple Worksheets in a Closed Workbook

J

jftapel

New Member
Hello Experts :)

May I please ask for your assistance on how I could achieve this report process:

1. I have a workbook (WB1)with one sheet with various data (Staff Name, Project Worked, Date, Hours Spent)

2. I need to transfer some data from WB1 to a closed workbook (WB2) from my desktop into different worksheets.

3. Criteria to transfer WB1 to different sheets into WB2 is by Staff Name.

4. WB1 has a column with Staff Names.

5. WB2 have multiple worksheets labeled with the same Staff Names as WB1.

6. Each sheet of WB2 has 2 tables inside:

6A. Table 1 data will come from WB1 table

6B. Table 2 data is like a calendar, if WB1 table marks a date as holiday, it will mark the same date as HOLIDAY in WB2 Table 2.


I have explained this much to my capability and hoping for a favorable response to get me started. Thank you for any advise you can give. :)


Sample Files:

https://www.dropbox.com/s/44w7ur9wqaf0kfk/WB1.xlsx

https://www.dropbox.com/s/dcn1yetdzyk4tql/WB2.xlsx

Kind regards,

Joyce
 
Hello dan_l,

Thanks for your time, I'm afraid I do not know anything about ADO at all :(

Is there any other way to achieve the above?


Here's what I am trying to use but can't proceed because I'm not that knowledgeable in Excel coding. In reference to this sample file which works perfectly almost to what I need but needs a little more changing: http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/


I would like to only transfer certain cells and not the entire row from WB1. How should I change the code so that I can choose which columns to transfer only?

I can amend the criteria to pick up the staff name.

I also have problem on the dates, because when one date is marked as a vacation leave of the staff in WB1, it must be marked on the calendar same date that I have on WB2.


I am really hopeful someone picks up this request so I can learn how to use the existing code provided from this site to suit my report requirements.


Many thanks,

Joyce
 
Hi, jftapel!


I'm afraid that your last posted link from this site doesn't work with closed workbooks. You should check this:

http://chandoo.org/forums/topic/copy-from-one-workbook-to-sheet-in-another-workbook


If further links needed:

http://www.rondebruin.nl/copy7.htm

http://www.rondebruin.nl/ado.htm


Just advise if any issue.


Regards!
 
You must log in or register to reply here.
Back
Top