| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query & Write
Datasheet contains
Row 1( Header)---- Date Na Nb Nc Nd Row 2 31/10/03 1 8 3 4 Row 3 01/11/03 5 8 2 9 Querysheet contains Row 1(Header)---- Date Rowno 1 3 5 6 9 Row 2 31/10/03 2 0 0 1 0 1 Query conditions a Look in the datasheet at row2 for a value of 1, if found, then look at next row i.e. row3 for value found in the querysheet in this case are 1,3,5,6,9 . If found, it will write the date & rowno of row2 of datasheet and the value of 1 & 0 will be insert accordingly to the column. This macro will run the loops from row2 of datasheet until the last row. Thank you for helping. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| How to write parameter query with "or is null" criteria | New Users to Excel | |||
| write a query to retrieve data | New Users to Excel | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| query will not write to excel | Excel Discussion (Misc queries) | |||
![Michael168[_48_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
