I have the following code that lists all the worksheets in workbook. I would like to have this list show only the worksheets that end in "SD". (For example, it would show "MainSD" or "CantonSD" but not "Main".)
View 14 RepliesI need to compare two worksheets, and show the final results in the Results Sheet.
These two sheets are actually .CSV files and is why some of the cells show as dates.
The SKU column is a combination of Material and Length. we need to find the difference for the Qty of SKU items.
If you look at the results page you will see what the results should be. Colored cells are just to show the differences in the example.
I'm creating an excel workbook that will allow any business or accounting student to go in and create their four year plan while giving them all of their requirements for their particular degree.
One of the features I wanted to have with this program is that it wouldn't display all the worksheets for each major, but rather the ones you choose that you are associated with. I was going to have a drop down menu on the first page that allows you to choose your majors, those being accounting, or business administration with its 5 focuses.
If I just allow all the worksheets to be shown, there would be 6 in total and I thought it might get confusing for a student who's only taking one of the 6. My hope is that on the first page, when you choose one of the options, it would automatically display the hidden worksheet that goes along with that major.
I have a workbook with multiple worksheets, and I am trying to create a title sheet where a user can select their name from a drop down list, and Excel will show only the tabs that are associated with that user. For example:
The worksheets in the workbook are:
Heading
Control sheet
Client Relations Admin
Sales Summary
etc...
The user Hudnall needs to see the sheets:
Client Relations
Sales Summary
The user Ferguson needs to see the sheets:
Sales Summary
Control Sheet
I want the user to be able to select their name from a drop down list on seperate sheet, and have the Macro show only the sheets that they need to see.
I am trying show an exact match of data between two worksheets, but I need the match function to look up 2 columns - i.e. reference number AND order number between two different worksheets.
In the example attached, I am able to find the match of one column only (order number)
Essentially what I want can be shown in outline form:
I. Stats (workbook)
A. 2009 (worksheet)
1. Jan (worksheet that appears only when 2009 worksheet is clicked)
2. Feb (worksheet that appears only when 2009 worksheet is clicked)
B. 2010 (worksheet)
1. Jan (worksheet that appears only when 2010 worksheet is clicked)
2. Feb (worksheet that appears only when 2010 worksheet is clicked)
I was hoping there was a way to have one workbook that displays only the years (2009, 2010) as worksheet tabs but once clicked, would reveal 12 nested worksheets (one for each month). Once a different year worksheet was clicked, the month worksheets currently displayed would hide again.
i have the code below attached to a button and was wanting to know how (if possible) i could do the same thing but to all sheets so that i could have one button that removed all the autofilters in the work book ....
View 9 Replies View RelatedI am trying to figure out how to initialise a multipage userform. I have two worksheets, one with a contact 'database', and one temp that holds search results.
I understand how to load data from the worksheet and write it back using a single useform, but this is foxing me just a tad!
When I call a series of subroutines from different worksheets, ScreenUpdating = False is not working.Here is my
Private Sub Worksheet_Change(ByVal Target As Range)
With Application
.Calculation = xlManual
.EnableEvents = False
End With
If ActiveCell = "No" Then
Call Sheet3.DisableTBs
Call Sheet4.DisableTBs
Call Sheet5.DisableTBs
Call Sheet6.DisableTBs
Call Sheet8.DisableTBs
Call Sheet9.DisableTBs
Call Sheet10.DisableTBs......................
I have 1 source file that shows all the changes we made to the following 14 spreadsheets; essentially a change log.
I have 14 excel spreadsheet...the last tab in each of them have an object (the source file) captured, so they are all identical
Lets say the 14 spreadsheets are Makes of cars...(1 for Dodge, 1 for Ford, etc)...each time we make a change to the car, I log that change in the source file.
Lets say I have 33 things for dodge, 17 for Ford, 39 for Lexus, etc...all in the change log. Is there any possible way for the final tab of each of those docs, to ONLY show the changes that are specifc to that model?
My actual scenario is different, but this is the same concept and much easier to explain. If this is possible, I'd like to go a step further to know it is can be linked to the source file so it updates upon opening just like the object does now.
For what its worth, you can key off of column A in the source file....that is essentially my "Model" column.
I need to refer the LAST ROW OF COLUMN "D" to appear in the message box for the below code along with " Receipt number" which is in Sheet2.
Sub saveit()
With Sheets(2)
r = .Range("B65536").End(xlUp).Row + 1
InvN = Cells(15, 4).Text
If Range("c18") = "" Or Range("c20") = "" Or Range("c20") = "" Or Range("c24") = "" Then
MsgBox "Please fill all required fields", vbCritical, " Missing data"
Exit Sub
End If...............................
I have a excel workbook, which sheet2 (vehicle arrangement) is master data sheet. which column headings are match with other worksheets. whenever I put the cell value of any multiple rows or column, the cell value (number) and rows (text) are copy or show in the particular sheet which name match with column head.
Sample:
Customer Name
ORDER
MMT
TIL
VBG
JKL
SSL
RDF
ERG
RFG
ERRT
WC
ARS
YUH
TOTAL
M/S XYZ
50
[Code] .......
Worksheets are names as column names is here.. "MMT","TIL", "VBG"........"YUH". So whenever I give the cell value under the column head the same value and corresponding row (customer name) should be show in the particular column head worksheet.
I require a formula that will show unique data in a specific rows or cells. Here are the data:
Raw Data
Col1
Row 1 A
Row 2 A
Row 3 B
Row 4 C
Row 5 C
The result should look like this (Note that the unique data are displayed in rows 6 to 8:
Col1
Row 6 A
Row 7 B
Row 8 C
I need a code (and where to put it) to open my application excel with only the userform so, with the workbook hidden.
Application.Visible=False doesn't work because it close all excels and moreover I can see the workbook for 1 or 2 seconds before hiding.
I am after a code that will sort out the below printing problem
I want excel to hide column E from the printer, i want to see the information myself but when i press print column E will not show
http://www.excelforum.com/excel-new-...ml#post2034148
How to find and show position number? I try merged two function, but doesn't work
1º=FIND("0";B2)
2º=FIND(CHAR(1);SUBSTITUTE(B2;"0";CHAR(1);2))
Number
Position
[Code].....
You could use:
If ActiveWorkbook.Sheets.Count < 17 Then
Application.CommandBars("Workbook tabs").ShowPopup
Else
Application.CommandBars("Workbook tabs").Controls("more Sheets...").Execute
End If
The code doesn't do anything on my excel workbook which currently has like 20 workbooks, and it grows daily by like 4 or 5 worksheets.
How can I create a formula to add up how many cells in a column show a particular set of text? For instance; the column in my spreadsheet looks something like this:
MJR
DML
MJR
RJG
RJG
MJR
DML
I want to know how I can create a formula that will automatically tell me how many times "MJR" is listed; how many times "DML" is listed, and so on.
I have a paragraph that i am trying to change a number in the paragraph. example
John has 3 kids he sells one kid he has 2 kids left. Later John's wife figures out and kills John 4 times.
I am trying to replace the "4" to an imputed on an user fourm imput box can i do this?
I have a worksheet that has a months worth of data on it. The sheet is divided into sections with each day of the month being given 10 rows. So day 1 of the month will occupy rows 1 to 10, day 2 rows 11 to 20 and so on.
In each of these sectors, I would like to have an editable tick list that displays when a certain cell is selected. For example in day 1, selecting cell A3 will display the tick box. If I need a tick list for each day, would I need to create a fresh userform for each day or is it possible to have just one form and have excel remember the setting.
I have a spreadsheet with four columns of data for every month (i.e. January has a Prior Year, Budget, Outlook, and Actual column). I have been trying to come up with a macro or form that will allow me to customize which columns I would like to see and hide the rest. For example, if I chose to see the Budget and Actual columns, it would hide the Prior Year and Outlook columns for each month.
View 2 Replies View RelatedI have 2 worksheets in which the worksheet named Existing Items has a table consisting of list of items with their unit price & worksheet named New Items also has a modified table with updated items (some parts might be added, removed, modified or unchanged). I have attached the test workbook (Sample.xlsx) here for your reference.
I am looking for a macro that compares these 2 sheets with the Part Number as a Unique Identifier & displays the result in the following manner:
New items added in New Items -> List these items in the Items Added worksheet Items removed from Existing Items -> List these items in the Items Removed worksheet Items whose price has changed in New Items -> List these items in the Price Change worksheet Items whose price has not changed in Existing Items & New Items -> List these items in the Unchanged worksheet A Summary worksheet which shows the count of items added, removed, modified & unmodified
Note that I have already included information in the Existing Items, New Items, Price Change, Unchanged & Summary worksheets just for your reference but this needs to be done by a macro.
I have a workbook with 50 sheets. Within each sheet are rows of text that I need to search for specific text.
I'd like to search each row from each sheet for specific words (e.g. "7 days") then show the resulting rows data/text in a new sheet along with the name of the sheet and row number it came from.
e.g.
Sheet 1 contains the text "7 Days" on line 40
Sheet 2 contains the text "7 Days" on line 1, 30, 50
In a new sheet, I would show the entire row in its own row that contains the text "7 Days" along with the name of the sheet and row number it was found in
I would like to use VBA to combine specific sheets. I have a workbook containing about 15 sheets but want to combine 6 specific sheets. All the sheets have the exact same headers and number of columns but the number of rows are different.
I found this VBA code that works but it combines ALL of the sheets in the workbook. How to modify this to combine specific sheets. How to combine all visible sheets if that's possible.
Here is the code I found...
Sub CopyFromWorksheets()
Dim wrk As Workbook 'Workbook object - Always good to work with object variables
Dim sht As Worksheet 'Object for handling worksheets in loop
Dim trg As Worksheet 'Master Worksheet
Dim rng As Range 'Range object
[Code] .........
I have tried Sheets("").Select to just have the macro work on any worksheet in a workbook not just on the specific worksheet (i.e.Sheets("4474-60-2").Select . Get an error though.
View 9 Replies View RelatedI have a data validation list where more than one value should show the same list. Instead of make multiple range, I want to make it so if any of the values are in a cell the data validation list will show the list that goes with those values.
View 4 Replies View RelatedBasically I have a big table containing several columns for the different quarters. (Each quarter has several columns which are not all next to each other)
I would like to use 4 checkboxes which the user can select the show or hide the columns for that quarter. E.g. if Q1 and Q3 are checked only those are visible)
(if quarter 1 clicked than all columns are visible if unclicked hidden).
The code I have written workes well for the first checkbox (Q1), but for the other quarters (Q2, Q3 and Q4) the columns get hidden when checked (which should be the other way round) and don't get unhidden when unchecked.
Sub CheckboxQone()
If Range("$A$1").Value = True Then
Call showQ1
Else: Range("$A$1").Value = False
Call hideQ1
[Code] ...........
I have two worksheets. On one worksheet under column G I have hundreds of random numbers, but I only want to extract a specific half. In the second worksheet I have two columns A and B. Column A has the exact numbers that I want to extract from Column G. I would like to get the numbers from Sheet 1 under column G listed under Sheet 2 Column B in reference to Column A.
View 9 Replies View RelatedI have five worksheets hidden in my workbook. All of these worksheets have either "Yes" or "No" written in cell C4. (3-yes, 2-no)
I also have a search bar in the form of a textbox and a command button.
I want to be able to type "No" in the textbox, click the command button and have the pages with "No" in cell C4 to unhide.
Some screenshots if necessary:
Sheet1 (yes): Gyazo - ce85d71bc03cd2ceaa1030e22445800f.png
Sheet2 (no): Gyazo - 65f876d6e7d749bd1ca25ad957fbda99.png
Sheet3 (yes): Gyazo - 0cb442f1d34e7d744884f73e1afe2646.png
Sheet4 (yes): Gyazo - 6f0ce150322208fd93dc5fc6f4f66481.png
Sheet5 (no): Gyazo - 772f48f8a82e53713794e6655fe56fca.png
master: Gyazo - 1b71470f3de47cef347050588bca819c.png
Looking for For Loop to loop through 5 specific worksheets in a work book.
Something like this, but can't find right syntax:
For iCounter = 1 to 5
If worksheet.name = "Recap" & iCounter Then
'do stuff
End If
Next iCounter