 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008sheet with the contents of al the worksheet
i am looking for a possibility to create a sheet with the contents of al the worksheets that are in the file you are working in. Input for the sheet with contents would be a specific defined cell (let's say the content is in Cell A1 of each worksheet) + the name of the tab of the worksheet. Did you not like the answer I gave you in your identical posting in .misc? Please do not multi-post. Pete > i am looking for a possibility to create a sheet with the contents of al the > worksheets that are in the file you are working in. > Input for the sheet with contents would be a specific defined cell (let's > say the content is in Cell A1 of each worksheet) + the name of the tab of > the worksheet. Not sure what you want.......maybe something like this? =Sheet2name!A1&", "&"sheet2name" More details would be helpful. Vaya con Dios, Chuck, CABGx3 > i am looking for a possibility to create a sheet with the contents of al the > worksheets that are in the file you are working in. > Input for the sheet with contents would be a specific defined cell (let's > say the content is in Cell A1 of each worksheet) + the name of the tab of > the worksheet |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.