code

I have a macro that will identify whether there is any value in a specific cell in each tab. If it is blank, go to next tab but if there is data, delete all data and go to the next. The issue I am facing is that the code below will delete only the data set but leaves blank rows (checked by...

Hi all, I have this file that was converted from PDF to Excel. I would really like to filter everything in column A by date However, when I do it looks like this: It filters down until row 687 The row looks like this: I have no idea why it stops? It used to stop at points like these...

Hi all, I am very rusty in Vlookup (embarassing!) and I am currently looking at this data: I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G. I...

Hi all, I currently have a data set that looks like this: The issue for me is that it is currently stated in a format of "Month-Date-Year". I would like to replace this with a format of "Date-Month-Year". Does anybody have a nice solution to this, for example a formula as illustrated in my...

Hi all, I currently have a very large data sheet that looks like this: In this example, I've just put in a format of: Date,Name,Gender Please note that some of the cells however might only have Date,Gender or Name,Gender or Date,Gender etc. My ideal format would be: Date,Name,Gender...

Hi all, I am currently working with a data set that looks like this: I would like a formula that takes all the values in column A, and if they begin with a comma (","), it should remove this So the result should be like this: Does anybody have a formula for this? It would be greatly...

Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...

In Module of my Workbook (coded.xlsm) and for the Worksheet (tab named “ZZZ”) I am using User Defined Function to get outputs in some cells where UDFs are there. 1 line of the code is If Sheets("ZZZ").Range("WA10").Value = "=1" Then GoTo finish End If Should I replace the above lines with...

I have a code whose 4 lines are: If a(q) > 0 Then findhigh = Format(a(q), "0.00") GoTo finish End If I want to understand, If a(q)<=0 Then WHAT WILL HAPPEN? Will GoTo finish line get ‘activated’? 2nd line will not be activated? i.e. IF the If condition…is not TRUE Then does it works as Else...

In my Workbook there are numerous Worksheets out of which approximately 30 ws are using ‘Worksheet code’. In ‘ThisWorkbook’ also I am using a macro. In Module, I am using a ‘vba code’ for Worksheet (tab named “ZZZ”) using 'User Defined Function' to get the output in some cells wherever UDF is...

I am looking for a VBA code/macros that does the following... Compare the data in a cell from Column A from Sheet 1 to the data in a cell in Column B in Sheet 2. If the data values are equal, then I want to take the values in the row from Column D in Sheet 1 and past them into the row in Column...

I am using a Function findhigh as Function findhigh(a As Range, b As Range, c As Range) As String In the code. Then I am finding number of 1s in c Range using y = Application.CountIf(c, 1) Now the code works smoothly when If y >= 3 Then If a(y) = 0 Or a(y) = "" Then GoTo finish If...

Hi, i have a button on my spreadsheet to save the sheet as a PDF but i can figure out how to get it to create a copy of the file in excel with the same name and save both that copy and the PDF in the location of where the file original file is saved this is my code currently: Private Sub...

Hi there, For my accounting homework, I need to construct a balance sheet in excel. As you may know, Total Assets should be equal to the sum of Total Liabilities and Equities. At the bottom, I have 2 cells, one of them represents the sum of asset items, whereas the other represents the sum of...

Hi all, Can I know how to get month in “mmm” format if I have a date in its previous column. For eg: column A contains date in short format. I want column B to show only the month in “mmm” format based on the date in column A. Similarly column C will show only the year in “yyyy” format. How to...

Hi all, I currently have this code, which saves my sheet (entitled "Sheet3") as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As String Path = "S:\Path\PDF files\" fn = Range("A63") ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Path & fn & ".pdf" End...

Hi all, I currently have a macro that converts my excel sheet into a PDF and saves it in a designated folder. However, I only want it to save the first sheet as a PDF, and ignore my other sheets, which it will not do at the moment. My code looks as follows: Option Explicit Sub...

I am trying to write a code using Selenium Basic. I am extracting messages from a messaging service. I can extract all the messages using FindElementByClass, however this returns all the messages and does not contain any details of who the message is from. I need the messages returned to the...

I'm at a point where i'm bringing in two columns with values (city and county) and i've got a lookup sheet where the value of the state - Say Michigan (or MI) is 45 for example and the county is 13. I'm inputting MI in to the cell but would like for it to somehow reflect 45. I'm wondering if i...

I have the following worksheet that I need to transpose according to the number of occurrence in a column (same name etc) within a specific column (B1) and copy the entire column and its row content on to one new row below. The 2nd occurrence of the same name should start on Column Q in this...