Someone Write me a macro?

Science & Technology Information Technology, Gaming, Machines, Gadgets
1

Please?

I’ve got an excel sheet w/ multiple tabs.
All of them have categories such as:
USD Comments
Fund Broker Curr Settle date Trade Date Name Instr Type Trader Order_ID Tid Cash Citco

for each Cur.

I need a macro that will select the data from multiple tabs and dump it in a new tab then create a summary pivot.

I’ve already set up the summary tables I just need someone to write me a nice macro that will collect/ dump data and refresh the pivots.

Koyee hai mayee ka lal?
:hehe:

Sorry I had too - I’ve written a macro but I can’t get it to select the proper data (because its not consistant which cells are populated vs empty).

2

Re: Someone Write me a macro?

How much you are willing to pay ?? :stuck_out_tongue:

3

Re: Someone Write me a macro?

Tons of grattitude?

4

Re: Someone Write me a macro?

record the macro - ?

5

Re: Someone Write me a macro?

HAA! *gratitude *in this economy?

No, seriously?

6

Re: Someone Write me a macro?

I tried that but because the rows aren’t constant it doesnt work. I need a smarter macro. :slight_smile:

I AM SERIOUS! jeez do a sister a favor.
Its for personal use. :stuck_out_tongue: