- Can look through the format of the data sheet, as you had mentioned it being in same format the data could be pulled into Excel into respective columns for further processing.
- Have done similar extraction of data from Text files.
- Using the coding logic get the right data into respective columns for further processing.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- 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