Greetings,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am familiar with Excel but I am a newbie to macros. I am using Excel 2003 and I am working on a couple of spreadsheets that contains over 50,000 rows. My problem is this: I need to look at values in column "A" of spreadsheet 1 and compare them to the values in column "A" of spreadsheet 2. If the values match for a certain row, then I need to copy the value on column B of spreadsheet 1 and paste it to column B of spreadsheet two. That is, i need help in accomplishing the following (Just an example):<o></o>
<o></o>
I hope this does not sound too confusing... i know it is to me. Can someone perhaps help with this? I would truly appreciate it.<o></o>
<o></o>
PS.- i could even paste all the values from one sheet to another so that I can have all the values in one sheet if this would make it easier. That way i would need to compare values in one column to values in another column in the same sheet. <o></o>
<o></o>
April12
I am familiar with Excel but I am a newbie to macros. I am using Excel 2003 and I am working on a couple of spreadsheets that contains over 50,000 rows. My problem is this: I need to look at values in column "A" of spreadsheet 1 and compare them to the values in column "A" of spreadsheet 2. If the values match for a certain row, then I need to copy the value on column B of spreadsheet 1 and paste it to column B of spreadsheet two. That is, i need help in accomplishing the following (Just an example):<o></o>
- <o></o>
[*]Look at values column A, spreadsheet 1<o></o>
[*]Compare to values in Column A, spreadsheet 2<o></o>
[*]if (lets say) row 4 in column A, sheet 1 matches row 10, column A, sheet 2 then...<o></o>
[*]...copy values in row 4, column B, sheet 1<o></o>
[*]paste value to row 10, column B, sheet 2<o></o>
<o></o>
I hope this does not sound too confusing... i know it is to me. Can someone perhaps help with this? I would truly appreciate it.<o></o>
<o></o>
PS.- i could even paste all the values from one sheet to another so that I can have all the values in one sheet if this would make it easier. That way i would need to compare values in one column to values in another column in the same sheet. <o></o>
<o></o>
April12