Formula/VBA Help

M

Mattandy55

New Member
Joined
May 27, 2016
Messages
20
Hi all, not sure if it's just a combination of it being Friday afternoon or bouncing between too many projects at once. Looking for some assistance.. I currently have a report that uses ODBC queries to populate information and it works great however I received a request for an edit. I need the report to look like the attached example.. I'm stuck trying to figure out the workflow and then putting it into a VBA code to auto populate when we hit run. Bascially the "Job" will come from a advanced filter query on Sheet Qry2B, the "Crew" comes from Sheet Qry1b. I am stuck trying to get the unique crew name from sheet Qry1B based on the job and then as soon as the unique names are done to switch to the next Job from my Qry2B advanced filter result and repeat the crew process. Any assistance or help would be greatly appreciated as I am just kind of stuck.

Thanks,

Matt
 

Attachments

  • Excel Example.png
    Excel Example.png
    21.8 KB · Views: 9

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
What version of Excel are you using? What does the raw data look like?
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
Filtering/Copying a table via VBA.
Replies
2
Views
124
frobeniusabnorm
F
melewie
  • Question
formula to return cells in a row based on 2 conditions
Replies
4
Views
257
arthurbr
arthurbr
J
  • Locked
  • Question
Still need help on a daily summary sheet
Replies
1
Views
297
Fluff
Fluff
S
  • Solved
add a message box if a match using a userform list box doesn't match
Replies
7
Views
145
still learning
S
S
  • Solved
Copying Filtered Columns (non-adjacent) from one Table to end of another, but need to also add information in adjacent column of Destination Table
Replies
1
Views
354
sspatriots
S

Forum statistics

Threads
1,215,093
Messages
6,123,068
Members
449,091
Latest member
remmuS24

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top