+ Reply to Thread
Results 1 to 5 of 5

macro which uses two worksheets at a time (copy and paste)

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2016
    Posts
    21

    macro which uses two worksheets at a time (copy and paste)

    I am a novice in macros.
    I only know how to record a macro and use 'relative referencing'

    I have written the macro and I can reach a stage where it does the job and highlights the area (cannot get the formatting, but I can live with it).
    I have attached the file.

    I am getting stuck in copying the data to the adjacent sheet 'xxx'.

    I would be grateful for your help.
    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: macro which uses two worksheets at a time (copy and paste)

    Which data exactly are you wanting to copy and paste. It would be helpful if you outlined in steps what you want to accomplish.

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2016
    Posts
    21

    Re: macro which uses two worksheets at a time (copy and paste)

    Sorry.
    In sheet 'copy', please select cell 'C8'. Then run my macro 'X'. Once you run my macro, you will see that it highlights the bunch of data.
    I have to manually copy it and then paste it to the next worksheet 'xxx' (this time) from cell B74.
    Then I go and delete all the rows (that I have copied) in sheet 'copy'.
    Then start again from the next item, which now will be 'Product D'.

    Thank you.

  4. #4
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: macro which uses two worksheets at a time (copy and paste)

    Again, please outline what you would like to do. e.g.

    1. copy the contents of cell C8 in the "copy" sheet to cell "whatever" in "xxx" sheet etc...

    with Macros you shouldn't need to select a cell and then run your macro. If you detail out exactly what you hope to happen we can probably come up with a solution that will work no matter who is using the file.

  5. #5
    Registered User
    Join Date
    09-07-2012
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2016
    Posts
    21

    Re: macro which uses two worksheets at a time (copy and paste)

    Sorry,

    I ran out of time so could not reply to you.
    FYI - I wanted to perform a 'relative reference' macro.

    Thank you for your help.
    I am not sure if I should tick this thread as solved.

+ 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. Macro to copy/paste between worksheets and other misc...
    By schaasyd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2012, 08:47 AM
  2. VBA or Macro to Copy/Paste uniques value between 2 worksheets
    By grotz497 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-23-2012, 11:40 AM
  3. Copy/Cut/Paste Between Worksheets Macro
    By James479 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2011, 06:10 PM
  4. Macro - copy/paste from different worksheets
    By emptycucumber in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2009, 06:20 PM
  5. Replies: 1
    Last Post: 10-17-2005, 04:05 AM

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