Copy Sheet

[STEVEB]

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!!

[JNW]

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
>
>

[STEVEB]

JNW

I would like to copy the whole sheet.

Thanks for your help