+ Reply to Thread
Results 1 to 3 of 3

Summary sheet update keeping set columns in place

  1. #1
    Registered User
    Join Date
    03-11-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    11

    Summary sheet update keeping set columns in place

    Hi folks - looking for any help possible here...

    using code to take raw data from one workbook <book1> tab <Phase1RawData> and pasting to summary workbook <book2> onto <SummarySheet>. New data is available with each Phase (14 in all) and will eventually fill all cells as indicated in the Summary Sheet Page. However raw data has in any one Phase only the columns up to the Phase its currently at. So Phase 1 will only have Phase 1 column, Phase two will have columns for Phase 1 and 2, Phase 3 will have 1,2,3 and so on (the example Book1 has two example sheets for phase 1 and phase 2 data - so each phase has a column added with the previous columns remaining.)

    The problem is in having the summary sheet always show all 14 phases colmns (as in the example attached) irrespective of which Phase is being updated. So if up to Phase 3, insert the raw data available will be colmns for Phase 1, 2 and 3 - but I need ensure after that has been updated only the remaining Phase colums to 14 show. That is, if Phase 1, 2 or 3 etc are now in place, insert the remaining blank Phase columns to, and including Phase 14. Need to do this at end of each phase until 14 is met.

    The data up to column S is all from the raw data original sheet - Items from Column T I insert independantly as the data is transferred.

    Appreciate any neat way of doing this - example sheets attached.
    Attached Files Attached Files
    Last edited by LLEW11; 04-07-2009 at 06:10 AM.

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Summary sheet update keeping set columns in place

    I added macro 'Macro1' in book2.xls.

    This macro should do what you need.

    Regards,
    Antonio
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-11-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Summary sheet update keeping set columns in place

    Thankyou Antoka05, solved.
    Really appreciate your help with this, thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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