Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Re design spread sheet For $15.00 so everything is not hard coded

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Re design spread sheet For $15.00 so everything is not hard coded

    I'm working on a spread sheet for an internship all the information is in the spread sheet. I need the spread sheet to stay close to the original design the only numbers that need to be hard coded are the individual Total min. and Run time on the table that starts at cell S3 I have formulas for a lot of the spread sheet on the tap line 2016. I would like everything else on the spread sheet to reference the table while it Breaks down the top five category of down times. I would like everything on the tab Line 1 to be easily copied to the others tabs and I can just change the individual Total min. and Run time on the table and reflect line 2 and 3. The pay will be $15.00 dollars through paypal thank you.
    Attached Files

  • #2
    Re: Re design spread sheet For $15.00 so everything is not hard coded

    I can look at this for you.

    Have you paid the 10% to [email protected] ?

    When do you need it done by?
    We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

    Comment


    • #3
      Re: Re design spread sheet For $15.00 so everything is not hard coded

      Yes I have already paid the 10% to ozgrid.com I would like it to be done by next Friday. feel free to inbox me any questions thank you.

      Comment


      • #4
        Re: Re design spread sheet For $15.00 so everything is not hard coded

        What do you mean by "everything is not hard coded"?

        "hard coded" usually refers to a program code that uses absolute values rather than variables. The only macro in your workbook is one where you modified a recorded macro and it will result in an infinite loop.

        If you mean you want some cells in each sheet to have their values derived from a formula rather than the values you have entered then please highlight which cells are involved and attach the file again.

        Thank you.
        We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

        Comment


        • #5
          Re: Re design spread sheet For $15.00 so everything is not hard coded

          I meant everything was hard coded when I have first started working on the spread sheet. I've since enter formulas but I know there is a better way to have the spread sheet designed and the formulas can be improved. I'm currently having trouble in cell B3 trying lookup the name to the corresponding value in the table that starts at cell S3. I have highlighted the cells that I would like to have the formulas in. I would like the formulas to reference the table at S3. Some of the highlighted cells already have formulas but if you feel there is a better way go ahead and make the changes. Feel free to make any changes in the table or the spreadsheet as long as the charts reflect the correct information. thank you. There are formulas in the table that starts at S3 and they are correct in that table and the numbers that are hared coded have to be enter manually so there are no formulas need for that part of the table. Thank you.
          Attached Files

          Comment


          • #6
            Re: Re design spread sheet For $15.00 so everything is not hard coded

            Your file is ready, I will PM you with my PayPal details and attach the file here upon receipt of payment.
            We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

            Comment


            • #7
              Re: Re design spread sheet For $15.00 so everything is not hard coded

              I've sent you the money through pay pal please send the file thank you.

              Comment


              • #8
                Re: Re design spread sheet For $15.00 so everything is not hard coded

                Payment received, many thanks.

                Your file is attached.
                Attached Files
                We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

                Comment

                Trending

                Collapse

                • maichal
                  auto generate id in user form save sale purchase data on sale & purchase sheet
                  maichal
                  i am add add sale transaction & add purchase transaction command button & the id was Auto generate in text box 1 if i am choose sale in combo box 1 than sale-001 id was Auto generate in text box 1 add the name in combo box 2 & click on add sale transaction command button the data was add on the sale sheet,if i am choose Purchase in combo box 1 than Purc-001 id was Auto generate in text box 1 add the name in combo box 2 & click on add Purchase transaction command button the data was add on the Purchase sheet, please solve this sir, after add the information in sale & purchase excel sheet, i am choose sale in combo box 1 the id was auto generate in id text box 1, than i am choose the name in combo box 2, if i am choose sale in combo box 1 than combo box 2 show only sale Customer...
                  3 days ago
                • DiogoCuba
                  US$20 to Automate Crew Roster
                  DiogoCuba
                  Hi, I have a Crew Roster that controls the crew changes of a certain vessel and I would like to automate it to avoid wasting time with manual copy and paste.

                  Anybody willing to help me?

                  Some of the actions I need:
                  • Create a Pax list and a Flight Manifest based on the personnel assigned to embark and disembark;
                  • Generate a Daily POB based on the names that are onboard (Including the dates of embark and a counter to count how many days the person is onboard);
                  • Compare the Daily POB to a criteria to see if the safe manning is compliant or not;
                  • Create a PAX LIST for the next 7 days automatically so that I can see who is crew change and who is not - this should be triggered based on the dates;
                  • Auto generate Flight Manifest when I click a button and input the
                  ...
                  June 27th, 2017, 09:47
                Working...
                X