+ Reply to Thread
Results 1 to 6 of 6

Consolidating worksheets

  1. #1
    Registered User
    Join Date
    07-07-2009
    Location
    Western Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Consolidating worksheets

    Hi

    Could someone please please help me with the following;
    I am needing to do a spreadsheet with 4 different tabs that when you click on a merge button it will automatically transfer all the data to another worksheet labelled Completed. This would include if one of the tabs deletes a line the line will automatically delete off the completed sheet when the merge button is clicked.
    ON all sheets they have to be sorted via date descending date order
    They all have to have a button which will collate the information.
    I need to lock certain columns.
    I need to create a print macro button which when clicked will allow the user to print automatically.

    Is this possible? I would appreciate any help, even if half of it
    Last edited by Cand; 07-09-2009 at 02:26 AM. Reason: Change title and add spreadsheet attachment

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Automating Spreadsheets

    Cand, please take a moment to read the forum rules and then amend your thread title to something more descriptive of your problem.

    Also, try asking just one question per thread, and be descriptive of your data and layout. Or better yet, upload a sample spreadsheet that also shows your expected results.

    Thanks!

  3. #3
    Registered User
    Join Date
    07-07-2009
    Location
    Western Australia
    MS-Off Ver
    Excel 2003
    Posts
    6
    Thanks have attached now
    Last edited by Cand; 07-08-2009 at 10:00 PM. Reason: Deleted

  4. #4
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Merging Worksheets

    hi Cand,

    Welcome to the Forum

    Ooopps!
    You missed part of Paul's request, by amending your thread title (in your first post), you make it easier for people to quickly identify if they can help you & you help in creating a more searchable archive of solved problems.

    An example of a more suitable title could be something like "conditional consolidating of separate sheets within a file".

    Personally, I would suggest redesigning your file to use a single sheet "database style layout" with an extra column to identify if the item is Complete.

    If no one else looks into this before I check again, I may be able to help if you upload another example file which has been saved in compatibility mode for Excel '97-2003 .xls format.

    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

  5. #5
    Registered User
    Join Date
    07-07-2009
    Location
    Western Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Merging Worksheets

    Thanks heaps this is where stress leave comes into it. I'll keep trying while i stay glued to the forum.

  6. #6
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Consolidating worksheets

    Hi Candy,

    There shouldn't be any need for stress leave around here

    Yes, what you've asked is definitely possible - can you please upload your sample file again using the ".xls" format?

    Rob

+ 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