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

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

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