Categories List

[av8tordude]

Can someone assist with a code that will take a list of items in one table and group them in another table. I provided and example of how I would like the "group" table to look. Thanks for your assistance.

[Paul_Hossler]

How 'hard' is the requirement to match the formatting?

I think a pivot table would be the easiest and most flexible

Paul

[Paul_Hossler]

How 'hard' is the requirement to match the formatting?

I think a pivot table would be the easiest and most flexible

Paul

[av8tordude]

Hi Paul,

I was not able to open you file b/c its in a php format.

The code I've been using before has been sufficient until now b/c I need the columns its using and I don't know how to change it to copy only the data I need to the correct table. if you run the code, you can see it does what I want it to do, but it also copies other information which I don't need and it would not fit correctly in my table. Can you assist

[av8tordude]

Bump...Any help would be greatly appreciated. Thanks

[mancubus]

hey av8tordude. what Paul posts is a pivot table with an added calculated field. the design of PT: Row Labels: Description / Values: Receipt No. (Count), Amount (Sum), Reimbursed (Sum) / Calculated Field: Field Name = "Net" and Formula = "=Amount-Reimbursed"

[av8tordude]

Mancubus..I've tried downloading and opening the file, but its a file that saved as .xlsx, which I can't open.

[mancubus]

av8tordude. a bit confused. you open (and upload here) xlsm file but cannot xlsx?

[av8tordude]

Ok...I managed to open it. Thanks

[Paul_Hossler]

@av8todude

If the Summary Data Descripton's are not very dynamic, you could use CountIf and SumIf WS formulas possibly

Otherwise, you could load and process the Inputs using arrays and then make the Outputs the way you want

Paul