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: 22

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 Question
Filtering/Copying a table via VBA.
Replies
2
Views
384
frobeniusabnorm
F
ChrisMac1
  • Question Question
VBA - Compare specific data in one column on one sheet, with the same column on 4 other sheets, copy specific cells if match found.
Replies
1
Views
369
ChrisMac1
ChrisMac1
L
  • Question Question
Need a way to quickly format reports; ran into a problem with slow VBA, need a workaround.
Replies
9
Views
226
SeniorNewbie
SeniorNewbie
Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
198
cooleomter
C
melewie
  • Question Question
formula to return cells in a row based on 2 conditions
Replies
4
Views
382
arthurbr
arthurbr

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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