+ Reply to Thread
Results 1 to 2 of 2

Taking Data from One Sheet (in a Workbook) to another sheet (in a workbook)

  1. #1
    Registered User
    Join Date
    12-12-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    27

    Question Taking Data from One Sheet (in a Workbook) to another sheet (in a workbook)

    Hi All

    So I've begun my dabbling into macros and, through much googling, I've learnt how to do a fair bit, but I've now come up with something that I have no idea how to approach. So I'm really hoping someone here can help me. I will try to explain it as best as I can.

    We have Sheet A in Workbook 1 that contains a different amount of rows of data each time it is run. I've already run a macro to get it looking how I need it. However, now I need to copy all the rows from Sheet A in Workbook 1, however many there may be at the time that the report is run, and paste into Sheet A of Workbook 2. Now the catch is that Sheet A of Workbook 2 has formulas in it AND it has formatting of its own, so I need to paste into A2 (because A1 has titles) but to match destination formatting. I will then need to do some other stuff to it, such as deleting any row where a cell has value of zero, but can I do all that from the one and same macro? And, if I can, how exactly do I do that?

    Hoping someone may be able to help me - as said, I am very new to macros, but I've learnt a fair bit having a play around but I'm stuck on how to do this.

  2. #2
    Registered User
    Join Date
    12-12-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    27

    Re: Taking Data from One Sheet (in a Workbook) to another sheet (in a workbook)

    Something to add which may or may not throw a spanner in the works, but Workbook 2 is on a network share drive. Can I reference a network share drive?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copying data from sheet to sheet, workbook to workbook
    By BigBobBobson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-24-2015, 10:18 AM
  2. [SOLVED] Copying data from one workbook sheet to another workbook sheet without overwrriting
    By Amol1988 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2014, 01:58 AM
  3. [SOLVED] copy data from a sheet in one workbook to a sheet with the same name in another workbook
    By ChrisBester in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2013, 06:27 AM
  4. Replies: 8
    Last Post: 12-14-2012, 05:33 AM
  5. How to export data from one sheet in a workbook to another sheet in another workbook
    By Billybong in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2012, 09:50 AM
  6. Replies: 9
    Last Post: 04-04-2011, 12:03 AM
  7. Replies: 0
    Last Post: 08-01-2007, 02:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1