#1
|
|||
|
|||
copy row into new sheet dependant on cell data
Hello all anything thank you for taking the time to help me out here.
I'm trying to help a friend setup an archive which basically filters data into other sheets. So sheet 1 will contain all the data Tool type Serial no. Condition bla bla bla Working / N/G And on sheet 2,3,4+ there will be a list of all the working or N/G tools Cheers all again |
#2
|
|||
|
|||
How about just keeping one sheet and applying filters there? Why do you need duplicate data? It's not advisable.
Otherwise, if you simply must have separate tables, you could insert pivot tables on the other sheets. Unfortunately, if the data change on the master sheet, you will have to manually refresh the pivot tables. A sample sheet would be more helpful than this... Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to find a macro that will copy a cell and paste that value to a specific sheet | bryans88 | Excel Programming | 1 | 12-23-2015 01:40 PM |
Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
Help Coloring a cell in Sheet one if data is missing from another sheet | Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
Data dependant on checkboxes? | ryanf | Word | 2 | 11-01-2012 05:00 AM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |