Manage File With Bunch Of Tabs?
Mar 5, 2013
I just inherited an excel spreadsheet that has 10 tabs per every month in the year. Right now it is not that bad as there are only two months in the spreadsheet but I can see this being a headache to tab through later on in the year.
My initial thought is to make a table of contents worksheet that has a bunch of buttons (with macros) to hide/show tabs based on month. (Note: It would not make sense to consolidate the month worksheets into one as each worksheet already has a lot of data in it to begin with.
View 2 Replies
ADVERTISEMENT
Nov 12, 2009
I have a set up a workbook which is linked to numerous other workbooks to provide a summary of information in one location.
However, when we reach April the names of all the linked worksheets will change from 'name 09 - 10' to 'name 10 - 11'.
What is the best way of handling this transition, will I have to manually change all of the links?
I have attached a much simplified example, unfortunately I cannot post the original due to sensitive data.
Apologies if the explanation isnt clear enough, let me know and I'll give further detail.
View 2 Replies
View Related
Feb 8, 2010
I need to do is be able insert a bunch of pallet references (manually, you will see a tab called 'Pallet Check' on the workbook attached) and then click a button that will check to make sure that those pallet numbers have been entered onto that workbook on one of the sheets from sheet1 to sheet100
If they are all ok I want it to return a value 'Pallet Reference Verified' in the column to the right of that pallet reference (column B) if it doesnt find that pallet then to return a value of 'Not Found'
I would also like to know if it finds any duplicates and if it does then return the names of the sheets that the ref is duplicated on (something like..... sheet3; sheet87) in column C for that ref i.e. pallet ref 'R6 10' has been entered so it will come back as being verified BUT it is also on another sheet which is bad so I want to know that it has been entered twice.
View 11 Replies
View Related
Nov 24, 2009
I have forms filled out by many, and I need to compile the information in it to create a list in my summary.
Is that possible?
fortunatly, the information always resides in the same cell on every file.
View 7 Replies
View Related
Mar 2, 2010
I have a column of cells over 2000 rows that have a bunch of text in each cell. In the middle of this text in each cell are websites (not hyperlinked). I was wondering if someone wrote a macro or formula to extract URLs located in a bunch of text? I can parse this out but doing some delimiting but that will take longer.
View 9 Replies
View Related
Jun 19, 2007
I have an Excel file with several tabs (worksheets), one worksheet is a "lookup table" which has customer names and addresses. I'd like to be able to have a drop down on the first page, perhaps a listbox (if that would be the best way) which would show the customer names and addresses from the lookup table page. I need to know the best way to do this. I have C++ knowledge, but VBA syntax is different. I've been playing around with the following
With Worksheets(1)
Set lb = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100)
lb.ControlFormat.ListFillRange = "Sheet8!E18"E272"
But it won't display data from the lookup table page.
View 9 Replies
View Related
Feb 17, 2007
Is there a code that manage Add-ins?
View 5 Replies
View Related
Jul 3, 2014
I have an excel document that I wish to share for multiple users to edit, but get the following error message Excel tabs or XML maps.
View 3 Replies
View Related
Jan 23, 2010
can group all opened file in 1 excel tab instead if many tabs?
open thru window the file u want...
http://i12.photobucket.com/albums/a209/tancfc/11444.jpg
http://i12.photobucket.com/albums/a209/tancfc/fhfh.jpg
right click on task bar > properties > under Taskbar Appearance, select Group Similar taskbar buttons > is not my answer
View 4 Replies
View Related
Dec 13, 2013
I need a macro that import tabs from a file into another file.
View 1 Replies
View Related
Aug 6, 2007
How do you get a quick report of all of the worksheets in a given file?
Is there functionality in Excel that would provide this? Or a simple macro?
I inherited a file w/ approx. 50 tabs and I'd like to print out the list of all the worksheets so I can create a checklist of tasks I need to do for each worksheet.
View 7 Replies
View Related
Feb 23, 2007
I'm having problem in managing 4000 checkboxes in a sheet. My sheet containt 2000 rows with 2 coloum of checkboxes. The question is, how to know when checkbox tick in one coloum then it will automatically tick the other one. I know how to do it with small quantity of checkboxes (i.e.: 10 checkboxes). But 4000 checkboxes make me headache.
View 4 Replies
View Related
May 21, 2014
I'm trying to use a Select Case to log production time-tables.
I've tried a couple angles - one being Select Case.
Every time I run the Macro I get the default ERROR "Wrong Model Entered...."
[Code] .....
I'm thinking the problem lies within
[Code] .....
but I'm not certain.
View 1 Replies
View Related
Feb 9, 2010
Assuming I’ve the following sample data and wishing if the output data could be formatted using some excel formulas, refer to below sample.
Sample data (Sheet1):
StudentA | Lesson1
StudentA | Lesson21
StudentA | Lesson10
StudentA | Lesson5
StudentB | Lesson5
StudentB | Lesson6
StudentC | Lesson9
StudentC | Lesson8
StudentC | Lesson9
StudentC | Lesson15
StudentC | Lesson11
StudentC | Lesson30
StudentC | Lesson13
StudentD | Lesson1
StudentD | Lesson2
StudentD | Lesson3
StudentD | Lesson4
StudentD | Lesson5
StudentD | Lesson6
StudentD | Lesson7
StudentD | Lesson8
Sample output (Sheet2):
StudentA | StudentB | StudentC | StudentD
Lesson1 | Lesson5 | Lesson9 | Lesson1
Lesson21 | Lesson6 | Lesson8 | Lesson2
Lesson10..................Lesson9 | Lesson3
Lesson5....................Lesson15 | Lesson4
.................................Lesson11 | Lesson5
.................................Lesson30 | Lesson6
.................................Lesson13 | Lesson7
..................................................Lesson8
The sample data could be long and a lot, so it's best if the formula can be made flexible to cater for this requirement.
Please refer to the attached file for some sample data.
View 9 Replies
View Related
Jun 16, 2009
I would like to make an IF-formula in excel. The problem is that i would like to to it for 12 different commands. i.e "IF(A1=14;243;"") but for 12 commands I saw that the in-built IF function in excel only manage 7 commands, is this true?
And how do I write the formula,
View 9 Replies
View Related
Mar 14, 2007
Is it possible to make a setting in the registry, so next time excel opens
the addin is not "marked" in the addins-list. I can't do it manually because, because the close_event in the addin will be executed and that will screw things up.
Currently I'm looking at the regkeys: addin-manager and options, I see a change in the registry if I close XL when I unchecked an addin from the addin-list. It looks promising, but Iám not familiar with it
View 3 Replies
View Related
Jun 20, 2006
I know how to insert, read and manage comments fields in Excel, however I want to be able to refer to a comment in another spreadsheet. For example
Spreadheet One contains a series of figures, against one of which a comment has been attached.
Spreadsheet Two has links pulling information from cells in various spreadsheets including the cell in Spreadsheet One which has the comment.
View 3 Replies
View Related
Nov 26, 2009
I wish for a macro to look in to a directory which remains constant, but then looks within a folder which is specified via a cell value in order to load a specific sheet from each file in to the workbook I am currently using. I wish for the loading to be done without having to open the workbooks manually, so something which opens them copies the data from the sheet specified and then closes.
This data is then to be pasted in to a new sheets within my workbook which are named after the file names that it pulls the "dump" sheet from.
As a side note, I will be using these sheets to produce calculations hopefully automatically as soon as they are loaded. They all have the same "shape" but contain differing data. Will it be easier in the long run for me to use this method of pasting data to new sheets named as their file names assuming there will be around 25 "dump" sheets needing to be loaded or would i be better having them paste all to one sheet just underneath each other with a couple of rows separating them?
View 8 Replies
View Related
Dec 13, 2007
I have been working on a spreadsheet to manage my players in a virtual sports game. I have worked out that the optimum skill scores for all the positions and want a way to compare a player to the optimum.
For example:
1st2nd3rd4th5th6th7th
Position 147.1737.6742.0533.8313.6711.3317.33
These are the averages for Position 1
How do I find the player who closest matches this optimum. Players have scores in the same 7 skill areas.
View 9 Replies
View Related
Feb 28, 2007
i have a column (A) with a bunch of "K"s in it....scattered through 150k rows.
in column B, i have values for every row.
What formula in C1 will search col. A and return B values for All "T"s in column A?
View 9 Replies
View Related
Sep 22, 2012
I have been trying to get Excel (2007) to change the colour of tabs to match other tabs in the workbook
Using this code I get the colour code of the current tab
Code:
x = ActiveSheet.Tab.ColorIndex
But when I use this value in a procedure like this:
Code:
ActiveSheet.Tab.ColorIndex = x
The tab is a different colour!
View 3 Replies
View Related
Oct 12, 2009
I have a summary page that includes the titles for each tab within the excel 2003 workbook. I want to use the names of the tabs in the summary page and create it into a formula to lookup fixed cells within the various tabs. Sorry for not uploading an excel doc but I was at work earlier and the thread did not load for some reason, so I am reposting it.
View 3 Replies
View Related
May 20, 2006
I'm having a problem with a form where I have created several DatePicker controls.
Once the user select the control and select a date, it's saved on a cell (all the data is stored as a record, including dates). However, the user could not select a date, and, in this case, I should record nothing on that cell. What I have done is to enable the checkbox property.. so I assumed that the date is valid if this checkbox is checked (however, I don't know how to validate if this checkbox is checked or not). The checkbox property for the date picker is a yes/no value that just show the control as enabled/disabled whether you check or not that checkbox.
Question I have is: How can I do to see if I should be saving a date or not on the cell? I have tried different formulas without success. Sometime works and sometime no. I'm using the following code to validate if the user has selected a date:
If IsNull(DTPicker18.Value) = False Then
Worksheets("DAT").Cells(nPubRow, 37).Value = DTPicker18.Value
Else
' If the user deselected the checkbox I should delete the cell content...
Worksheets("DAT").Cells(nPubRow, 37).Delete
End If
What happens is that sometimes this condition returns True.. but others it returns a 0:0:00 value that is not null.
View 2 Replies
View Related
Nov 29, 2007
1- I have a list full with numbers in a column. And I want to count how many digits are there in every cells. If digit of the number is less than 7, macro will complete it to 7 digits by adding 0 (zero) at the beginning of the number.
Example: A1 = 85468... A1 value is 5 < 7 in this case our number will be 0085468 (total 7 digits)
PS: sometime, when numbers start with 0 (zero), excel delete all 0 value at the beginning of the numbers. Macro should prevent this error.
2- I have another list with 2 columns which arranged in order. I mean:
A1=xx1, B1=xx2, A2=xx3, B2=xx4, A3=xx5, B3=xx6... etc. One is at A column, next number in B column.
My request is I want to make this list 1 column as arranged.
A1=xx1, A2= xx2, A3=xx3, A4=xx4... etc.
3- Macro will add a new line to the end of the above list with this format:
Z00001xxxx
Z00001 is static
xxxx is number of the full cells of A column plus 1. It will be 4 digits. If count is less than 4, it will complete it to 4 digits.
Example: if there are 15 cells in the list, last line will Z00010016 (15 + 1)
View 9 Replies
View Related
Jun 25, 2008
I'm using Excel '03SP2 on Win 2000sp4. I believe I have a case where old tabs originally written in Excel ' 97 behave differently than new tabs in the same workbook, which is saved in 2003 format.
Specifically, the formula ="PLAN" & budyr-1 where budyr is a named range on a different tab containing 2008 . This formula yields PLAN 2007 on a new tab and #VALUE! on an old tab.
How do I get Excel to update the old tabs so that they behave as Excel 2003 tabs?
View 8 Replies
View Related
Oct 10, 2011
VBA coding for automatically saving an excel file as another file using the current date as part of the file name together with "32ga" as a constant add-in. I also what this macro to run at a particular time of the day let say 00:20hrs. The excel file i want to save as is always open . It has data that changes every 24-hrs.
View 1 Replies
View Related
Dec 18, 2012
I have a template file for ordering trafolyte and steel plates. I have added macros to this template file. The existing macros do the following (shortly described):
Macro 1: clears order
Macro 2: update order date + send a read only file to the supplier of plates + save a read only copy of the file into one of three folders acc to info in one of the cells.
It's the Macro 2 I want to edit.
I want to add a "function" which copy a selection of data.column A to N from row 12 to 548 but only the rows where there is a value in column A.
Row 1 to 11 includes standard order info and Macro buttons.
Row 11 includes the heading for order data.
For everytime someone click on the Macro 2 button in the template file, I want the selection to be paste into the first "available" row in a "Total list" file.
The "Total list" file may have to be open (or a function to open, paste selection and then close the "Total list" file may be added)
File and Folder info:
To simplify suggestions, the following file and path info can be used (I can change to the correct later):
Template file name: template_order.xlsm
Template file location: \servershared emplate
Total list file name: total_list.xlsx
Total list file location: \servershared otal
Selection info:
The template file exists of a "general order info area" A1:N10
The column heading for order data is located at A11:N11
The selection to be copied is A12:N550 - But only rows where column A includes data (not empty).
(If the spesific order consists of 14 plates than there will be item no 1-14 in column A and I then I want to copy A12:N25 (row 25 will be item 14).
When I try to use record macro it looks like it only records what's happening in the template file - It doesn't record the pasting in the total list.
View 1 Replies
View Related
Dec 22, 2009
Is there anyway to have tabs within tabs? Right now there are only two layers...workbooks and worksheets within workbooks (tabs). Is there anyway to have more than two layers?
So right now:
1) Workbook
a. Worksheet
b. Worksheet
Can we get to:
1) Workbook
a. Worksheet
i. ?
b. Worksheet
i. ?
ii. ?
No?
View 8 Replies
View Related
Jan 15, 2014
I am trying to run a VLookup across 19 tabs. The formula and result are below
=Vlookup(2255099,INDIRECT("'"&CENTERS&"!A5:R395""),13,0) returns a #VALUE
When I evaluate the formula, the result is:
=Vlookup(2255099,INDIRECT("'"&#VALUE&"!A5:R395""),13,0)
Does the #VALUE where CENTER was mean there is a problem with my Named Range?
View 8 Replies
View Related
Oct 13, 2008
Is there a way to group tabs? For instance, I have 3 tabs that go with one section and 3 with another and so forth. Is there a way to group them? Also, can you change their color?
View 3 Replies
View Related
