ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Picking specific rows from database (https://www.excelbanter.com/excel-discussion-misc-queries/149759-picking-specific-rows-database.html)

Buzz Sawyer

Picking specific rows from database
 
I need to pick rows 1,9,17, etc. from 2,898 rows with columns A tru I.

This will give me a table of Names & Phone Numbers I can use with a phone
dialer.

Thanks for the help.
--
Buzz Sawyer

bj

Picking specific rows from database
 
in column K enter = mod(row(),8)
use auto filter and select 1

"Buzz Sawyer" wrote:

I need to pick rows 1,9,17, etc. from 2,898 rows with columns A tru I.

This will give me a table of Names & Phone Numbers I can use with a phone
dialer.

Thanks for the help.
--
Buzz Sawyer



All times are GMT +1. The time now is 06:40 PM.

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