Results 1 to 6 of 6

Thread: Costing schedules

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-23-2010, 09:58 AM #1
    lee2boy
    lee2boy is offline
    VBAX Regular
    Joined
    Feb 2010
    Location
    uk
    Posts
    15
    Location

    Costing schedules

    Chaps
    is there any of you clever chaps out there that can please take 10 mins and see if any of you can help me in simplifing the spread sheets attatched.
    I have to populate with different margins and quanties for each sheet when i do my pricing for each task.
    Is there any way of using VBA to speed the process up
    Thanks if anyone can help
    Regards,
    Lee

    Chaps I can't attach the spreadsheet as it is 3.7mb in size could any of you please forward your email so i can forward the workbook
    Reply With Quote Reply With Quote
  2. 04-23-2010, 10:01 AM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,478
    Location
    Try zipping it.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  3. 04-23-2010, 10:14 AM #3
    lee2boy
    lee2boy is offline
    VBAX Regular
    Joined
    Feb 2010
    Location
    uk
    Posts
    15
    Location
    I tried that but is still over 1.1mb
    Lee
    Reply With Quote Reply With Quote
  4. 04-23-2010, 10:17 AM #4
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,478
    Location
    If you enable private messaging I can send my email address.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  5. 04-23-2010, 10:29 AM #5
    lee2boy
    lee2boy is offline
    VBAX Regular
    Joined
    Feb 2010
    Location
    uk
    Posts
    15
    Location
    cheers pal, try it now it should be enabled
    Lee
    Reply With Quote Reply With Quote
  6. 04-23-2010, 10:56 AM #6
    lee2boy
    lee2boy is offline
    VBAX Regular
    Joined
    Feb 2010
    Location
    uk
    Posts
    15
    Location
    Its coming through the Ether now
    Lee
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules