1) How do I get the three (3) items columns to be right underneath the ''Recovery Turnaround Days of Files Per Cheque'' heading
2) How do I get each of items #1 - 3 column, to have each their own color (that is not the same color as the '' Average Recovery Days '' column color) ie;
Item #1, 30 = I would like it to be say, Red
Item #2, 35 = I would like it to be say, Pink
Item #3, 30 = I would like it to be say, Yellow
3) How do I get the column under the ''Average Recovery Days'' heading to have it's own color scheme as well, such as as say the color ''Purple'' (or any other color that is different from all the other 3 columns).
how you go about putting the columns so they align right underneath the particular heading, that would be awesome. Also, how to have a color scheme for the ''Average Recovery Days'' to have it's own color (For the column under this heading to have it's own color, what ever color that is), that does not match any of the column colors in items #1 - 3 (under the heading ''Recovery Turnaround Days of Files Per Cheque''),?
How could I return an 'x' in column C against the A values corresponding with the G values, for example an 'x' in C6, an 'x' in C9, an 'x' in c15' etc? And a blank for example at C8 and C14.
I have this work sheet with several formulas in columns Z to AD. All of them highlighted red work fine as for as I can tell. I am stumped with the one needed for the cell highlighted yellow AD2. It should count all the dates in AD1 that are Requested Changes Made and/or Rejected in Column "M". AD2 is a total of today minus 8. Equipment Change out - TEST.xlsx
I have two columns of data each with repeats. I want to be able to look up the third column of data and then list the multiple results attaching to the first two columns.
I have attached a dummy spreadsheet of what I am trying to achieve.
[URL]...I was trying to use this thread's solution macro on my sheet that is only consolidating columns A, B, and C with a couple thousand lines and I've had it running for over an hour now. There hasn't been any errors but is there any particular reason that might be causing it to take longer than it should aside from having to go through a few thousand rows?
Basically, I only want 1 Version of data in Column B and any other rows that has a match in column B, i want to consolidate unique data from Columns A and C.
This isn't absolutely necessary, but being able to do this easily would cut down on a lot of tedious jobs for me. Let's say I have a set of data like this (I tried to space it out as best I could to give the idea):
Can you display items from 1 column on a worksheet in 2 columns on a Listbox?
This is to avoid having a Listbox that is too long for the form, (I know I can use a scrollbar and I am but I would still like it shorter if possible).
I am trying to correspond prices with products from the validate function in multiple columns. I want to select the product and have the price for the product populate in the 'cost' column. I have the list of products with corresponding prices on sheet 2 named 'products'. I have attempted to write a formula in cell G11 on the Event Sheet, but was unsuccessful. Please direct my path.
Where H1 contains the word Assigned. I need to also find and add to count for matches in I1,J1 and K1 which contain New, Pending and Work in Progress respectively.
I am wanting to create a list where I can select multiple items within that list and then print only those selected items. I have created something similar thru data validation, but I can't get it to print.
In addition, I would like to be able to subdivide the list into multiple categories, then select items from these multiple categories and print them.
I'm looking to use excel to track a number of expense items accross 15 worksheets with up to 500 rows accross 30 + columns per worksheet. Many of the learned people in this forum have helped me get this far, now I need some more assistance - please.
In my speadsheet I have a vlookup formula that returns a value from another worksheet. Here's an example.=IF(ISERROR(VLOOKUP($D3,Room_Configs!$A$1:$BO$3006,MATCH(M$1,Room_Configs!$1:$1,0),FALSE)),"",VLOOKUP($D3,Room_Configs!$A$1:$BO$3006,MATCH(M$1,Room_Configs!$1:$1,0),FALSE))
This works brilliantly. Now here comes the tricky part. What I'd like to do is append that formula with another one to do a vlookup on a second worksheet.
If both lookups return a value then I'd like the value of the 1st vlookup returned in the cell. If the value of the 1st vlookup is "0", then I'd like the value of the 2nd vlookup returned, and if the 1st and 2nd vlookup values are blank then a "0" is returned.
The name of the 2nd work sheet is "Non_Network_Equip"
Finally, it would be really great if the font colour for values returned from the 2nd vlookup forumla was blue.
If i select 3 items from a list 20 items to be show on the cube this is fine and works however if i then add another item to the list i now have 21 items and for some reason it also adds itself to my 3 selected items to become 4 items. Is there anyway I can get it to be added to the 20 items and not to the 3 items..
I know how to use array formulae to create a unique list, i.e.{=INDEX($G$1:$G$760,SMALL(IF(ROW($G$1:$G$760)=MATCH($G$1:$G$760,$G$1:$G$760,0),ROW($G$1:$G$760)),ROW()))}
however this is giving all the unique items from column G and I only want the unique items that have a non-zero value in column H as well. This would be the sumif of all instances that would have to be zero. I've tried to crack it and I've tried to search for solutions but so far no joy.
I have an Excel spread sheet as shown below. Sometimes, there are two rows (could be more )with the same items-for example, such as Inventories, but different values. How can I sum those rows with the same items and put it in a different column, and in the same time also copy over the single item to the same column? ....
The below code shows the way I add items to 10 different comboboxes. However, the items to be added are actual the same.
Is there a way I can simiply it? I am worry that by the end of day, i might have up to 50-60 comboboxes and the code will be a relativity long and not efficient.
Taking into consideration the the comboboxes will be labelled as Jieyi_task_ComboBox1...to 10 jane_task_ComboBox1...to 10 Kenny_task_ComboBox1.. to 10
getting correct formula and normally there are people much smarter then I in the discussion group. What I have is a workbook with 4 worksheets and on on of the worksheets I have a layout like this. (sheet 1) A B C 1 Name Origin Driver # 2 Mrs Soandso 125 anywhere 3 Mr. Someone 327 anywhere
Drver numbers are blank
On another worksheet(sheet 3) I have a list of subscriptions (I.e drivers numbers already filled in) I have this set up as a list.
A B C 1 Name Origin Driver # 2 Mrs Soandso 125 anywhere 37 3 Mr. Someone 327 anywhere 39
What I am looking for is a way to pull the drivers numbers from sheet3 into sheet1. so basically in sheet 1 if a1 and b1 match the name + origin in sheet 3 it will pull the driver number from that row into c1 sheet1 . If nothing matches then it should leave it blank. The data in sheet 1 changes everyday for me as I get a manifest on who to deliver wheels on wheels to, my problem is while I know all the correct drivers go to what people, I can never have a day off as someone filling in for me has to go through 400 addresses and look each one up and put coresponding drivers number into it.
I have a monthly calendar on each sheet for employees, attached is a copy of one of the sheets. I can have up to 2 combinations of text in a cell, i.e., 'V' or 'T' in this example, followed by a number, that can range from 1-12, i.e., V12T4. What I am trying to do is add up the total 'T' and 'V' time for the month for each employee. Hopefully between what I have written and my attached sheet, will explain what I am trying to do. I know how to write the =Sum(If for using only 1 item in a cell, but not 2.
Code: Set my_array = Sheets(1).ListObjects(1).DataBodyRange
Column number 2 contains numbers, but I want to 'reset' all the numbers in the second column. How can I do that? I know I can do a loop through all the elements, but I thought it would be smarter if I could set the entire column as zero in the array?
I have a code which works perfectly and adds the dates from Column A to UserForm1 ComboBox2. In column B, I have textdata - UserForm1 ComboBox5.
I'd like to transform the code to add only the dates which correspond (cascading) to 1.1 textdata in ComboBox5 (Column B) and 1.2 dates in ComboBox2 (Column A).
I have a pivot table with a calculated item. The problem is that it shows data for all rows EVEN when there is no data there. So the pivot table is a lot longer that it needs to be. How do I get the pivot table to show only rows with data in it? Also, all of the fields DO NOT have checks beside "Show Items With No Data".
Could the code be modified that if BSPT were selected only certain thread sizes would be shown in the combobox as the sizes below.
1/16" 1/8" 1/4" 3/8" 1/2" 3/4" 1" 1 1/4" 1 1/2" 2" 2 1/2" 3" 4" 5" 6" If NPT were selected have only the thread pitches to be shown in the Combobox below 27 18 14 11.5 8 can be selected
If BSP were selected different thread pitches to be shown in the Combobox below. 28 19 14 11
Private Sub UserForm_Initialize() With ComboBox1 .AddItem "SELECT THREAD TYPE" .AddItem "NPT" .AddItem "NPTF" .AddItem "BSPT" .AddItem "NPS" .AddItem "BSP" End With
I have print macros that print several different items from more than one workbook all at once. It works fine when printing to paper - you go to the printer and pick it all up in order. The problem is when I try to print it to a PDF - it prints each item to a separate file. The code below doesn't work - the second item printed just replaces the first item printed.
Sub PrintToPDF() Dim strNewFileNameHere As String strNewFileNameHere = "SomeFileName" & ".pdf" ThisWorkbook. Sheets("Sheet1").PrintOut ActivePrinter:="Acrobat PDFWriter on LPT1:", PrintToFile:=True, PrToFileName:=strNewFileNameHere ThisWorkbook.Sheets("Sheet2").PrintOut ActivePrinter:="Acrobat PDFWriter on LPT1:", PrintToFile:=True, PrToFileName:=strNewFileNameHere End Sub
How can I call several different print macros and get them all to print to the same pdf?
I want to add colour background to every other line in a Listbox (like the old computer paper green/white lines) but we know this can not be done, so everyone who knows says use Listview instead. Try as I might I can not seem to add items to the Listview control though.
This has got be one of the dumbest questions, but how the heck do you add items, its so easy with Listbox.
As an aside I wonder why no bright spark has not written a control that replaces Listbox with extra features yet.
VB: Sub a() Dim WB1 As Workbook, WB2 As Workbook, MyFile As String, Sep As String, WS As Worksheet Dim R As Range, X As Integer, a As Range, b As Integer, rownum As Integer, WS1 As Worksheet Dim R2 As Range, a2 As Range, row As Integer, sep2 As String, MyFile2 As String
[Code] ....
If I run this code without the miles of code i have between them, it loops through each workbook in the folder just fine.
However, I am getting a Runtime 5 error when it reaches Myfile = Dir() each time with my full code.
Here is the full code:
VB: Private Sub CommandButton1_Click() Dim WB1 As Workbook, WB2 As Workbook, MyFile As String, Sep As String, WS As Worksheet Dim R As Range, X As Integer, a As Range, b As Integer, rownum As Integer, WS1 As Worksheet Dim R2 As Range, a2 As Range, row As Integer, sep2 As String, MyFile2 As String Sep = Application.PathSeparator
[Code] .....
Once again, I am getting the error message 3 lines from the very bottom ("MyFile = DIR()")
Ok, so basically I've been asked to create a chart that lists the top 3 types based on count per year. I don't want to make 4 charts, but my top 3 types differ by year.
Type would be column #1, and Count would be column #2.