LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaydubs
 
Posts: n/a
Default Checking in other tabs and copying to another tab Is that possible

Dear Excel(lent) users,

The following is the case.

I have a spreadsheet with three tabs. In the first tab I have data about
system tests. In the second tab I have data on acceptance tests. The
structure of the columns in both tabs are exactly the same. Including one
column (for instance 'H')in which we indicate wheter an issue is declined and
returned for further solution(s).

In the third tab I want to summerize all Issues which have been returned due
to non acceptance (i.e. yes filled in 'H' in both other tabs).

Furthermore I want to find out how many times each issue has been
ping-ponged back and forth.

Please help me out !! Thanks!


--
** Fool on the hill **
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting multiple sheet tabs and open another workbook Bannor Excel Discussion (Misc queries) 5 November 25th 05 02:38 AM
Can you copy multiple tabs from formulas to values w/o paste spec? Brent Excel Worksheet Functions 2 October 27th 05 12:47 AM
Copying many tabs from one file to an individual file for each tab CWH Excel Discussion (Misc queries) 4 June 20th 05 08:14 AM
copying worksheet tabs Lynn Excel Discussion (Misc queries) 1 March 18th 05 05:50 PM
Copying Tabs in Excel Christopher Anderson Excel Discussion (Misc queries) 1 January 5th 05 10:28 PM


All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"