Find & Replace

[rockydav33]

I have a very simple task that I can't seem to get VBA to do. I have an external sheet that has monthly data in columns. Column A is Jan, B is Feb, etc.

On my current sheet I am attempting to switch columns (months) to have my sheet reflect the current month. I am currently doing a find/replace and switching column B with A. What I want is a cell that has the column ref in it (example cell A1=B for feb) I want to reference this cell and do a find/replace on a large set of data.

I can manually get this to work but VBA doesn't paste the copied value into the find/replace box, it puts in the real value of the cell that was used to set up the macro.

Any ideas?
Other workarounds?

Thanks

[venkat1926]

NOT VERY CLEAR. post a SMALL extract of sheet 1(you call external sheet) and sheet 2 (you call current sheet). sheet1 is data. sheet 2 reflect what you expect.