I am trying to write a formula, but i am stuck.
MAIN SHEET - In column A, each cell contains order# (text or number) Then in column EE there will be a month that this order came in.
Now on my SUMMARY SHEET I have the below formula in C191 (B191 represents the month), but not getting the...
I have a question and I am stumped.
I have a userform1 that is filled then when a label28 is pressed a userform pops up with a listbox (multi selection). and a label underneath for the merging of the selections. Now I am stuck trying to make this work and also how would I make it that the...
Currently I have anywhere from 5-32 command buttons on each tab (worksheet)which I have 32 worksheets. Each Command Button Will change color if selected as well as enter data in a cell that I specified. As well As if selected again...... See current code,
Private Sub CommandButton38_Click()...
I am trying to figure out how to create a formula to do the following. Hopefully someone can steer me in the right direction.
(SHEET 2008) Column A is order #, Column B-E is ECO Column F-I quote # and Column J is Month
SHEET (BTC)
Trying to create a formula so that it will look in Sheet 2008...
How is the code written so that when a userform is open that it shows what was in the cell that it refers to?
I have 6 yes & 6 no option buttons and 8 list boxes.
The code I have thus far reflects what should be filled and where it should go on the worksheet, but don't recall how to make it...
Just wondering if someone can help with the macro to Concatenate two listboxes in a textbox. I have tried but I can't figure it out.
I have two listboxes filled with selections from BTC sheet, these listboxes are on a userform. The two are exactly alike since it is designed for rev changes.
I...
sorry to be asking so many questions. but have been perusing through to find something that can help, but can't find it or i don't know what I am looking at.
Anyway, my question is.
if I have typed a 1,2,3... and so on, in column A on sheet 2, rows 2, 9, 13( now each can be different each time...
You can see that I am trying to fill a cell on another worksheet, but with this code, it always ends up blank because A145 is blank. How do I keep this from happening?
Range("A139").Copy Destination:=Sheets(1).Cells(279, 1)
Range("A141").Copy Destination:=Sheets(1).Cells(279, 1)...
Me again,
I didn't want to bother you, but have tried and tried to get the command button to change color when I click it. Nothing is working... so I am asking, is it possible?
Private Sub Command1_Click()
counter = counter + 1
If counter = 1 Then
counter = counter - 1
End If
If counter = 1...
Was wondering if anyone has ever had the experience when clicking a command button that it will fill in a cell( e.g. A1) with the name of a command button that was pressed (e.g. HC12).
Thanks all
Ok, i have been trying to put together a formula for days now, and can't seem to get it working. What I have so far in cell H53
=B53*C53*IF(Q53="MOH OK",1,1.1346)*IF(R53="$",1,1.29)
(Now MOH OK and $ are drop down selections)
B53=Qty C53 = Cost MOH and $ are...
I hate to keep asking questions, but need some help on Formula writing inputed in a command button. I have never done this and seek your professional help.
I have 25 cells that have percentages for Markup puposes depending on selection.
e.g. 2.2L ( placed in Cell R2) is selection...
Before I begin, just wanted to check to see if I can do a macro that will take a row below and subtract the row above it for each line... However, the glitch is that there are different companies and some contain more rows than others so this would need to start over at that row with company...
I have created a command button to hide rows.... depending on the cell. However, I am trying to unhide the rows but stuck as to how to achieve this. I also want the button to change names each time you select it. eg. All Data / Main Data. The macro I have thus far is which works great. My...
Maybe someone can help....
I have created a simple macro that copies a worksheet (in the same workbook)and inserts a new worksheet. However, the format is totally different. The copied worksheet is landscape, but when it copies and inserts, it changes the column(s) dims as well as portrait...
I have been beating my head and cannot seem to figure it out, hopefully someone with more smarts than I can help me.
if I have a cell that contains characters,
e.g. Cell A10 contains OA/01 and now I am in Cell D4,(That already has a formula assign) I want to have this cell note that the...
I have been beating my head and cannot seem to figure it out, hopefully someone with more smarts than I can help me.
if I have a cell that contains characters,
e.g. Cell A10 contains OA/01 and now I am in Cell D4, I want to have this cell note that the second character (in this case...
