Recent content by mahhogany

You are correct. Both sets of data should go to the Live Tracker table and the contents of that table should be deleted before I can append the data from the two tables to it. Do you have any tips on how to do this?

ok I understand. I haven't added the second file yet. That is where I am stuck. At the moment the code above is calling the first file only. I tried to use a Do while Loop to include the second file but it completely fell over. The code is below Ideally I would like some ideas on how to...

The second workbook is of the same layout but there may be a third one with a different layout later. However I would like to get this one sorted for now. The second file is in the same directory but called Contracts Maint.xls I don't understand Q2.

This code works perfectly to append one excel file but I need help to amend it so it can append one file after another. Any ideas?

No offence taken!

Thanks very much for the code...I much prefer that and whats more it works! You are great!

Hiya Thanks very much for replying but it didn't work. :-( Should I have put the formula in the B column? And I am trying to match the dates in the A column to the array. I need a formula that will return the correct period i.e. (07/08 P1 etc) that the date falls in.

Hi Wonderful people. I have searched high and beyond but can't seem to find the correct answer to this issue. I have a list of dates (list 1) and by each date I want to put a formula in a cell that will search the array and return the period number I have a table which list (list2) an...

Can mods please delete this thread as it is a duplicate. I really wanted the question ans in the VBA section but posted it here by mistake. Sowwy!:o

Thanks, will that work in VBA...sorry for being such an nunce but I am quite new to this. What would the layout be like?

I have an excel file which I have linked to my access dabatase. I would like to link the tables to a table in my database using VBA so I can apply the code to a button and run it automatically as it is quite tedious having to do it every two weeks which is when the data is required. Most of...

I have an excel file which I have linked to my access dabatase. I would like to link the tables to a table in my database using VBA so I can apply the code to a button and run it automatically as it is quite tedious having to do it every two weeks which is when the data is required. Most of...