£30 Automate Spreadsheet

    Hi Guys,


    I am trying to build a spreadsheet for work. See link.


    https://flic.kr/p/nN41Ks


    Looking for “New Client” Button. When I click this it will ask what pattern I want to use (Pattern 1,2,3,4). When I choose the pattern it will give me 5 times, one for each day in the pattern and will populate these times with the clients name. I need the client to stay in these times in this pattern for 4 weeks. After 4 weeks I need the clients name to be moved to the next pattern ie Pattern 2, client given another 5 times in the new pattern and populate the new times with clients name. After another 4 weeks this happens again, moves onto next pattern ie pattern 3 etc.
    I need this to happen continuously moving client from pattern to pattern every 4 weeks after reaching pattern 4 it goes back to pattern 1.

    I have to say that the client may not start in pattern 1 but I need them to move through the patterns until they have been removed from the spreadsheet.

    I hope this makes sense.


    Edineo

    Re: £30 Automate Spreadsheet


    Cytop are you going to take this on? If not I would be interested depending on time frame.

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




    Re: £30 Automate Spreadsheet


    I am going to need to get you to give me a sample workbook rather than a single graphic. You want a button that asks for the pattern to apply to a new client however I guess you will also want to enter the clients name as well and perhaps a time? From the image I cannot really discern the patterns to which you refer. I am not sure how the client exits the worksheet - is it after rotating through all 4 patterns or how does the client get removed? I am not sure if this is all on one worksheet or is distributed over multiple sheets.


    The best way to demonstrate what you require is to give me a sample workbook showing me how a client moves through the various patterns. You also need to define these patterns for me - what constitutes a "pattern". Some background would perhaps give me a better understanding as to your requirements.


    If you could create a sample workbook with a few dummy clients, include all 4 patterns to which you refer (making sure you show/define what constitutes a pattern) and show me exactly what has to happen step by step - i.e. how does the client rotate through the patterns. You say that the client stays in the pattern for 4 weeks then moves to the next - show me how you want the patterns displayed - is a 4 week block on 1 sheet or over multiple sheets. A sample workbook with dummy clients and some text boxes explaining how your algorithm works will make this clearer. The requirements are a little too vague at this point for me to make a start.


    If there is anything confidential that you do not want to divulge in this thread you can PM me however if we could communicate as much as possible via this thread that would be good.


    Finally what is the time frame for completion of this project?

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




    Re: £30 Automate Spreadsheet


    Hi Anthony,


    Thanks for getting back to me. First of all how do i attach a sample workbook to the thread? Once you have got the workbook then it will make it easier for you to understand what i want it to do. The time frame would be hopefully the end of the week but this is not set in stone. I want it to work right more than rushing it.


    Thanks again.


    Red

    Re: £30 Automate Spreadsheet


    To attach the file select "Go Advanced" (just below the text box where you type in your message) and then use "Manage Attachments", Add File to select the excel document and then hit Done when finished. There is a limit on the file size so if you have any issues I will PM you my email address and you could always email it to me if you have trouble attaching the document. I would prefer to communicate via this thread however if needs be you can always email the document.

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




    Re: £30 Automate Spreadsheet


    Thank you for the spreadsheet and further clarification - I sent you some additional questions - if you could answer these for me as well please. Will have this finalised by the end of the weekend for you

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




    Re: £30 Automate Spreadsheet


    Payment received - thank you - will make the required changes and send a new revision as per my email

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login