VBA Basic Question

Hi,

I have information that I want to carry over from one sheet to another. I know how to use vlookup to do this, but the cells I want transferred have conditional formatting. I was told that VBA could look up the values on one sheet and carry them over like vlookup but would carry the formatting over.

I've never used VBA before... how would I do this?

Thanks in advance!

Okay, here is the situation...

I am basically creating a workbook that employees at my company can use to log in hours that they've spent on training over a span of three years.

The first sheet is year one, second is year two, third is year four and fourth is total page.

On the first sheet they select info from drop down box and/or enter it in for the course category, title and description, hours, format, date completed and type of evaluation.

They can enter this info into one of two categories on each "year" page... the first is "core" and the second is "specialization" (depending on what type of training they need). On the yearly pages, anything entered under the heading "specialization" is conditionally formatted to a colored cell.

I want the totals page to be able to able to automatically enter and keep a tally on whatever information is entered into the yearly forms.

I tried using VLOOKUP, but ran into a problem... I didn't know a formula that would let me scan multiple ranges across multiple sheets for a given variable.

So instead I just VLOOKUP'ed each line of the other pages into the total page and then auto hid all the blank cells.The only problem is that I can no longer distinguish between which courses are "core" and which are "specialization"...

so I was told that VBA and not VLOOKUP would allow me to carry over the courses from the yearly page to the totals page while keeping the colored formatting of the cells.

Does that make sense?