| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one sheet paste to another
Helo all,
On sheets("Test Database") I have 2,000 tests spanning from column A to AD. these tests are of different mix types. In Column B is the mix type. On sheets("main menu") in cell ("B9") I have a mix number 4064 which is choosen from a drop down box consisting of 28 different number (4052-4079). What I need to do is when sheets("main menu") range("B9") has a number I need the last 4 tests from sheets("Tests Database") that match sheets("main menu") range("B9") to copy all the rows (A-AD) over to another sheet called sheet("Last 4"). ie: sheets("main menu").Range("B9")=4064 sheets("test database") looks like this: A B C D....... 4064 4064~~~ This row would post on to sheets("Last 4") 4052 4052 4064~~~ This row would post on to sheets("Last 4") 4052 4064~~~ This row would post on to sheets("Last 4") 4064~~~ This row would post on to sheets("last 4") Column "A" is the date the test was run...... Does this make any sense? Any help would be appreciated.......Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy from one sheet paste to another
Sheets("Test Database").Columns("B:B").AutoFilter
Sheets("Test Database").Cells.AutoFilter Field:=1, _ Criteria1:=Sheets("main menu").Range("B9") Sheets("Test Database").Rows.SpecialCells(xlCellTypeVisible).Co py Sheets("Last 4").Rows(1).PasteSpecial "Eric" wrote: Helo all, On sheets("Test Database") I have 2,000 tests spanning from column A to AD. these tests are of different mix types. In Column B is the mix type. On sheets("main menu") in cell ("B9") I have a mix number 4064 which is choosen from a drop down box consisting of 28 different number (4052-4079). What I need to do is when sheets("main menu") range("B9") has a number I need the last 4 tests from sheets("Tests Database") that match sheets("main menu") range("B9") to copy all the rows (A-AD) over to another sheet called sheet("Last 4"). ie: sheets("main menu").Range("B9")=4064 sheets("test database") looks like this: A B C D....... 4064 4064~~~ This row would post on to sheets("Last 4") 4052 4052 4064~~~ This row would post on to sheets("Last 4") 4052 4064~~~ This row would post on to sheets("Last 4") 4064~~~ This row would post on to sheets("last 4") Column "A" is the date the test was run...... Does this make any sense? Any help would be appreciated.......Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy from each sheet and paste to a summary sheet | Excel Programming | |||
| Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
| Copy, paste to another sheet | Excel Programming | |||
| automatic copy and paste from sheet to sheet in a workbook | Excel Programming | |||
Linear Mode
