Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

adding to list (database)

Posted by tillymint on January 12, 2001 5:08 PM

Can someone please help I am trying to get data from non adjacent cells in one worksheet and paste them into a list (database) on another sheet within the same workbook

Re: adding to list (database)

Posted by Michelle on January 13, 2001 6:23 AM

Try copying using the control key, paste special skipping blanks to another part of the spreadsheet and then copy and paste to the database.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.