macro

It's been awhile since I've created this macro and I'm having trouble. I have a workbook "Sales" with a worksheet "Names" that has 100 names starting in cell A1. I want to copy the name in A1, paste into a new workbook (it updates a bunch of figures), and save that workbook under that name. I...

Hello everyone! I was working in a macro where it will insert for me pictures from my C drive, however, I need to exchange the code to insert the same pictures from a workspace or SharePoint or website. I have tried but I was not success. please I need your help. this is the image address"...

Hiya I've been using a VBA from this: VBA to List all Folders, Subfolders and files in a directory Option Explicit Public Sub Main_List_Folders_and_Files() With ActiveSheet .Cells.Clear List_Folders_and_Files "C:\list", .Range("A1") End With End Sub Private...

I am trying to run a macro calling the Solver functions on multiple sheets. The Solver area works on a single sheet, but returns the error message on the 5 worksheets I am attempting to calculate. Any advice is most welcome. Also, running this macro switched calculation mode to Manual. I have...

Hello, my name is Andrian I would like to have a Search Macro box to click to find text from specific cell. I had a macro just to find the text. (CTRL + F) it works just fine, but i need to have the macro highlight the text/cell from the text found from searching the text. because workers here...

Hi everyone, I have a password protected spreadsheet that I can easily group and ungroup while it is protected. I am wanting to create a button to easily do a bulk group and ungroup while the sheet is protected. I am happy to have 2 buttons (1. Group, 2. Ungroup) instead of just 1. Is this...

I'm currently trying to set up an automated email system. The system is supposed to go down a list of email addresses and email every customer. The code I have so far in vba is: Sub Email() Dim EmailSubject As String Dim SendTo As String Dim EmailBody As String Dim ccTo As String EmailSubject =...

I am a relative beginner to VBA and am a bit over my head on this problem. Not sure anyone will be able to help with this, but I suppose typing my thoughts out might help me to wrap my own brain around exactly what I need to do in any case. The Problem I have a large worksheet of data in one...

I have a long list of strings in a1 but I want to extract the numbers from the strings. Additionally some of the strings have special character aside from just the alphabet that I also want to remove. Is there a macro that exists that will delete the entire uppercase and lowercase alphabet from...

guys i made a macro in excel i want to copy the table when i run this macro the table area duplicating itself please help me, thanks Sub screenshot() Dim w As Worksheet Range("D1:F7").Select Selection.Copy Range("C4").Select ActiveSheet.Pictures.Paste.Select 'when i remove this...

I just started working with an agency that provides a variety of resources to community members in need. They have a lot of information spread out over various documents and l'm trying to make finding and providing the needed info as easy as possible. know this is asking for a lot, but this...

Hello all, I'm relatively new to coding, and a lot of it kind of goes over my head so I apologize if I don't understand right away, and I also apologize if I don't make much sense trying to explain what my goal is. I've set up some macros for my work, and they work relatively fine - however...

Hi all, I'm fairly new to VBA beyond a little tinkering here and there. I'd like to import multiple text files into a new workbook with each file on a new sheet. I found this code on another thread but this seems to be coded to import the sheets into the current workbook. I've tried changing...

Hello In C1 i'd like to be able to type a name and when the search button is clicked, excel performs the search function. I've tried recording a macro for this but it keeps going to an incorrect cell. Is someone able to help with VB that I can assign to the button? Many Thanks

Hello all, I need help with a macro to move rows/cells, similar to deleting a row and shifting everything up, but not, because there is important content outside of the table that should remain static. So, to clarify: The area I'm speaking of is from D4 to F15 only. Within this area, if...

Hi all, My skill in translating logic into a formula and especially VBA is very limited. Hopefully the below makes sense. Basically I was hoping for a VBA code that pulls through results on to a new sheet by using the reference column A (Order Ref) in Sheet 2 and comparing columns of the...

I have the following macro: Sub FilterByDate() Dim targetDate As Date Dim wsDashboard As Worksheet Dim wsShippingQ As Worksheet Dim tbl As ListObject Dim colNum As Integer 'Define the worksheets Set wsDashboard = ThisWorkbook.Worksheets("Dashboard_Today") Set...

Hello, Would anyone know how to make this bit of the code work ? I use a Mac and this is to save a file as pdf in a folder in google drive... When I run the code, there is an error message "Run-time error '-2147221014(800401es): Cannot open the specified file." And the debug highlights...

Hi all, I have the below code, currently I have hard coded the email to address but I have a list on a "Variables" tab, range J2:K10 (also below) with where the report should go. Rather than updating the code, I was wondering if I could lookup to this list and return the right to person...

Hi everyone, Can anyone give me a hand with a macro that will run and copy the results generated on one sheet onto another sheet as values? xl2bb sheets below to illustrate if helpful I need it to... Enter a “1” into cell D108 on “OnOff” sheet Refresh entire workbook Copy and paste *as values*...