Posted by Matthew on September 04, 2001 9:50 PM
I am new to this so I am sorry if this has been covered but.....
I am trying to write a macro that will update certain cells within a workbook from cells within another. Problem is, The file from which the data is to be updated is likely to change, so I need to match row headings first to ensure the correct data is being updated.
So I am (trying) to write Something like:
For y = 1 to 500 'Whatever the number of rows are
For x = 1 to 500
If Sourceworkbook.xls.Cells(x,Column1)== Destinationworkbook.xls.Cells(y,Column1);
Then 'update data in following columns
else....'don't update data, try next match
I have no experience in VB, and limited experience in other languages so I am not sure what I am doing. I used your search function, but couldn't find anything under the keyword "appending" since this is what I am trying to do.
Any help appreciated,