+ Reply to Thread
Results 1 to 1 of 1

Copy data fm range in 1 workbook, past in specific cells in 2nd workbook rename tab & loop

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work 2013 Home 2019
    Posts
    348

    Post Copy data fm range in 1 workbook, past in specific cells in 2nd workbook rename tab & loop

    Hi everyone,

    This may entail one or more macro's but I'll try and explain what I'm tryng to achieve.

    In one spreadsheet "Masterlist.xlsx", the data I want to copy is in the following columns (there is additional data on each row but I don't need that)

    Column A - My Reference
    Column B - Feed
    Column C - Notification Date
    Column D - Vendor
    Column E - Vendor ID
    Column F - Severity
    Column G - Description
    Column H - Product

    In my second spreadsheet "Form.xlsx" I to achieve the following:

    For each record matching a specified date (can make inputting the date as part of the Macro operation) I need create a copy of the tab called 'template'.
    Then I need to do the following:
    In C3 insert the output from Column A
    In C4 insert the output from Column B
    In G3 insert the output from Column C
    In G4 insert the output from Column D
    In G5 insert the output from Column E
    In B7 insert the output from Column G
    In C16 insert the output from Column F
    In B23 insert the output from Column H

    Then I want to rename the Tab the same as Cell C3 and loop until a tab is created for each record with a date matching that originally specified.

    Then I want to save the output with a filename yyyymmdd - Alerts.xlsx

    I used to be fairly familiar with macro's but lack of practice has made me a tad rusty. If this requires more than one macro I have no problems with putting them all together.

    Thanking you in anticipation.

    Terry
    Last edited by MagicMan; 07-24-2014 at 11:37 AM. Reason: Error correction

+ 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. Vba to Copy from Mass Specific Cells Range to a workbook
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-14-2014, 12:15 PM
  2. Replies: 2
    Last Post: 09-04-2012, 01:19 AM
  3. [SOLVED] Macro for COPY and PAST RANGE of data to ANOTHER workbook
    By Atoms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2012, 02:45 AM
  4. Copy range from one workbook to other in specific cells?
    By fcb1900 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2010, 08:38 AM
  5. Replies: 1
    Last Post: 04-01-2006, 03:50 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