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?

Apply an autofilter to that column.
Use the dropdown arrow to choose Custom
Contains (or ends with Total)

Then select the range to copy
Edit|Goto (or ctrl-g or F5)|Special|visible cells only
Then copy
Then paste to the new sheet.



pm wrote:

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?

--

Dave Peterson

Hey Dave - that works for the account number; however, the extended cost is a
formula; so when I filter and only select the rows with Total then my amount
is zero...any suggestions? Thanks.

"Dave Peterson" wrote:

Apply an autofilter to that column.
Use the dropdown arrow to choose Custom
Contains (or ends with Total)

Then select the range to copy
Edit|Goto (or ctrl-g or F5)|Special|visible cells only
Then copy
Then paste to the new sheet.



pm wrote:

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?

--

Dave Peterson

Paste|Special|values????

pm wrote:

Hey Dave - that works for the account number; however, the extended cost is a
formula; so when I filter and only select the rows with Total then my amount
is zero...any suggestions? Thanks.

"Dave Peterson" wrote:

Apply an autofilter to that column.
Use the dropdown arrow to choose Custom
Contains (or ends with Total)

Then select the range to copy
Edit|Goto (or ctrl-g or F5)|Special|visible cells only
Then copy
Then paste to the new sheet.



pm wrote:

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?

--

Dave Peterson


--

Dave Peterson