Spreadsheet Coding Help
Budget: $250 – $750 USD
I need assistance with coding a spreadsheet, specifically with formulas and calculations.
Description:
Okay so this is the brief of what I want to do and I dont know what is exactly possible but thought one of your excel gurus would probably figure it out in like 5 mins and could maybe give me some direction:
Attached is the spreadsheet which we want to keep all of our jobs that we do in one place so we have the job cards auto populating form the main table and will give us data on the work we have done.
I have created the main sheet so as you populate each cell (some are data validation drop downs and some are manual inputs) it pulls through to the job card sheet.
How do I make it so each line creates its own job card? I have just done a simple formula for Line 1 but need it that a new job card is created for each line.
Secondly I have a few extras I would like to know if are possible?
In the date column is it possible to have a smart calendar where you click on date instead of excel always changing the date formulae you put in? Some sort of data validation?
I need to add a column for client phone number and a column installation date also with a smart calendar but I didn't want to try this before other things are potentially changed.
Lastly for each job card not all cells need to be filled in. When you look at the job card I have created it puts a zero in the cell if there is no information in it which does not look nice. Is there a way so that the cell is just blank if no information is needed in it.
Essential tasks include:
- Crafting and troubleshooting logical formulas (IF, AND, OR, etc.)
Ideal skills and experience:
- Proficiency in spreadsheet software (Excel, Google Sheets)
- Strong understanding of logical functions
- Experience in problem-solving and formula optimization
Description:
Okay so this is the brief of what I want to do and I dont know what is exactly possible but thought one of your excel gurus would probably figure it out in like 5 mins and could maybe give me some direction:
Attached is the spreadsheet which we want to keep all of our jobs that we do in one place so we have the job cards auto populating form the main table and will give us data on the work we have done.
I have created the main sheet so as you populate each cell (some are data validation drop downs and some are manual inputs) it pulls through to the job card sheet.
How do I make it so each line creates its own job card? I have just done a simple formula for Line 1 but need it that a new job card is created for each line.
Secondly I have a few extras I would like to know if are possible?
In the date column is it possible to have a smart calendar where you click on date instead of excel always changing the date formulae you put in? Some sort of data validation?
I need to add a column for client phone number and a column installation date also with a smart calendar but I didn't want to try this before other things are potentially changed.
Lastly for each job card not all cells need to be filled in. When you look at the job card I have created it puts a zero in the cell if there is no information in it which does not look nice. Is there a way so that the cell is just blank if no information is needed in it.
Essential tasks include:
- Crafting and troubleshooting logical formulas (IF, AND, OR, etc.)
Ideal skills and experience:
- Proficiency in spreadsheet software (Excel, Google Sheets)
- Strong understanding of logical functions
- Experience in problem-solving and formula optimization