Hello Mr.Excel gurus,
After failing to find a similar situation and failing to combine some code from various other posters, I am new to this site and by comparison to the people here, I would say I am a novice, but do have a few years of rather broad Excel and related MS applications experience. I am just horrid at coding and essentially brand new to VBA
. Introduction aside, here is my issue I could use much guidance/assistance with:
Through some back end manipulating, I have created what I call a Reference Workbook that is updated automatically by an Access Database (MS Query) linked to SQL Server. Due to sheer size of the multiple sets of data being pulled, I found it best to use this Workbook as a reference file for the thousands of forms (Excel files) that will parse the data sets.
FOR the purpose of my issue, I have set up a daily updated secondary Workbook called "462Track" (the source) that contains all the data (18 columns) I need to pull into a Master Workbook called "FY2015 - Tracking Sheet" (the Destination) based on YESTERDAYs date. I have attached links both files at the bottom as I am a visual person myself.
Final Core Product: When a user opens the FY2015 - Tracking Sheet Workbook, all they would have to do is click a Form Control Button (or ActiveX) and based on the current date, the VBA module will open/close the 462Track Workbook, pulling in any rows of data for yesterday and pasting into the FY2015 - Tracking Sheet Workbook.
-Note: this will run day after day. Also, on Mondays, we account for forms submitted on Friday,Saturday, and Sunday. So if 10 forms were submitted each of those days, the total reported on Monday would be 30. All 30 rows, would have to be pulled in when the user clicked the button activating the VBA. This last part is likely extremely tedious, so If the gurus could provide assistance with the core product, I'm sure, I could figure out a way to do the rest.
462Track
https://drive.google.com/open?id=0B_xMAIsvizExc3YxLUZJdDJfNGs
FY2015 - Tracking Sheet
https://drive.google.com/open?id=0B_xMAIsvizExUkxzeDR6YWFaMzg
After failing to find a similar situation and failing to combine some code from various other posters, I am new to this site and by comparison to the people here, I would say I am a novice, but do have a few years of rather broad Excel and related MS applications experience. I am just horrid at coding and essentially brand new to VBA
. Introduction aside, here is my issue I could use much guidance/assistance with:Through some back end manipulating, I have created what I call a Reference Workbook that is updated automatically by an Access Database (MS Query) linked to SQL Server. Due to sheer size of the multiple sets of data being pulled, I found it best to use this Workbook as a reference file for the thousands of forms (Excel files) that will parse the data sets.
FOR the purpose of my issue, I have set up a daily updated secondary Workbook called "462Track" (the source) that contains all the data (18 columns) I need to pull into a Master Workbook called "FY2015 - Tracking Sheet" (the Destination) based on YESTERDAYs date. I have attached links both files at the bottom as I am a visual person myself.
- Column C contains the Date Criteria.
- It must be yesterdays date as we have a 1 day lag in reporting (IE Yesterdays forms received will be reported and assigned today)
- All Columns from A to R (18 columns) should be pulled automatically from the 462Track Workbook, into the FY2015 - Tracking Sheet Workbook.
Final Core Product: When a user opens the FY2015 - Tracking Sheet Workbook, all they would have to do is click a Form Control Button (or ActiveX) and based on the current date, the VBA module will open/close the 462Track Workbook, pulling in any rows of data for yesterday and pasting into the FY2015 - Tracking Sheet Workbook.
-Note: this will run day after day. Also, on Mondays, we account for forms submitted on Friday,Saturday, and Sunday. So if 10 forms were submitted each of those days, the total reported on Monday would be 30. All 30 rows, would have to be pulled in when the user clicked the button activating the VBA. This last part is likely extremely tedious, so If the gurus could provide assistance with the core product, I'm sure, I could figure out a way to do the rest.
462Track
https://drive.google.com/open?id=0B_xMAIsvizExc3YxLUZJdDJfNGs
FY2015 - Tracking Sheet
https://drive.google.com/open?id=0B_xMAIsvizExUkxzeDR6YWFaMzg
