--------------------------------------------------------------------------------

I was looking at A file im working on , and it looks something like this:
A B C D E
1
2 Act Act Act Fcst Fcst
3Jan Feb Mar Apri
4 33 44 55 66

So technically, as the act-ual information becomes available, i need to select it. so in this case it would be from a2 to c. I dunno if i can do it by inputting a cell to select the number of columns to the right or any other condition. the file has 20 of these worksheets, so the macro would select all.
Since i am new to macros, i'd Appreciate as much info as possible to create it .

Thanks again!