Did you know that Excel sorts data, processes data and compiles data? As I’ve said in previous articles, there’s virtually nothing Excel can’t do with data.
Once, a manufacturer received a multi-store report with no page breaks from a vendor. The manufacturer needed separate pages for each store, but he wanted to stop manually going through the reports and putting in page breaks before printing them.
The solution to that problem was to write a macro that went through the large report and logically figured out the page breaks according to the store codes and line breaks.
Excel also works really well with data over different worksheets. A client was given a spreadsheet with more than 200 worksheets with about 30 data elements on each sheet. Her task was to combine all the information into one sheet so it could be used as a master roster. She didn’t want to copy and paste each field, which she estimated would take a week.
By coming up with a formula that combined all the data in seconds, it saved her hours and hours of copying and pasting each cell.
Finally, if the data is repetitive, Excel can process it. A client had some extremely large data files that he got from his ongoing clients. This data was uploaded into the main system to update information. The problem was the clients often supplied invalid data, causing the updates not to load and causing delays in processing the information.
By writing a spreadsheet that reviewed all the data files and showed all the errors before they went into the main system, the files were cleaned up before the main load, thus saving countless reloads.
For more information on how to find the right web developer, contact Warren Schultz at firstname.lastname@example.org or call him at 818-281-7628.