- On click of the buton Add can have the row added towards last with Project ID from instructions sheet, and the Item Number increased by one, date todays date and the rest column blank.
Relevant Skills and Experience
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
Proposed Milestones
$30 USD - Day1 - Add button functionality
Execl Expertise:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl