Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet
Hi, Does anyone have any suggestions for the following: I have a range of cells(account #'s) on Sheet 1 column A. I would like to look at the cell value of Cell B5(On any of the Sheets) on a different spreadsheet and if that value matches any value in the range of cells on sheet 1 Colum A Then: Copy the sheet on Sheet 2 on the first spreadsheet. Any help would be greatly appreciated!! -- STEVEB ------------------------------------------------------------------------ STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872 View this thread: http://www.excelforum.com/showthread...hreadid=499775 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet
do you want to copy the whole sheet or just the value that matched? Maybe
something different? "STEVEB" wrote: Hi, Does anyone have any suggestions for the following: I have a range of cells(account #'s) on Sheet 1 column A. I would like to look at the cell value of Cell B5(On any of the Sheets) on a different spreadsheet and if that value matches any value in the range of cells on sheet 1 Colum A Then: Copy the sheet on Sheet 2 on the first spreadsheet. Any help would be greatly appreciated!! -- STEVEB ------------------------------------------------------------------------ STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872 View this thread: http://www.excelforum.com/showthread...hreadid=499775 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet
JNW I would like to copy the whole sheet. Thanks for your help -- STEVEB ------------------------------------------------------------------------ STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872 View this thread: http://www.excelforum.com/showthread...hreadid=499775 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
providing a sheet-copy event or copy CustomProperties | Excel Programming |