+ Reply to Thread
Results 1 to 1 of 1

Copy Format from File in Column A to File in Column B

  1. #1
    Registered User
    Join Date
    11-26-2018
    Location
    Canada
    MS-Off Ver
    2010 - 2014
    Posts
    6

    Copy Format from File in Column A to File in Column B

    Hello,

    I was wondering if anyone can help me with the code for copying the format (select all) from file in column A and applying it to matching file in column B and to loop down the list? Ex. open File 1A and 1B, Select All in 1A, format painter, apply to file 1B, Save, Close, move to next row and do the same.

    Attachment 745270

    Thank you for any guidance!
    Attached Images Attached Images

+ 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 data from file to existing file to corresponding row and Column
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2020, 10:49 AM
  2. File Open and Search column from A1:CE1. If matched than copy entire row for that column.
    By shivanisachdeva167 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2014, 01:51 PM
  3. [SOLVED] How to Copy Column A from File 1 to Column D of File 2 without keeping File 1 open
    By eggcel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-12-2013, 02:38 AM
  4. Parse Data file to copy values into a Column format
    By Researcher007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2012, 01:36 PM
  5. Copy a column from a file I open to the file where the macro is runing
    By Azriel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2012, 11:50 AM
  6. Macro to copy a column data to flat file or text file
    By vinaynagasani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2009, 10:56 AM
  7. VBA Macro to copy an column from one Excel file into another file
    By Sam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2005, 11:05 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