+ Reply to Thread
Results 1 to 5 of 5

If unique value exists copy 2 values to other sheet

  1. #1
    Forum Contributor
    Join Date
    02-28-2020
    Location
    Inverness, Scotland
    MS-Off Ver
    365
    Posts
    259

    If unique value exists copy 2 values to other sheet

    From another sheet data transfers into sheet 1 (so will expand in number of rows). I'm trying to get to the point of a macro checking for product names and then copying them and the total (N3, N4 etc) into sheet 2 adding more rows into sheet 2 as required but keeping the row heights if possible (space 10, text 20). So it would only copy new data eg when products 8,9 etc were added. Can anyone take a look please.
    Attached Files Attached Files
    Last edited by And180y; 08-02-2020 at 07:43 PM.

  2. #2
    Forum Contributor
    Join Date
    02-28-2020
    Location
    Inverness, Scotland
    MS-Off Ver
    365
    Posts
    259

    Re: If unique value exists copy 2 values to other sheet

    Could this be done with a formula instead?

  3. #3
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    932

    Re: If unique value exists copy 2 values to other sheet

    There are 6 columns in sheet2 but 13 columns in sheet1. Which ones do you need to be represented on sheet2? A formula can be used to bring over the data to sheet2, but I don't know how one could use formula's to change formatting.

    You can use Autofill to select the two rows of data and drag down by two rows to add new lines with the formatting. Format painter can also recreate the border and formats, but not the line height.

    Is automating the data fill with formulas and formatting manually acceptable? Or a VBA solution can be used to do both. If a real guru feels I am wrong about formatting with formulas, please let us know.

  4. #4
    Forum Contributor
    Join Date
    02-28-2020
    Location
    Inverness, Scotland
    MS-Off Ver
    365
    Posts
    259

    Re: If unique value exists copy 2 values to other sheet

    Maniacb, thanks for replying. From the data in sheet 1 I only need the data from column A> Column B in sheet2 and Column N> Column M in sheet2.
    I was hoping that it would automatically add a row when the last empty one was filled.
    I have attached a copy of the sheet with the data manually moved.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-28-2020
    Location
    Inverness, Scotland
    MS-Off Ver
    365
    Posts
    259

    Re: If unique value exists copy 2 values to other sheet

    As a work around I am thinking of linking the cells meantime, I have recorded a Macro to add a row but unfortunately that's all it does, adds one row. What would I need to change to make it add a row everytime the button is pressed? New sheet attached
    Attached Files Attached Files

+ 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. Copy over to summary sheet if quantity exists in column
    By IT_Worx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2015, 12:22 PM
  2. If Sheet Exists Stop Macro from Creating a Copy
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 09:47 PM
  3. Replies: 2
    Last Post: 01-22-2014, 11:11 AM
  4. Replies: 1
    Last Post: 11-14-2013, 09:24 PM
  5. Replies: 2
    Last Post: 07-25-2013, 07:45 PM
  6. Macro to copy sheet from closed work book and overwrite if sheet already exists
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-23-2009, 06:36 PM
  7. finding if more then 1 copy of a sheet exists?
    By spyrule in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2006, 10:46 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