Worksheet Tab Name

[raymondsum]

Hi,

when i copy certain range from 'Sheet1' to 'Sheet9',
in 'Sheet9', i want to know the Source Sheet Name ie 'sheet1'.

eg. copy A2..B10 from Sheet1 to Sheet 9 in Cell A2,
then in Sheet9 Cell A1, i want to show the Sheet1 Name

Thanks

Raymon

 

[Earl Kiosterud]

Raymond,

There's nothing I know of that does this. A macro could do it. I haven't
written one for you because I don't know if you'll be copy/pasting the same
range, or if it's variable. Also, if it'll always be pasted to the same
place always, or different places.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Hi,

when i copy certain range from 'Sheet1' to 'Sheet9',
in 'Sheet9', i want to know the Source Sheet Name ie 'sheet1'.

eg. copy A2..B10 from Sheet1 to Sheet 9 in Cell A2,
then in Sheet9 Cell A1, i want to show the Sheet1 Name

Thanks

Raymond


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[raymondsum]

Earl,

Let me to explain more details.

I have several 'source' worksheets. When i finish to input data and i
need to copy such data to 'master' worksheet for further processing.

I have already writen a macro to copy data from 'source' worksheet to
'master' worksheet . Although i know the 'source' worksheet name, i
also want to copy the worksheet name because i dont want to type the
'source' worksheetname again in 'master' worksheet.

P.S. i use vlookup table to convert 'source' worksheet name (short
name) to long name in 'master' worksheet name.

I hope you can understand.

Thanks in advance for your help.

Raymond

 

[Earl Kiosterud]

Raymond,

First of all, please connect directly to microsoft's news server,
msnews,microsoft.com. It appears you're using a web site of some kind,
which makes a mess of the threading in newsgroups. If you have Outlook
express, it's Tools, Accounts, News, Add. Besides, why should the free work
we do in the newsgroups support sites with advertising and stuff?

Then post the existing code you have, and we'll go from there.

Earl Kiosterud
mvpearl omitthisword at verizon period net
------------------------------------------

Earl,

Let me to explain more details.

I have several 'source' worksheets. When i finish to input data and i
need to copy such data to 'master' worksheet for further processing.

I have already writen a macro to copy data from 'source' worksheet to
'master' worksheet . Although i know the 'source' worksheet name, i
also want to copy the worksheet name because i dont want to type the
'source' worksheetname again in 'master' worksheet.

P.S. i use vlookup table to convert 'source' worksheet name (short
name) to long name in 'master' worksheet name.

I hope you can understand.

Thanks in advance for your help.

Raymond


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements