Hello,

I am creating a Pilot Logbook on Excel, and am having a few issues trying to get it to do what I want. I am wondering if anyone can instruct me on how to create a macro that will search through a column for any new values, and if any appear, copy them into a new cell on a separate sheet within the workbook. If possible, I would also like for it to add a formula into the adjacent cell.

Here is a Screenshot of the pages in question:

logbook1.jpglogbook2.jpg

I am trying to make a macro that when I type a value into a cell in column C on the first page, it will copy it into the next blank cell in column E on the second page. There will be a lot of repetitive data in column C, so I would only like each type to come up once. I would also like it to do a SUMIF function using the data in Column E as the criteria, ie:


Column C (Page 1) Column E (Sheet 2) Column F (Sheet 2)
C172 C172 =SUMIF(Sheet1!C1:C100,"C172",Sheet1!H1:H100)
C172 DA20 7.4
C172 DA42 5.8
DA20
DA20
C172
DA42


If I am not very clear on what I am asking, please let me know and I can clarify anything for you.

Thanks