contents

I am trying to create a loop that will clear the contents in column A if the value is less than 2904 OR contains any text. I am struggling with the text portion of the loop. The text is different in each cell. This is what I have: Dim LastRow2 As Long LastRow2 = PLSR.Cells(Rows.Count...

I have 3 sheets, on each of the sheets the user inserts a date in Cell B1. I need all 3 dates to be the same at all times. So if B1 is changed on Sheet1, it needs to be duplicated on Sheet 2 and 3 in the same B1 cell. I'm not sure how to do this as I can't use a simple formula because the user...

Hello,</SPAN></SPAN> Below example columns C:K result are by formulas, all formulas have not an outcome; in that case the formula has leaved a cell blank with (""). </SPAN></SPAN> Now I need a VBA code that does 3 actions...</SPAN></SPAN> 1-Copy values of columns C:K into M:U</SPAN></SPAN>...

Hi, Hope someone out there can help. I keep getting an error message but I don't understand why. I have a formula is cell B3 which is =IF(FIND("",A3,1),MID(A3,4,99),A3) Cells in column A will contain a string which starts with xx\ or just yyyyyyyy What I was hoping the formula would do was...

Hi, Going down a table with a dynamic number of rows - If cell G contains the word "Alpha" I want to clear contents in the cell that sits in column S of the same row. Eg. if cells G20, G34, G49 say 'Alpha' then the contents of cells S20, S34, S49 should be cleared. Is this possible? Thanks...

Hey all, Hopefully a quick one for you guys. I am looking to auto filter G6:G500 depending on the contents in G4. For example, if G4 contains 'Fred' all the G7:G500 cells containing 'Fred' are filtered and become visible. If G4 changed to 'Dave' all the cells in G7:G500 which contain 'Dave'...

Hello All! I'm using this code to delete contents in a Cell Private Sub CommandButton2_Click() Sheets("Calculator").Range("K3").Value = "$0" End Sub How do I keep the Formula in Excel from deleting every time I hit the "Clear Button"? Thank you!

Hello, I've been googling extensively to try and find a solution to my problem without success. Perhaps someone here can help me. I have a worksheet in Workbook1 that I would like to create a drop down list dependent on specific contents located in Workbook2. Workbook2 is referenced by other...

Hello all! New to VB and have a question. I'm trying clear contents in one cell once a drop down is selected. I select a drop down that displays pricing in the the "System Pump" and "VFD Pricing " Cells. What I'd like it to do is clear just the contents in (VFD Pricing $) once "NO" is...

Hi, I'm trying to create a userform which takes some input, writes the contents to last line of DATA.TXT file in same folder. Then retrieve last 10 entries from text file into userform text box. Unsure how to copy the data to text file at last row Appreciate any help

I want to output contents of a column( if not blank) along with 2 other columns to a separate worksheet , but want all the results to show under each other and not have blank lines on the separate worksheet. Using combination of IF & Vlookup to display , but can't see a way to remove blank...

Hey all, Hopefully someone will be able to help! I have digits ranging from 0 - 100 in K4:K60 in a worksheet called ‘Raw Data’. There is also written contents in B4:B60 and C4:C60 in the same worksheet (Raw Data). What I am trying to do is identify any digits in Column K that are under 60 and...

I've done some searching and can find ways to clear data from a cell but I need another variant. As an example: If Sheet1 A1 is 0 or blank, clear cell contents on Sheet2 A5. If Sheet1 A1 is greater than 0 then get cell contents from Sheet1 A2 and put it in Sheet2 A5. I can manually enter cell...

I am trying to get some VBA code, that will insert a formula in the next available row in Column I. The formula needs to match the contents of Column C and O in that row with the cells in the row above and return with the contents of the cell above. I hope you can see the image i've tried to...

Hi, if someone could help, I'd greatly appreciate it. I've been working on this all week, and I can't find any solutions that fit my problem. I am using the following code and it works perfectly for Row 3 (first row of data entry). This sheet will go on forever as a living document so I need...

Hi All - We are using file merge function to merge the contents of excel files, each excel file is unique with name, date and time. When the files are merged the contents of the file get merged row wise - at that time, we want to include the file name of the merged files as one of the logged...

I am trying to figure out if a formula can be used to control the format of a cell For Example If C3 or F3 is populated, then, make the contents of B3 bold Is there a way of doing this?

Hi, I'm hoping somebody can help with a code to clear the contents of a cell in a range, if that cell contains less than 5 characters (it may be a "." or "yes", etc.) Starting in row 2, Columns E to K will contain an extract of comments. However, some cells contain a full stop, "N/A" etc...

Hallo, What can you suggest for the following? Description: There are 2 workbooks, workbook A (wbA) and Workbook B(wbB). wbA - is a summary file, which has several columns filled in on daily basis. Each row in column A contains sheet names of wbB. https://ibb.co/kBcghU wbB - is a...

Hi all A bit of a complicated on in my eyes. Table is as shown If a "N" was to be entered in cells G10:G21, I would like the corresponding row cell contents from column B to E to be copied into a new table starting at B35. In addition, if a further "N" is added in G10:G21, I want that...