+ Reply to Thread
Results 1 to 3 of 3

vba code to adjust scattered data in their respective columns

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,060

    vba code to adjust scattered data in their respective columns

    Hi All

    I have an export sheet from an interface but the data and columns are scattered .

    Columns A have data that needs to be split in their respective columns , the data needs to be adjusted in their respective columns and totals to be added at end of respective columns.

    Page numbers need to be repeated which is added at end of each page report number .

    However the format is always the same as no of pages reads to 200 pages or more .

    Looking for code that can insert , adjust data.

    Thanks if someone can assist
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    473

    Re: vba code to adjust scattered data in their respective columns

    Hi JEAN1972

    ***Edit ***
    Please try this
    Attached Files Attached Files
    Last edited by vichopalacios; 09-04-2017 at 05:43 PM.
    Barriers are there for those who don't want to dream

  3. #3
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,060

    Re: vba code to adjust scattered data in their respective columns

    Hi vichopalacios

    Impressive!!!!, you saved me from a daily chores

    Worked marvelous Thank you

+ 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. Bring scattered data to correct columns
    By vadaniels in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-22-2020, 10:32 PM
  2. [SOLVED] formula to split data in respective columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2017, 02:21 PM
  3. [SOLVED] formula to split data to their respective columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2016, 11:50 AM
  4. Inserting the data in to respective columns
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 10-11-2013, 03:53 PM
  5. [SOLVED] Adjust code to copy mulitple columns & date stamp
    By tiger01 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-27-2013, 11:27 PM
  6. [SOLVED] Automattically adjust code when rows or columns are added
    By Tulipo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2012, 05:28 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