Hi
I have 2 sheets each with the same column header data in both. (Columns A - BP)
Sheet1 has over 1000 rows of data with a unique number in column A assigned to each row.
Sheet2 has only one row (row 2) [row 1 has column headers].
I need to copy the row in Sheet2, find the matching row in Sheet1 (Unique number in Column A). Once found, the copied data needs to be pasted over the existing data in that row in Sheet 1 using PasteSpecial values.
Your assistance is greatly appreciated.
Thanks
Last edited by pepe.r.taylor; 08-01-2011 at 01:08 PM. Reason: Title clarification
Hi, Give this a try:
Please Login or Register to view this content.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks