Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automation
I have an Excel worksheet with 20+thousand products listed on it. I need a
formula that would search the column labeled Category for a specific word and copy the row to a separate worksheet without having blank rows. I have about a dozen categories that I need in separate sheets. I am not an expert at this yet, so any help would be appreciated. Thanks, Allenc |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automation
I have place an example at http://www.HelpExcel.com/examples
The name of the spreadsheet is copyRow.xls -- http://HelpExcel.com "Allenc" wrote: I have an Excel worksheet with 20+thousand products listed on it. I need a formula that would search the column labeled Category for a specific word and copy the row to a separate worksheet without having blank rows. I have about a dozen categories that I need in separate sheets. I am not an expert at this yet, so any help would be appreciated. Thanks, Allenc |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automation
If you're interested in a formulas play
which delivers the required automation .. Try this sample construct from my archives: http://www.savefile.com/files/151988 AutoCopy_Data_To_Resp_Sheet_Non_Array_Approach.xls (Full details inside, nicely rendered! Easy to adapt ..) Data is continuously entered in a master ("parent") sheet, with lines neatly auto-copied to each individual ("child") sheet based on the values within a key col. In the sample, the key col in the master sheet is the "Colours" col, which may contain eg: Red, Yellow, Green, etc. All lines with "Red" in the key col will be auto-copied to the sheet named: Red, and appear neatly bunched at the top. Ditto for lines with "Yellow", "Green", etc. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the key col value. Eg we first formulate one child sheet for "Red", dress it up nicely, then just make copies of the "Red" sheet, and rename these as: Yellow, Green, etc In your instance, the key col would be "Category" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Allenc" wrote: I have an Excel worksheet with 20+thousand products listed on it. I need a formula that would search the column labeled Category for a specific word and copy the row to a separate worksheet without having blank rows. I have about a dozen categories that I need in separate sheets. I am not an expert at this yet, so any help would be appreciated. Thanks, Allenc |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automation
Thanks, I will take a look and see if it works and let you know.
Allenc "galimi" wrote: I have place an example at http://www.HelpExcel.com/examples The name of the spreadsheet is copyRow.xls -- http://HelpExcel.com "Allenc" wrote: I have an Excel worksheet with 20+thousand products listed on it. I need a formula that would search the column labeled Category for a specific word and copy the row to a separate worksheet without having blank rows. I have about a dozen categories that I need in separate sheets. I am not an expert at this yet, so any help would be appreciated. Thanks, Allenc |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automation
Thanks, I will take a look at yours as well and see if it works as the
solution. I will let you know. Allenc "Max" wrote: If you're interested in a formulas play which delivers the required automation .. Try this sample construct from my archives: http://www.savefile.com/files/151988 AutoCopy_Data_To_Resp_Sheet_Non_Array_Approach.xls (Full details inside, nicely rendered! Easy to adapt ..) Data is continuously entered in a master ("parent") sheet, with lines neatly auto-copied to each individual ("child") sheet based on the values within a key col. In the sample, the key col in the master sheet is the "Colours" col, which may contain eg: Red, Yellow, Green, etc. All lines with "Red" in the key col will be auto-copied to the sheet named: Red, and appear neatly bunched at the top. Ditto for lines with "Yellow", "Green", etc. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the key col value. Eg we first formulate one child sheet for "Red", dress it up nicely, then just make copies of the "Red" sheet, and rename these as: Yellow, Green, etc In your instance, the key col would be "Category" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Allenc" wrote: I have an Excel worksheet with 20+thousand products listed on it. I need a formula that would search the column labeled Category for a specific word and copy the row to a separate worksheet without having blank rows. I have about a dozen categories that I need in separate sheets. I am not an expert at this yet, so any help would be appreciated. Thanks, Allenc |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automation
Pleasure`. Let me know how it went for you.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Allenc" wrote in message ... Thanks, I will take a look at yours as well and see if it works as the solution. I will let you know. Allenc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 c++ automation problem. | Excel Worksheet Functions | |||
Automation Classes / Methods, overview or list | Excel Discussion (Misc queries) | |||
Automation 2-Part Question... | Excel Discussion (Misc queries) | |||
Is there an easy way to create automation in a graph? | Charts and Charting in Excel | |||
Excel Automation SelectionChange event | Excel Discussion (Misc queries) |