Forum Discussion
Clint_E_Hill
Sep 28, 2023Copper Contributor
VBA for Supercharging Copy & Paste Between Workbooks
With details to follow, I ask: What is the level of complexity as well as the VBA programming experience required to code a program that: Allows the user to select data in a source workbook and t...
- Sep 29, 2023
Clint_E_Hill You say the data file keeps changing. Would you be helped if the query would "just" pick up the most recent file in a folder?
JKPieterse
Sep 29, 2023Silver Contributor
Clint_E_Hill You say the data file keeps changing. Would you be helped if the query would "just" pick up the most recent file in a folder?
Clint_E_Hill
Sep 29, 2023Copper Contributor
Thank you for your interest and suggestions.
The initial inquiry is lacking in detail that I will now provide to you.
SOURCE DATA CHANGE REASON
The source data changes as it is provided on a job-by-job basis from a customer in the form of an automatically generated, multi-worksheet workbook. The source data we need is stored in a consistently named worksheet.
CURRENT MANUAL PROCESS
Currently processing our purchase order worksheet (based on a workbook template) includes the user selecting the range in the customer workbook, manually pasting the range, deleting blank rows in the item list section.
Making it a real pain: The user now includes formulas in the destination worksheet. As a part of this proposed P.O. improvement , these formulas will be transferred to a separate worksheet, removing a significant dependency.
MAIN INQUIRY / HOW TO
Ideas, tips, or code snippets of VBA to automate the following two steps are appreciated.
1.) In the source worksheet, the program is invoked by the user requesting a range.
2.) With the destination workbook open, the program populates (values only) data from the source range onto the destination item list.
3.) A predefined row defined in the program acts as its starting point.
4.) The source data populates the item list, rows are adjusted (with blank rows deleted).
5.) The program continues until a row containing the text string ‘Total’ is detected.
6.) The ‘Total’ row is preserved as is the successive PO data as their rows are advanced.
7.) The program ends.
Thank you,
Clint
- JKPieterseOct 02, 2023Silver Contributor
Clint_E_Hill I've replied to your email