If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple sheets sharing variable data
Sheet1, Column A contains variable data entered. (Red, Blue, Green,
Blue, Green, Red, Green Red, Blue) When the data is entered into Sheet1, I want it to appear in Sheet2 as: Column A (Red, Red, Red), Column B (Blue, Blue, Blue), Column C (Green, Green, Green) Any ideas? --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Multiple sheets sharing variable data
Hi!
I recorded this simple macro: Sub SplitColours() ' ' SplitColours Macro ' Macro recorded 29/06/2004 ' Keyboard Shortcut: Ctrl+Shift+S ' Range("A1").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="Blue" Range("A2:A100").Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy Sheets("Sheet2").Select Range("A2").Select ActiveSheet.Paste Sheets("Sheet1").Select Selection.AutoFilter Field:=1, Criteria1:="Red" Range("A2:A100").Select Selection.SpecialCells(xlCellTypeVisible).Select Application.CutCopyMode = False Selection.Copy Sheets("Sheet2").Select Range("B2").Select ActiveSheet.Paste Sheets("Sheet1").Select Selection.AutoFilter Field:=1, Criteria1:="Green" Range("A2:A100").Select Selection.SpecialCells(xlCellTypeVisible).Select Application.CutCopyMode = False Selection.Copy Sheets("Sheet2").Select Range("C2").Select ActiveSheet.Paste End Sub All it does is us Data Filter AutoFilter to select the "Red" or whatever. Copy visible cells. Paste them into the relevant column. Not the most elegant thing, but a quick fix which works? Alf --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
Multiple sheets sharing variable data
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem combining data from multiple rows into a single row | Frank Kabel | Worksheet Functions | 0 | April 8th, 2004 08:29 AM |
Formula across multiple sheets | Dave | Worksheet Functions | 1 | March 18th, 2004 10:50 PM |
Password protecting multiple sheets | Allison | Worksheet Functions | 1 | February 27th, 2004 02:15 AM |
Multiple Charts from single instance of data | dvt | Charts and Charting | 1 | September 21st, 2003 01:45 PM |