Find a value in a range and paste

[randy2059]

In row 5 I have the months of the year in cells A1 through L1. Jan, Feb, Mar, Etc. in cell P1 is the current Month. Let's say March.

I'm trying write a macro that will copy a range of formulas located in P2:P25, find the month value located in cell P1 in the range A1:L1, go down 1 row then paste the formulas. ie copy range of formulas, find P1 (march) in range A1:L1 (find it in cell C1) go down one row to C2, and past the formulas.

[AlphaFrog]

Please Login or Register  to view this content.