+ Reply to Thread
Results 1 to 1 of 1

formatting and copy macro

  1. #1
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    486

    formatting and copy macro

    Hi,
    I am trying to format the sheet like a numbered sequence.
    I have in the sheet , different copy past items with their headings with same no of column.
    In A1 - FAB is the first heading, second one is A83- Mar
    For these items sub headings aa, bb, cc..
    in this , i want to do is, insert a column and put FAB in all the rows where FAB data is there. eg:Till row80, then it will be followed by MAR till row 93.
    and where ever Com appears in Col A, the corresponding Col C row data must be moved to COl D previous row..
    for eg: if it is in C72, then it will moved to D71.

    Like this , i have 700 rows.

    i am trying to create a macro using array , can anybody help?
    So the macro should find where ever main heading exist, then it should remove the row and insert a column in A copy that heading to full row till that data completes.
    I have attached data as well as output desired..
    Attached Files Attached Files
    Last edited by dorabajji; 01-30-2020 at 05:13 PM.

+ 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. Macro to copy formulas and formatting down one column
    By MrChrisP in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2018, 09:50 AM
  2. Macro to Copy Header Formatting
    By adrenom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2016, 03:47 PM
  3. Debugging Macro to Copy over just Conditional Formatting
    By aadilshakir in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2015, 02:09 PM
  4. Macro to copy formatting/formulas to new blank row
    By roseme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2014, 07:43 AM
  5. [SOLVED] Need VBA macro to copy cell contents instead of its formatting
    By Nanimadhu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2014, 08:27 AM
  6. 'Copy & Paste Without Formatting' Macro problem
    By lipmeister in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2010, 09:42 AM
  7. macro copy, how to remove formatting?
    By coffeeson7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-19-2009, 05:08 PM

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