Excel 2007 : How to copy same records to different columns with month variable

hello everyone!

i am trying to make an excel sheet which has 2 sheets

one sheet is alike a form and second sheet keeps the record. but the structure is same except sheet 2 has 12 more columns for keeping montly records,

in first sheet there is a month selection and a column to fill
and at second sheet there are 12 columns same with the sheet 1 for each month

i want excel to take the records in sheet 1 column and month selection and compare it with the sheet 2 , if there is an entry before a error message otherwise it shall copy all records to the relevant month's column

i am sure it is quite easy for experts but i couldnt solve it .

thanks beforehand for your helps

Hi albatros79
Welcome to the forum,
One way....Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:

Please Login or Register  to view this content.

Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

Hi albatros79,
Hmm... that would mean you could have twelve messages

Hi albatros79

Tyr this ....

Please Login or Register  to view this content.

the values was number not dates. and actually this list is quite long in normal excel sheet
i will attach it too for you to see what i mean . there are around 380 rows. so if it asks me for each row it would take about 5 mins to confirm .
let me explain in the real sheet.
my goal is to copy "MONTLY RUN HOURS" column in RUNNING HOURS sheet to relevant month column at "RUNNING HOURS RECORDS "sheet when i push the rec button. but if there is a old data in matched months column it should ask if overwrite. but as you see there are plenty rows so crew can record 100 in 1 day and 150 and 2nd day and rest in 3rd day. so it should ignore blank cells in "MONTLY RUN HOURS" column when pasting to "RUNNING HOURS RECORDS "sheet.
also new items can be added to the list .

am i too demanding??

Hi albatros79
but it just wont work if you make lots of changes but try it

Please Login or Register  to view this content.