vba

Hi there, I'm having trouble trying to find a way to populate a spreadsheet with data from an external source. Ideally what I'd like to do, is simply "select all" on a browser window that contains report card style information, and then paste it into a blank section of my excel sheet. What will...

Hi, Please I need excel to repeat text in a cell 2x That is REPT(text, 2) IF the text is not repeated, but if it is already repeated 2x, it should not and leave it that way. =IF(B2=REPT(B2,1), B2=REPT(B2,2), B2=B2) It gives me False, then 0 gives me true. Excel formula or VBA would be...

Hello all, I am trying to format series' line color on a graph. However, when I try to reference the names of the series to format the line color I am getting stuck because the names contain a reference to a cell value on that specific sheet. Each SN (serial number) is on a separate sheet in...

I have a macro which works the way i want it to except for this part.. Set rng = ws.UsedRange.Columns(1) .Cells(r, "H") = rng.SpecialCells(xlCellTypeVisible).Count it returns y, instead of x in (x of y records found) this happens after autofiltering with vba.

Hi there I am looking for help on writing some VBA code for the following. I have an entire data tab (titled "paste 1804") I need copied into 2 different tabs with same format, content, etc..: I have Macro push button labeled "Run data Macro", on a tab labeled "Marcos" Source tab to copy...

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

Hi Have a VBA code that loops (Through multiple files) and deletes certain cells but I want to add in a addition to the already named file name. I basically need a code to add into the current one and a code that will just add either numbers or letters to the end of the file name. This is the...

I'm trying to declare a Module level Constant (below). Why does it error? Public Const ps As String = Application.PathSeparator

Hi All, first time posting currently as part of my job I create an excel with many tabs... sometimes as many as 150. I have several questions. Firstly, the tab structure is such that the first 8-10 (this can vary) tabs have specific names from there the sub sequence tabs then follow a...

Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...

Hi all, long time lurker first time poster. I am somewhat of a VBA newbie and am trying to write a script to assign values from one of my workbooks to a template workbook, however the data in the source file is non contiguous. The below script does not cause an error. however the data from the...

I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the...

Hello, I am trying to copy values from Columns R, W, X and Z from the Template (red pic) into columns A, B, C, D. I need a VBA to go through these columns until there is a blank row and then paste it into A,B,C as so it creates a nice list going down. I will need this code to continue multiple...

Any all all help is appreciated! I’m operating out of a company SharePoint, as multiple people need to be able to access these sheets. I want to have a Master sheet, that tracks information from ~300 individual site portfolios. I want the Master sheet to be able to automatically pull about 30+...

Hi there, first time post here so i apologize in advance. I have looked everywhere for VBA code to help me with this task but can't seem to find what i need. I have a large table of engineers stock count which i add to once a month when we run our stock reports, the table grows by two columns...

Dear Mr Excel, I have a huge spreadsheet that downloads from our data system with staff initials. I need to add all the actual names onto this (firstname, surname), is there a VBA code that I could use to assist with ease? I would be very grateful if someone could assist me with this. Please let...

Hi all, I have an excel workbook called Bill of Materials (BOM), which contains a lot of macros and I have always had buttons call certain macros. My BOM excel sheet basically uses power query to organize data sourced from a workbook called Masterlist and throws it on a new sheet (on the BOM...

Hello, I know there's a way of doing it, but I'm failing continually. I have this wonderful VBA that works brilliantly when the sheet is unprotected: Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents =...

I have a workbook with a connection. I have gone to connection properties and set it to refresh periodically in the background. But I don’t know if it saves the document after the refresh. I don’t think so because the time of last modification of document doesn’t change. So I’m trying to...

Not strictly Excel, but I guess you folks know VBA. At work, I receive steel test certificates by email, and want to automate saving them onto my PC into folders based on the subject of the email, it uses a rule in Outlook to identify the email, then this code to save the attachement(s). At...