Need an automated mechanism (e.g. macros or VBA) to take customer-provided spreadsheets (we have hundreds of them, some with many hundreds of tabs), most with identical column names and column order and transfer the data into a single, consolidated spreadsheet (also with a fixed column definition but in many cases the column names of the consolidated spreadsheet are different than those of the customer spreadsheets).
Not all the data from the customer spreadsheets moves into the consolidated spreadsheet. Data in each row will trigger the move (i.e. Publisher = ABC or Publisher = ABC Publishing).
Also, sometimes we have to do a lookup against a SQL Server db to determine if the data in a given row should move. (i.e. if this item ID exists in our database, then move the row into the consolidated spreadsheet).This database is accessible via web service calls.
53 freelancer đang chào giá trung bình $1713 cho công việc này
I am a Management Accountant with 20 years experience and very strong Excel and VBA skills. I've proved myself in the real world, now looking to do the same in the virtual world on this website :) Regards
You better to use Excel Addin method for executing this task, so not repeating on my worksheets at all. This addin will doing all tasks just what VBA/Macro does. Let me know