Creating macro for copying data

[baseballplaya]

Hello All,

I am requiring some assistance with a project that I am desigining. I attempting to log how many hours are used monthly with lawn mowers that I rent out. Each unit has a hours meter and I will input the hours each month into "equipment" sheet. I am trying to accomplish the following:

1) when I update the hours, I would like the "hour" cell to copy over to the sheet "reports"

2) Once copied, the next time I enter hours, I need the new data copied to the very next column. Example, if the current data is in d10, then the next time the macro is run I need the new info to go into e10.

To walk though this, say I enter updated hours for (Tag #68), John Deere which is in box C12. When the macro is run, it searches in sheet "Report" , column A for "68". Once found it will copy data from sheet "Equipment", column C to the next empty column in sheet "Report" in the row that contains "68". If I have confused anyone I apoligize. Please advise if you think this can be accomplished. Thank you all!

 

[baseballplaya]

Using Windows XP and Excel 2007.

Excel Workbook
	A	B	C
1	TAG #	Make	Hours
2	12	Toro	235
3	15	John Deere	1,126
4	16	John Deere	652
5	17	John Deere	555
6	28	John Deere	94
7	44	Husq	211
8	47	Husq	68
9	48	Husq	29
10	52	Cadet	55
11	63	Cadet	94
12	64	John Deere	44
13	65	Cadet	1,111
14	68	John Deere	123
15	69	Cadet	516
16	74	Toro	654
17	75	Toro	215
18	82	John Deere	1,505
19	88	Husq	896
20	89	John Deere	1,515
21	95	Toro	954
Equipment

Excel Workbook
	A	B	C	D	E
1	TAG #	1	2	3	4
2	12	235	????	????	????
3	15	1,126
4	16	652
5	17	555
6	28	94
7	44	211
8	47	68
9	48	29
10	52	55
11	63	94
12	64	44
13	65	1,111
14	68	123
15	69	516
16	74	654
17	75	215
18	82	1,505
19	88	896
20	89	1,515
21	95	954
Excel 2007 Reports

Excel 2007

 

[baseballplaya]

Anyone? Can this be done in theory at least?