Working with multiple workbooks.
 

Hello, it has been many years since doing any Excel macros or VBA so please
forgive the newbie question.

I have 3 excel spreadsheets that are created from a custom program (cTime,
pTime and aTime) which uses blank rows and merged cell rows for formating
purposes... causes problems when trying to select ranges.

I would like to program the following:

1. have the user select the three files that they are going work with (each
week it changes so I have defined single names for now)

2. cTime is the master file that requires updating from both pTime and aTime
files. All the columns are the same between files.

Project codes are contained in column A. The program needs to take each
project code in Column A and add the value in Column I (for both pTime and
aTime) to the corresponding project code in Column A in cTime to its value in
Column I.

The caveats are that the project codes in Column A in all files may start at
a different row ... usually 6 or 7 and are separated by blank rows and rows
with merged cells. The end of the data in Column A is easily found by going
to the bottom of the column and the doing and end up arrow.

pTime and aTime may have all or a subset of the project codes.

3. I also want to insert a formula that sums columns F, G, H, I in column J
but again because of the method used for fromatting you can't use a range...
some kind of loop that checks to see if there is a value in the cell and if
so then replace it with a formula.

I know this may seem like a lot to ask but any starting help is appreciated.