Topic profile page for Worksheets.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Worksheets.
Topic "Worksheets" was discussed 33,397 times on 1,410 sites in last 3 months
Started 1 day, 4 hours ago (2009-11-27 04:37:00)
by sawczuk
We are having problems with the list of of worksheets portlet not displaying correctly every time. Sometimes the portlet displays the the list of worksheets on a white background with all the grid lines missing, other times it displays correctly. The portal is 10g and it is running over https, running over a load balancer. Has anyone come across this ...
Started 1 day, 9 hours ago (2009-11-27 00:14:00)
by eva cheng
( In Excel 2003, how can i add a hyperlink \(or other method\) in a cell that can link to a specific worksheet in another workbook which have multi worksheets. thanks -- eva cheng , In Excel 2003, how can i add a hyperlink \(or other method\) in a cell that can link to a specific worksheet in another workbook which have multi worksheets. ...
Started 1 day, 9 hours ago (2009-11-27 00:13:00)
by eva cheng
In Excel 2003, how can i add a hyperlink (or other method) in a cell that can link to a specific worksheet in another workbook which have multi worksheets. thanks
Started 1 day, 9 hours ago (2009-11-26 23:50:00)
by ron2k
Updating all validation drop down lists on all worksheets simultaneously Hi guys I have a workbook with 20 worksheets. All tabs are identical in format and layout. On B3, I have a drop down list (this may be irrelevant, but it's to select one month of the year) using simple data validation. Now, I initially had a formula in B3...
Started 1 day, 13 hours ago (2009-11-26 19:51:00)
by pujo
same cell address on multiple worksheets I have a formula that sum' the same cell but on 24 worksheets in the same work book. Each sheet is exactly the same format, just different data. If I wanted to create a macro that would select say cell ("A1") on sheet1 threw sheet12 how would it be written? What currently have is a long ...
Started 1 day, 14 hours ago (2009-11-26 18:46:00)
by ron2k_1
Hi guys I have a workbook with 20 worksheets. All tabs are identical in format and layout. On B3, I have a drop down list (this may be irrelevant, but it's to select one month of the year) using simple data validation. Now, I initially had a formula in B3 equal to B3 of the first sheet, so that if I changed the month in the first sheet it will change on all ...
Started 4 days, 17 hours ago (2009-11-23 16:24:00)
by ExcelR00k
Grouping worksheets from hyperlinks? Is that even possible?? I have a "Summary Sheet" that has links to all the worksheets in the document. Is it possible to somehow group worksheets by hyperlinks. For example: To group, you would hold Ctrl and click one worksheet and another and so on and so forth. But i want it, so if I ...
Started 4 days, 18 hours ago (2009-11-23 14:54:00)
by karmaimages
Conditional Fomatting Over 2 worksheets Good Afternoon I have an issue with conditional formatting in that excel will not allow it to go over 2 worksheets in a workbook. On one sheet i have a set of questions with Yes or no answers or tick or cross whichever can be entered. On the next sheet i have the list of days ...
Started 4 days, 21 hours ago (2009-11-23 12:07:00)
by kazbarina
Get worksheet names from workbook, EXCLUDING hidden worksheets Hi, I've managed to create a form that will list all worksheets in a workbook. However, I have 15 or so hidden worksheets that I do not want populated in this list, as the user cannot select them. Does anyone know the code I need to add to ensure I only get ...
Started 5 days, 3 hours ago (2009-11-23 05:36:00)
by paddy1992
Splitting of columns in different worksheets I have N no. of columns in the 1st worksheet which can be named as Master or source sheet and the requirement is to split the columns as per required into the different worksheets of the same workbook. Example: I should be able to split it like 2 or 3 columns in worksheet 2, 5 or 6 ...
Started 4 days, 4 hours ago (2009-11-24 05:21:00)
by biffster7272
Copy data from multiple open worksheets At work I am trying to utilize VBA to copy data from multiple open worksheets and have to data refresh on a master summary sheet. Here is the scenario. 1) We have approximately 10 excel workbooks all located on a shared network drive. 2) Each of these 10 workbooks can ...
Started 2 days, 21 hours ago (2009-11-25 11:59:00)
by schueyisking
Hide worksheets by color tab - VBA script needed Hi, Really hope someone can help. I want to be able to hide/unhide sheets with one click of a button - by color. For example I have 20 worksheets. 10 have a tab color red, 10 have a tab color yellow. I want to be able to, at a click of a button, hide the 10 yellow sheets, ...
Started 2 days, 5 hours ago (2009-11-26 03:52:00)
by tsroque
Alter Macro to Combine Only Certain Worksheets I got the following code from another post, but it Combines ALL the worksheets in my workbook. Is there a way to... 1. Already have a tab called Combined instead of it creating it. 2. Delete all data from A3...down... 3. Copy the data from all the worksheets that ...
Started 2 days, 18 hours ago (2009-11-25 15:01:00)
by qwerty1234567890 Registered User
I am trying to combine two worksheets into one worksheet. In the first worksheet I have countries in the first column. In the second column, I have the statistics for how many people belong to a certain religion. Then in the second worksheet, I have the countries in the first column and birthrate in the second column. How do I combine this information into one table...
Started 6 days, 5 hours ago (2009-11-22 04:10:00)
by Davidhg
I used to use Report Manager to print a series of worksheets or worksheet views which I found very helpful. But I can't now find this tool amongst Excel 2003 software. Can anyone help please
Started 2 days, 22 hours ago (2009-11-25 11:11:00)
by Mostlygood
I have managed to find some code which, upon pressing a command button on the 1st worksheet in my workbook it: 1. populates a list of the names of all the other sheets in the document 2. converts each name into a hyperlink that when clicked, opens the sheet. (or at least it should) 3. Add the word 'menu' in cell A1 of each sheet that is a hyperlink back to the...
Started 2 days, 21 hours ago (2009-11-25 12:29:00)
by JohnRooney Registered User
I have a custom data entry form which is working fine. The form completes customer data for reviewing at a later date. I have now been asked to change it so it will seperate the data in to customer's who require some documents sent out and some that dont. Is it possible to have a combobox on the form and if the options on the combobox are Yes and No (original), ...
