The following is what I have to work with I have 12 months of data save in
twelve spread sheets for approximately 1000 funds. I need to copy eight
columns from each work sheet into a linked workbooks which have twelve
worksheets each month uses the month end date for example 2007-01-31 for
January.
I need to give information in for the 1000 funds for the entire year I made
a template which I will be using and I am going to copy and paste this
information from one workbook to another because the original workbook has
information that I do not need. How can I set a formula in the event I copy
the incorrect data in the workbook my files are largesince I am using month
end as my initial step to copy the information. See information example
below of what I am going to copy and paste.

Account & branch Date Account number Branch depreciation

1010500 2007/01/31 1040 500
10