Sort, calculate and paste results based on specific criteria

[macrorookie]

Hello, and happy Sunday.

I am trying to extract specific rows of data, pick certain cells out of those rows, calculate those cells (based on predetermined formulas), and then paste them into a table. And, frankly, I'm overwhelmed with the idea of doing all of this in a macro. Yet I believe I need a macro for this function. I put together a spreadsheet that lists everything I want to do, with sample source and destination sections, and relevant comments about my challenge. Anyone out there, who is clearly smarter than me, up to the challenge -- to get me started?

I sincerely appreciate any help! Any help would be big!!!

Jeff

[mikeTRON]

So you have approached this problem in a good way by listing out everything you are trying to accomplish, I always suggest people break the big project or problems down into manageable ones, so you are on the right track.

Okay, so why do you need a macro to create a bunch of tables? Why not just create a dashboard that does all the calculations for you and leave all your data in ONE source data table and allow you to have a dropdown on the UniqueIDs.