Worksheet Tab Name

R

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
 
E

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

raymondsum said:
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
Click to expand...
creating financial statements
 
R

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
 
E

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
------------------------------------------
raymondsum said:
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
Click to expand...
creating financial statements
 
Top