Closed Thread
Results 1 to 4 of 4

Copy and Paste Macro with 2 conditions

  1. #1
    Registered User
    Join Date
    11-07-2015
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    91

    Copy and Paste Macro with 2 conditions

    Hi all,

    I am looking to create a macro to copy values from a column (column D) and paste to specific cell within table on another sheet which is determined by 2 criteria (date in rows and name&variable in column). I have attached a sample workbook. Hoping someone can help me with this.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by kk1352; 07-17-2021 at 07:57 PM. Reason: Error in sample workbook

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,598

    Re: Copy and Paste Macro with 2 conditions

    How does this differ substantially from the thread you asked to have closed?

    You said that you were going to post in the Commercial Services section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-07-2015
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    91

    Re: Copy and Paste Macro with 2 conditions

    This was a different problem to the first thread but have combined the two and posted in the commercial section.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,598

    Re: Copy and Paste Macro with 2 conditions

    Thanks. I see you are getting help there.

    This thread is now closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste Macro with multiple conditions
    By kk1352 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2021, 09:38 PM
  2. Help to do a copy and paste but with conditions
    By IanF23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2019, 11:08 AM
  3. [SOLVED] Tweak Copy/Paste Special Macro based on conditions
    By kingofcamden in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2018, 11:59 AM
  4. A Macro to Copy and paste from cell above if certain Conditions are met
    By Denise Devlin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2016, 07:09 AM
  5. VBA to copy and paste according to conditions
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2014, 09:19 AM
  6. Macro to copy the data from sheet1 and to paste it in sheet2 with conditions.
    By Thinker8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2014, 09:55 AM
  7. Macro to copy a table and paste in another table (based on certain conditions)
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2013, 01:14 PM

Tags for this Thread

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