+ Reply to Thread
Results 1 to 11 of 11

Make the project working if there are initially no records for Service.

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Make the project working if there are initially no records for Service.

    Hi guys

    The attached project works absolutely fine. My only problem is now my clint wants me to make a start empty . That means intially there should not be any service in any of the excelsheet and we have to enter a new service using the userform1.

    The projects works fine if there are entries already present in the excelsheets but i want to make it work if there is no entry intially.

    There are about 6 sheets, each has different format. Can anyone please help me to make it working.

    Thanks a lot.
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Make the project working if there are initially no records for Service.

    If you're just looking for the next blank row, you could use, for example:

    Please Login or Register  to view this content.

    If you're looking for the last used line, then:

    Please Login or Register  to view this content.

    This would give you the header row the first time through so you might be better with the first option ... you'd be inserting a row *before* the next blank row.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Make the project working if there are initially no records for Service.

    When you say "client", is this a project you are charging for? If it is then I would be very careful, it is nowhere near ready for use!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Re: Make the project working if there are initially no records for Service.

    Thanks TMShuks for your reply. I have made the first two sheets working "Volume Input","Rate card-time" but can you help me to make "staff requirement" sheet working.
    I want to make all the formulas in the cells working. The formulas of staff requirement sheet are there in the last post attachment.

    Now as the table is blank so how to write the formulas for each new row using code.

    Please find attached the modified Project copy and help me to make "staff requirement sheet" working.

    Thanks

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Make the project working if there are initially no records for Service.

    No attachment.

  6. #6
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Re: Make the project working if there are initially no records for Service.

    oh sorry. Please see attached.
    Attached Files Attached Files

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Make the project working if there are initially no records for Service.

    Change:

    Please Login or Register  to view this content.

    To:

    Please Login or Register  to view this content.

    However, you will need to get rid of the blank row A4 which adds nothing.

    With regard to the formulas, I can't really help. You should use VLOOKUP or INDEX/MATCH to reference the source sheets rather than a simple link. If you have simple links, they will break when you delete rows to which they refer. Then any cells that use those values will also break.

    Are you an Excel consultant? And has the client provided a specification that you are working to?


    Regards

  8. #8
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Make the project working if there are initially no records for Service.

    I have you tested your code at all. There's other errors

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Make the project working if there are initially no records for Service.

    @RoyUK: I've not looked at the code closely, I was just addressing the question(s). But my question around consultancy and specification is more around the layout of the data, etc. Not much in the way of consistency or identity.

    Regards

  10. #10
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Re: Make the project working if there are initially no records for Service.

    TMShruks,

    I have written the following code but it doesn't input the values in specific row. And also, I want condition in this like when the row reaches to A19 then next time insert a new row first and then enter the values in the specified columns.

    Please Login or Register  to view this content.
    Thanks.

  11. #11
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Re: Make the project working if there are initially no records for Service.

    Hi Guys

    I have managed to write the following code. But it doesn't work.
    Please Login or Register  to view this content.
    ANy help would be much appreciated.

    Thanks

+ 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