Loop through rows and match values 1

[acent]

Greetings.

Doing this in Access would be rather simple, however, Access is a last resort due to higher forces conspiring against me. That asid, what am doing is populating an Excel spread sheet that has cells as follows:
partNo, Description, Month 1 sales, Month 1 Gross Margin, Month 1 ending inventory, Month 2 sales, Month 2 Gross Margin, Month 2 ending inventory, ... , Month 24...

The data will come to me by way of 2 spreadsheets for one Month's data only, containing only certain parts of the required data. Every part number will not be listed every month causing a miss match of data if I were to simply copy columns.

Therefore, I thought of writing some VBA to try and loop through all rows so that 24 months of data can be easily formatted, however, I have no clue where to start. I'm more famous with Access, but as I said, due to high forces conspiring against me, that is a last resort.

Any help is appreciated.

"If you say you can, or you say you can't, you're right!"
-- Henry Ford

 

[firefytr]

Would it be bad if I said that you needed to use the last resort? ;-)

If not, I would recommend you creating a sepearte column for the month, then only have 6 columns (partNo, Description, Month, Sales, Gross Margin & Ending Inventory). Then you can use a Pivot Table to crunch your data for you.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[acent]

Thanks for the response. I will use Access. If they don't like it, well, as they say in Oklahoma- "It ain't easy pushing west. Somedays you win a few, somedays you lose."

My last day here is Monday anyway.

Thanks,


"If you say you can, or you say you can't, you're right!"
-- Henry Ford

 

[firefytr]

Well good luck with it!

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci