ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Create Excel Database (https://www.excelbanter.com/excel-discussion-misc-queries/128232-create-excel-database.html)

TonyD

Create Excel Database
 
I want to setup a database in a worksheet and then perform VBA instructons to
extract the data in other worksheets in the same workbook. I am looking for
examples or links that will help guide me towards this goal. My extracts will
include copying cells from records that meet certain criteria and then adding
blank lines when new records change (i.e. name changes)

Gord Dibben

Create Excel Database
 
Tony

See Ron de Bruin's site for Copy/Paste/Merge examples.

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP

On Mon, 29 Jan 2007 15:17:01 -0800, TonyD
wrote:

I want to setup a database in a worksheet and then perform VBA instructons to
extract the data in other worksheets in the same workbook. I am looking for
examples or links that will help guide me towards this goal. My extracts will
include copying cells from records that meet certain criteria and then adding
blank lines when new records change (i.e. name changes)




All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com