In this tutorial we are going to merge excel files into one results file for uploading to an accounting system. Get the spreadsheet used in the tutorial above. Also get updates when new blog or video tutorials are released. Submitting... A reader's workflow … [Read more...] about Question Time – Excel VBA – Consolidate Data From Different Sheets
Questions and Answers
Question Time – How To Duplicate Rows Then Adjust Duplicates
A reader needed a VBA routine to loop over financial data in Excel and insert duplicate rows for each financial transaction and modify the duplicated row. Even if you are not interested in this specific problem you will find the coding techniques used here to be very useful for your other projects. Check out the solution in the video above, also I can email … [Read more...] about Question Time – How To Duplicate Rows Then Adjust Duplicates