![]() |
MS Excel
Hello,
I need to create a worksheet that pastes the columns from other related worksheets into the new worksheet by finding records that have a common "key" record. |
Instead of pasting the info, maybe you could use a formula (or a bunch of
formulas): Debra Dalgleish has some instructions for =vlookup() or =index(match()) at: http://www.contextures.com/xlFunctions02.html Wordgeek wrote: Hello, I need to create a worksheet that pastes the columns from other related worksheets into the new worksheet by finding records that have a common "key" record. -- Dave Peterson |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com