+ Reply to Thread
Results 1 to 4 of 4

tecnically just copy and paste (ish), Please HELP!!

  1. #1
    Registered User
    Join Date
    06-24-2019
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    tecnically just copy and paste (ish), Please HELP!!

    I've been going round in circles with this for a while and can't figure it out!

    I have 4 sheets
    On sheets 2,3 & 4 if the value in column A is greater than Zero then I would like to copy adjacent contents of column i,
    Then I would like to paste values in Sheet 1 column A, remove duplicates and sort.

    It seems like it should be simple but I'm getting all sorts of errors and my offset funtion is not up to scratch.

    Any help would be greatly appreacted.
    Many thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,473

    Re: tecnically just copy and paste (ish), Please HELP!!

    Probably useful to post the code you've got and a sample workbook.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,397

    Re: tecnically just copy and paste (ish), Please HELP!!

    Just a sample code due to no workbook attached.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-24-2019
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Re: tecnically just copy and paste (ish), Please HELP!!

    This is what I have got, I'm well aware it is increadibly clunky! please don't judge.

    Please Login or Register  to view this content.

+ 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. Replies: 3
    Last Post: 01-01-2015, 06:26 AM
  2. [SOLVED] Copy Paste Loop ends before copy/paste is finished
    By brgr4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-08-2013, 04:01 PM
  3. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  4. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Access Tables & Databases
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  5. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  6. 2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2010, 10:34 AM
  7. Replies: 1
    Last Post: 01-04-2005, 06:06 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