Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Everyone,
Here is what want to do: I need to collection information with X amounts of sheet in one particular folder that meet a particular criteria (let's say find all those line/records that are December in a certain column range) and then store all of those information in one Sheet name Summary). Basically what I want is a summary sheet of all the workbooks in on folder. I did a little research in the Discussion group, but mostly are just collecting ALL data in workbooks and put them in one workbook in different sheet. However, for my purpose, I also need the Macro/Program to search for Certain Criteria before copying the Line over and Pending to ONE sheet only. Is it possible to do this? THANK YOU FOR ANY SUGGESTION/ADVISE. Neon520 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
collect data from one excel sheet to another | Excel Discussion (Misc queries) | |||
collect data from one excel sheet to another | Excel Worksheet Functions | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
Copy paste WkBk/sheet 1 to multiple wkbks/sheets | Excel Programming |