Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 8 of 8

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

  1. #1
    Join Date
    14th February 2017
    Posts
    4

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  2. #2
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

  3. #3
    Join Date
    14th February 2017
    Posts
    4

    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.

  4. #4
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

    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

  5. #5
    Join Date
    14th February 2017
    Posts
    4

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  6. #6
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

    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

  7. #7
    Join Date
    14th February 2017
    Posts
    4

    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.

  8. #8
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,205

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

    Payment received, many thanks.

    Your file is attached.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 8
    Last Post: September 8th, 2015, 23:57
  2. hard coded vs ?
    By daulpuchich in forum Excel General
    Replies: 1
    Last Post: July 2nd, 2015, 23:38
  3. userform combo box list hard coded in vba
    By schimmey in forum Excel General
    Replies: 12
    Last Post: January 19th, 2014, 00:57
  4. Replies: 1
    Last Post: July 2nd, 2011, 11:12
  5. Indentifying Hard Coded Cells
    By ORANGEBEE in forum Excel General
    Replies: 2
    Last Post: May 12th, 2011, 03:25

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
  •  
porno