Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sheet with multiple tabs
We receive a spreadsheet with multiple tabs from a vendor. Within each sheet
there are multiple items and totals with extended costs. I need to extract the amount and acct number on only the rows that have 'Total.' For example: Type Extended 1234 30.00 1234-ab 8.95 1234-abc total 38.95 In this example I want to only extract 1234-abc in one column and 38.95 in another column. And do this for each tab. Can anyone suggest the best way to accomplish this task? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Over Multiple Sheet Tabs with Multiple Values | Excel Worksheet Functions | |||
Create multiple sheet tabs from multiple cells. | Excel Worksheet Functions | |||
SUMIF formula that crosses multiple sheet tabs | Excel Discussion (Misc queries) | |||
view excel sheet tabs in multiple rows | Setting up and Configuration of Excel | |||
printing multiple sheet tabs to image file | Excel Discussion (Misc queries) |