Hello all,
I have been working on putting together this new quoting tool for the group and I have a good deal done with Minimal coding required. However, I have ONE thing that i have been stuck on for a few days.
In the attached workbook, you will see that there are a number of tabs. I Specifically need to pull Data from the (Professional Services),(Materials), (Maintenance), and (Add-Alt) tabs, and Copying validated data to the (EstSummary).
- Source data begins at B13 (Typically the service description.)
- A function to loop down the column to the end and create a dynamic array
- A copy of that data and a lookup on the (EstSummary) destination start target cell (C21 and H21) to identify if that sheet is clear. If not, ask if I want to clear it...
- If (EstSummary) is clear, then paste the range data into the column
- Same for the other tabs appending to the bottom of the first tab's data and so on
- I Would LOOVE it if the data that gets pasted could be dynamic as well. Forgive me for not being more clear but i am very new to VBA and am reading a ton. But im tired and i need help...
- I will use conditional formatting to get the estimate page.
I have attached the file for your reference.
Thanks so much for taking a look.. It is a bit messy while still in draft.
Best,
Paco
Bookmarks