Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Create before process wkbook formating data like after process workbook

    Hi All,


    I need to make the before process workbook data and formating like after process workbook. Means i need to make before process workbook same formating and fixing the data like after process workbook.


    apreciates your kind help always.


    Thank you

    farrukh
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts
    Hi farrukh

    I have attached a sample workbook that may help you.

    The solution I used was to have a workbook with BOTH sheets in i.e. copy the entire sheet [Beforexls] into the book with the required layout.
    Then it is simply a case of using formulas in the [After[ sheet to 'point' exactly to the required source cells in the imported sheet.

    zeddy
    Attached Files Attached Files

  3. The Following User Says Thank You to zeddy For This Useful Post:

    farrukh (2012-02-15)

  4. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Thank you so much zeddy wonderfull thinking ...

    Thank you
    farrukh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •