ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Excel (https://www.excelbanter.com/excel-discussion-misc-queries/751-ms-excel.html)

Wordgeek

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.

Dave Peterson

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