S
Smangler
Hello all,
I've been reading the posts here and have learned TONS about macros, but I'm
still terribly unfamiliar with them. I'm not even sure if I need a macro for
what I'm trying to do.
Basically I have the following worksheet:
Show Title Date Store Amount V, P, O? Department
Macbeth 2-Jan Shoppers $18.75 visa wardrobe
Corgy and Bess 4-Jan Value Village $12.49 petty cash props
5 women 7-Jan Value Village $18.76 other wardrobe
Oklahoma 3-Feb Who cares? $46.98 visa props
Oklahoma 6-Feb Home Depot $56.75 petty cash paint
5 women 18-Feb Home Depot $100.48 other set
5 women 3-Mar Home Depot $22.75 visa set
Macbeth 20-Feb Home Depot $45.62 petty cash set
Corgy and Bess 19-Mar Christie's $29.75 other lighting
Macbeth 18-Jan Shoppers $12.87 Visa Wardrobe
Show title has a drop-down menu because there can only be up to 7 shows in
this season. V, P, O? is the form of payment (only 3 options) and
Department only has 8 options. There could be hundreds of entries in a
season.
I need to filter for columns A and F (Show title & Department) and copy only
columns B thru E onto another sheet. Lookup didn't seem to work for me
because I have 2 criteria in different columns and I don't want the entire
row pasted.
I tried using the AdvancedFilter Method, but I can't seem to program it so
it will only return data from B through E without returning A and F.
Anybody have any suggestions? Any help you could provide would be much
appreciated!
I've been reading the posts here and have learned TONS about macros, but I'm
still terribly unfamiliar with them. I'm not even sure if I need a macro for
what I'm trying to do.
Basically I have the following worksheet:
Show Title Date Store Amount V, P, O? Department
Macbeth 2-Jan Shoppers $18.75 visa wardrobe
Corgy and Bess 4-Jan Value Village $12.49 petty cash props
5 women 7-Jan Value Village $18.76 other wardrobe
Oklahoma 3-Feb Who cares? $46.98 visa props
Oklahoma 6-Feb Home Depot $56.75 petty cash paint
5 women 18-Feb Home Depot $100.48 other set
5 women 3-Mar Home Depot $22.75 visa set
Macbeth 20-Feb Home Depot $45.62 petty cash set
Corgy and Bess 19-Mar Christie's $29.75 other lighting
Macbeth 18-Jan Shoppers $12.87 Visa Wardrobe
Show title has a drop-down menu because there can only be up to 7 shows in
this season. V, P, O? is the form of payment (only 3 options) and
Department only has 8 options. There could be hundreds of entries in a
season.
I need to filter for columns A and F (Show title & Department) and copy only
columns B thru E onto another sheet. Lookup didn't seem to work for me
because I have 2 criteria in different columns and I don't want the entire
row pasted.
I tried using the AdvancedFilter Method, but I can't seem to program it so
it will only return data from B through E without returning A and F.
Anybody have any suggestions? Any help you could provide would be much
appreciated!