Results 1 to 6 of 6

Thread: Adding function without messing up original code

  1. #1
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12

    Adding function without messing up original code

    Hi I have attached a copy spread sheet.
    This has been working great but i have been asked to add some items and i dont want to screw up the working functions.
    I now want to add a columns so the actual costs of a first and second service can be added to the contracts and used contracts sheets,
    this information allong with cutomer,reg,start date needs to be copied over into a new report sheet which will have the budgets costs in so that
    a report can be sent showing profit/loss.

    If i just add columns will this effect the auto archive coding?
    Could the data be copied over to the new sheet using the original code on start up? (so customer etc copied then as cost are put in these would be added
    to the respective rows on each start up.

    I hope i have explained this ok ?

    Regards

    Peter



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg. 9gJzxwFcnPU9gORqKw5tW_
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxUbeYSvsBH2Gianox4AaABAg. 9VYH-07VTyW9gJV5fDAZNe
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgyhQ73u0C3V4bEPhYB4AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgzIElpI5OFExnUyrk14AaABAg. 9fsvd9zwZii9gMUka-NbIZ
    https://www.youtube.com/watch?v=jdPeMPT98QU
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 09-22-2023 at 05:16 PM.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Last edited by DocAElstein; 12-14-2023 at 02:40 AM.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    hi

    i was going to add them after 6 but any where will do

    the codeing do ther following

    there is an auto archive so that once the contract has ended the complete row is transfered into the archive sheet and then if not re activated after a set time the same data is deleted from the archice file so as not to let the data clog up with out of date information.
    there is also coding checking for duplicated reg numbers the looks in contract , used sales and the archive sheets so that duplications dont occur.

    i was hoping to have the data mentioned in this nlink to be copied into a report sheet at start up when the macro runs to check validation dates and then when an invoice comes in and we add a cost into the 1st service cell this would be added to this copied data

    hope this helps

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg. 9gJzxwFcnPU9gORqKw5tW_
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxUbeYSvsBH2Gianox4AaABAg. 9VYH-07VTyW9gJV5fDAZNe
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgyhQ73u0C3V4bEPhYB4AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgzIElpI5OFExnUyrk14AaABAg. 9fsvd9zwZii9gMUka-NbIZ
    https://www.youtube.com/watch?v=jdPeMPT98QU
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 09-22-2023 at 05:14 PM.

  4. #4
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    Hi

    I have attached a small wb to explain what i am trying to do

    i need columns a,b,e,f,g,h to the a report sheet (sheet2) when populated and then updated when any of these cells are changed
    so that when a cost for the first service is entered this would update the row in the record sheet to reflect costs.

    The original wb has macros that are started each time the file is opened the auto archives old date according to date

    The data copied should by unique to reg number so duplications copying does not occur ( the original macros should stop duplication anyway)

    The auto cleanse macro will eventually delete a row when the contract expires but the data in the report should stay

    Hope this makes thing clearer

    Peter
    Attached Files Attached Files

  5. #5
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    Hi Again

    I have attached a small wb with a formula that mirrors certain data entered on sheet one into sheet 2, now this works well except
    i could do with the data to get mirrored to the next available blank row in sheet two as the auto delete function in the original wb
    would leave blank rows.
    And not all the old data already in my files will have these costings entered in straight away.
    Is there away to have this happen in vb

    also is there away to export all expired rows in sheet two to a perminent archive sheet to hold these records

    Regards


    Peter
    Attached Files Attached Files

  6. #6
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    Hi

    In the last wb test 2222 there is a formula to mirror dats from sheet1 into sheet 2 is there a way i can get it to enter the data in the first available row with
    a blank cell in column a?

    The data in sheet 2 will get auto deleted when the contract expires so will leave blank rows dotted around


    Any Help would be appreciated

Similar Threads

  1. UDF (user defined function) replacement for Excel's DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 21
    Last Post: 03-07-2015, 09:47 PM
  2. adding entries into combobox with code
    By paul_pearson in forum Excel Help
    Replies: 1
    Last Post: 07-23-2013, 01:01 PM
  3. Adding charts via code to a protected sheet
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 11-14-2012, 05:11 PM
  4. Adding values less than zero
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 07-14-2012, 11:55 AM
  5. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM

Posting Permissions

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