Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Query
Hi there
I'm hoping someone can help me with this... I'm wanting to run a report from a worksheet that has around 15000 lines of data, based on two criteria. I have tried using Autofilter, but my computer keeps crashing. The report I'd like to run is based on a particular month. So say in the reporting worksheet (called Report) if I type in the month I'm interested in, in say cell A1, and have a button to press with the macro behind it, then the Macro would look at the data worksheet (called Data) and find all the records relevant to that particular month. (The month data in the data worksheet is in column K.) Also at the same time I would like the macro to look at Column E and find all the lines that say "TEST". At the same time, if there is previous data on the €śReport€ť worksheet, can this be deleted before the new information is added. So the report on the "reporting" worksheet would copy all the lines from the "Data" worksheet that are from the month in cell A1, and have "TEST" in column E. The data on the data worksheet ranges from A to N. I hope this makes sense! And any help would be greatly appreciated. -- rmsmith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Query
On the REPORT sheet put Month in Cell A1 & A10 . In Cell B1 & B10 put the
heading name for Column E. Assign the following macro to the embedded ActiveX macro button on the REPORT sheet. Sheets("Data").Range("A1:B97").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheets("Report").Range("A1:B2"), CopyToRange:=Sheets_("Report").Range("A10:B10"), Unique:= _ False good luck "rmsmith" wrote: Hi there I'm hoping someone can help me with this... I'm wanting to run a report from a worksheet that has around 15000 lines of data, based on two criteria. I have tried using Autofilter, but my computer keeps crashing. The report I'd like to run is based on a particular month. So say in the reporting worksheet (called Report) if I type in the month I'm interested in, in say cell A1, and have a button to press with the macro behind it, then the Macro would look at the data worksheet (called Data) and find all the records relevant to that particular month. (The month data in the data worksheet is in column K.) Also at the same time I would like the macro to look at Column E and find all the lines that say "TEST". At the same time, if there is previous data on the €śReport€ť worksheet, can this be deleted before the new information is added. So the report on the "reporting" worksheet would copy all the lines from the "Data" worksheet that are from the month in cell A1, and have "TEST" in column E. The data on the data worksheet ranges from A to N. I hope this makes sense! And any help would be greatly appreciated. -- rmsmith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Query | Excel Discussion (Misc queries) | |||
Macro Query | Excel Discussion (Misc queries) | |||
Macro Query | Excel Discussion (Misc queries) | |||
another macro query - deleting a worksheet within a query | Excel Discussion (Misc queries) | |||
NEW WEB QUERY MACRO | Setting up and Configuration of Excel |