Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I Have no idea on how to extract data from a excel spread sheets, I have
extracted data using Quattro pro but that was centuries ago.... My Question is..... I have a spreadsheet that has 4 Columns of data, these columns are date, company, class and amount... I want to search the column "class" for a specific word such as "gas", each time the program finds the word " gas "copy all the information from the other columns into specific columns in a different spreadsheet. I know this will be quite simple for the majorty of you experts if not all, but I have know idea and I cannot find out how by using the "help" in the program..... any examples would be greatly appreciated... -- Thank you, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dealing with data in several columns AND rows | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Extracting data from other columns | Excel Worksheet Functions | |||
How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions |