Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looping through data on consecutive pages
I am hoping to create a WorkBook of 20-30 WorkSheets. Each sheet would
include a 5 column x 8 row table of various dates. I would like for a macro to cycle through each of the sheets, looking for a user-defined month (eg, June) within the table and, if found, print that WorkSheet, then skip to the next WorkSheet. If not found, it would simply go to the next Worksheet and search for the month on that sheet. I need help with setting up the looping procedure that looks for the date and then prints or continues on. Can anyone offer guidance? Thanks in advance. -- - markvi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looping through data on consecutive pages
Markvi,
It might be that you should put all the data in one sheet. Don't stop reading yet. Read "Data across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "markvi" wrote in message ... I am hoping to create a WorkBook of 20-30 WorkSheets. Each sheet would include a 5 column x 8 row table of various dates. I would like for a macro to cycle through each of the sheets, looking for a user-defined month (eg, June) within the table and, if found, print that WorkSheet, then skip to the next WorkSheet. If not found, it would simply go to the next Worksheet and search for the month on that sheet. I need help with setting up the looping procedure that looks for the date and then prints or continues on. Can anyone offer guidance? Thanks in advance. -- - markvi |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looping through data on consecutive pages
Thanks, Earl. I was afraid that was gong to be the answer. I have something
like that setup in Quattro Pro. It works, but the data entry is tedious. i was hoping to streamline the whole process. Oh well. -- - markvi "Earl Kiosterud" wrote: Markvi, It might be that you should put all the data in one sheet. Don't stop reading yet. Read "Data across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "markvi" wrote in message ... I am hoping to create a WorkBook of 20-30 WorkSheets. Each sheet would include a 5 column x 8 row table of various dates. I would like for a macro to cycle through each of the sheets, looking for a user-defined month (eg, June) within the table and, if found, print that WorkSheet, then skip to the next WorkSheet. If not found, it would simply go to the next Worksheet and search for the month on that sheet. I need help with setting up the looping procedure that looks for the date and then prints or continues on. Can anyone offer guidance? Thanks in advance. -- - markvi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consecutive Numbered Pages | Excel Discussion (Misc queries) | |||
Consecutive data in different sheet | Excel Worksheet Functions | |||
Chart non consecutive data | Charts and Charting in Excel | |||
RUN CONSECUTIVE EXCEL DATES ON DIFFERENT PAGES IN WORD DOCUMENT | Excel Worksheet Functions | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions |