col

This code is in a module and activates the timer Sub runShowMsg() 'called from when workbook open from call runShowMsg line of code Dim RunTimer As Date RunTimer = Now() + TimeValue("00:00:10") Application.OnTime RunTimer, "ShowMsg" End Sub This code is in a button on the MSGINPUT userform...

Hi All I'm trying to speed up a process and in need to your help. I requested something similar a while back in an earlier post but can't adapt it. Here's what I do right now for each new tab. Sheet1 (Called Data) holds duplicate site names in Col A and staff names in Col B (sometimes...

Hi Many thanks in advance for any assistance. I have a table of assets on a sheet called "Assets" and collating various totals on a sheet called "Mthly Bal & P & L" In the formula below $H$3 and $H$4 are on this sheet and the formula is also stored on this sheet in cell G11. When an asset is...

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody> Hello all. I have a head banger issue. Any and all help is a greatly appreciated. This data is exported from an application. I am working with Excel 2016. My attachment shows the...

Would anyone be able to help me create a macro for a sheet I'm working on please? I have a list of data (~1000 lines), for each row, I would like a check box in col. A of each row, which when ticked, locks the 66 cells to the right (to col. BO) to prevent any editing and ideally highlights the...

In col A I have the date and time together. For example: 1/05/2019 8:09:22 PM In col B I wanted just the date, so I wrote a formula: =LEFT(A2,10) I'm not getting "1/05/2019" the way I'd expect. Instead I'm getting 43470.8398 When I go to Short Date or Long Date I'm seeing the same result...

I am trying to develop a code that will autofilter a field, that will change month to month. I have a userform where the user selects the reporting month, then the script finds that month across the top of a structured table, and then drops down 1 row to select the header of the structured...

I wrote this macro, but I feel like it can be written better, I used the macro recorder to write. Any suggest of how to delete what is seen on the screen instead of the selection.end down and right? I am filtering any blanks in Col 6 and delete all these blank cells based on the blanks in Col 6...

I have a few questions: 1) I am trying to delete all the rows in Col 4 with #, the code I have is this: ActiveSheet.Range("$A$1:$AJ$11576").AutoFilter Field:=4, Criteria1:="#" ActiveSheet.AutoFilter.Range.Offset(1, 0).Rows.SpecialCells(xlCellTypeVisible).Delete (xlShiftUp) 2) How do I...

Hi all I can't even begin to determine how to approach what I would like to happen. Can I use a formula or should I use code? I have an Inv # in col "A" and a Description in col "I". I also have a table ("wordpercent") on a sheet "Info" with a list of words - Col "N" and a corresponding % -...

Current Formula is - =IF(OR(ISBLANK($AJ2)=TRUE,$AJ2="Issued from History"),"Complete", IF(AO2="Process Support","Closed","Closed")) here problem is, when im selecting "process support" in col AO all my answers are not shown as "Closed" because, as per the 1st OR condition if col AJ finds...

I am looking to count what locations are using a specific item. I am not sure the best way to do this based on how my data is generated from an external source. I don't like adding sheets/columns if needed. Any suggestions? CURRENT SET UP SHEET 1 COL A= Locations (70,000 rows, but only 10...

Hi Team, i have data from col A to L. in my col B i have names abc abc abc xyz xyz xyz xyz xyz and in col A i have 3 different names for "abc" and 5 different names for "xyz", and go on till last record of col B. so i wanted to create workbook "abc" and it should contain their data in that...

Hi All, I have the following formula that i wanted to total up where items in Col E match items in Col F and give me back a total. =SUMPRODUCT(--('Pending Prod Orders'!E:E='Pending Prod Orders'!F:F)) For some reason its counting all the blank cells that are contained in these columns which...

https://app.box.com/s/s7qk7yds4q1gdwmhl4du9zccr4n27znh Col G formula to place digits in col B low to high Col D formula to place OE count in col D Col F formula to place LH count in col F Thanks for all the suggestions!

In Cell A1, A2, A3, A4, etc, I have test data that is colored Yellow, Blue, etc. In Cell b1, b2, b3, b4, etc., I have the values I want charted as a line chart. But, I want to chart to pick up data in col. B for cells that are colored yellow in Col. A. Without writing any VB Code, is there a...

Dear all I wrote following code Sub Macro2() Sheets("PRINT").Select With ActiveSheet.UsedRange lk = .Rows(.Rows.Count).Row End With For a = 1 To lk san = Range("b" & a).Value san2 = "'" & san & "'!" & Range("c" & a).Value Range("e" & a).Select ActiveCell.FormulaLocal =...

Hi Guys, I've been trying to roundup the result of this formula but i can't seem to make it work. Can anybody please help me. =IF($B8="","",(VLOOKUP($B8,'Type D Box Col Data '!$C$4:$H$260,5,0)*2)+1+(2*C8)+2) Thanks in advance, bnkyaong.

I have tried to apply CF to use fill color Blue to Highlight Col A:C where "Total Sales WIP" appears in Col A It would be appreciated if someone could assist me, by providing the steps to do this

Hi guys, Hopefully there is a simple solution to this problem. I would like to create a list of dates in a column based on the results of the data in another column. So, In col A i have a range of dates that are random dates from throughout the year. In col B I have either a 1 or a 0...the 1...