make

I need to take a date (currently formatted as 07/25/2019) and make a new column into text with 8 characters. 07252019 Ideas?

Hi, I'm completely lost where to start with this one. I have a table of data (Column A = Project Number, B = Name, C = Address, etc) then at the end of the table in Column O, i have "Make folders?". I am trying to write a piece of code that when the user marks that cell with "yes", a command...

I'm slightly unsure of how to pose my question. Basically at work I work with a log that has hundreds of entries. Each cell in the row has no overflow, save the last one called "comments". My goal is to make it so the comment cell isn't stretched to the point it is off screen, but also not...

I use this code to transfer my data from one workbook toanother: Windows("IK-periode26.xlsm").Activate Sheets("Result").Select Range("B6:G6").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Windows("Arbejdsfil v2 - IKS(TESTER).xlsm").Activate Sheets("Result").Select...

hi all.. how to make formula to determine mark "V" (checklist) if in a range e.g range D3:I6 found mark "x" my "x" in always in different position cell (random) like this layout : <tbody> given given given given given given x test1 test5 test9 test2 test6 test10 test3 test7...

Looking for some help? I have a spread sheet with approximately 500 line entries that include (Make, Model, Serial Number, etc..) I want to take my monthly list of serial numbers from another source and apply them to the current spreadsheet so that the line items would...

Hey guys, I need a help. I have a excel file with lots of macros VBA codes to make invoices. There are around 5-6 pages in the excel file. Is there any way to make this excel file go online ? I mean that can i upload it in a server/cloud where multiple people can access it at the same time and...

Hello All, I'm trying to write: Countif G2:G32=G34 & I2:I32="Full Hol" But I cant make it work, where am I going wrong? Thanks

Hi - I have a report that spits out false info. Due date (F) populates 2 dates. In this case there are 4 x 27/06/19 that shouldn't exist. This in turn means the WIP Qty is 4 numbers short (I). How can I push (I) down everytime it finds the wrong date? That would also depend on Job # (C) being...

Hi, I have the following line of code which is taken from a recorded macro and works: ActiveCell.FormulaR1C1 = _ "=INDEX(INDIRECT(""'""&RC10&""'!""&RC11),MATCH(RC[-4],INDIRECT(""'""&RC10&""'!$A$3:$A$100""),0),MATCH(RC[1],INDIRECT(""'""&RC10&""'!$D$2:$N$2""),0))" What I would like to...

Hi The following code works to make visible all sheets following different views, and i have been trying every syntax for a 1 line solution For Each ws In Sheets ws.Visible = xlSheetVisible Next ws Is there a command like...Application.Sheets.Visible =...

I used to be able to hover over a VALUE, ROW or COLUMN and cursor would change to a small arrow. Once arrow popped up I could "right click" and all the elements that were the same would highlight as well. This allowed me to make formatting changes quick and easily. Was this functionality...

Hi! I have a formula that I use to determine the text of a cell based on the text of the previous cell, and also the values of a table of numbers. It works, but I am wondering if there is a more efficient way of doing this, because I need to make one that does the same thing, but has to evaluate...

Hello, How can I make a text expand automatically to fill the merged cells as the range expands? I have a text in a merged cell (cells A10 to A15) and I want it to expand as I add rows in the range. The txt direction is vertical. Thanks.

Hi Can someone kindly help me to make a customer wise and month sales report with the file attached. Can we make with pivot table. https://www.dropbox.com/s/cdl5r9k24f6banb/Sample.xlsx?dl=0

So I am having an issue with a rather large excel workbook that grows with more information everyday. I currently have 3 formulas running on 3 different columns and I have about 7 conditional formulas that are running, a few that may over lap. This is causing an issue as it slows down the...

Hello, In the formula below how do i add IF 7% or lower make 0%? =IFERROR(VLOOKUP(B$1,OFFSET(INDEX($K$2:$K$900,MATCH($A2,$K$2:$K$900,0)),,,MATCH("*",INDEX($K$2:$K$900,1+MATCH($A2,$K$2:$K$900,0)):$K$900,0),2),2,0),"")

I have an estimating spreadsheet that we use to estimate jobs. There are 80 sheets, all identical. The sheets can be quite long, and to prevent scrolling, I froze the top row, and added some hyperlinks (using the formula =hyperlink). The links I have are Top, Materials, Labor, Summary...

I want to quickly put a range of cells containing text into an array called blockstrings. Why does the following not work?: blockstrings = Worksheets("VBAinputs").Range("a5:a" & blocknameslastrow) instead i have to use the following to make it work: Worksheets("VBAinputs").Range("a1").Select...

Hello everyone. I am new to Mr.excel. I hope I will make myself clear of what I need to do. I have a sheet of numbers and I need to find if 4 specific numbers are on the same line. For example if “1” and “23” and “54” and “132” are on the same line I need to get informed somehow. f.e. make the...