- Have good expertise in Excel macros and VBA
- Can get the drop downs built dynamically, ie each drop down showing values based on the previously selected Dropdowns.
- Modify to print on ledger paper size for the prints given.
- Can get the fonts and heading, and the prints based on the uniform formatting.
- On click of the button will get the dataset locked, so that it cant be edited, until you unlock it.
There are 73 sheets in all, in the attached workbook. Which data needs protection needs to be defined.
- Can discuss further....
SUMMARY
GENERAL
PROCUREMENTCONTRACT
GENERALREQUIREMENTS
EXISTINGCONDITIONS
CONCRETE
MASONRY
METALS
CARPENTRY
THERMALMOISPROTECT.
OPENINGS
... etc...
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- 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 recent projects.