Hi,
I have a large number of a standardized excel spreadsheets in a single folder that I need to make a summary document of. The standardized spreadsheets contain multiple tabs and I only need to record values where data has been entered in a particular worksheet.
I need someone to design a spreadsheet for me that will do the following
1) Create and save a summary workbook in a named directory
2) Record the value of a particular set of values in each worksheet in each workbook where the entry is not empty. For all files stored in a named folder
3) Display the information in a neat and user friendly way
4) Should be able to update the summary workbook with new files that have been added to the directory
I will supply the standard spreadsheet to be summarized to the selected bidder.
Kind Regards,
Fergal
Hi, your 5-star excel and vba coding expert is ready to help you. kindly get back to me if you wish to proceed with a top-rated and reliable expert here...regards,
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
Can do. This kind of thing is something I do often. Please check my reviews for Excel work.
Perhaps you need a reusable tool that could be pointed at (for lack of a better description) a target folder and would then create (or update) a summary workbook for the folder. The original could be copied from a template (or model) empty summary workbook.
Sound right?
Hello, I'm an expert C# developer. I've experience dealing with Excel files. Do you consider the option to have Windows Desktop application to read the excel files and create the summary sheet? If so, please check PM