macros

Hi. Probably a macro beginners question. Apologies and thanks in advance. So everyday I download "report A", the cells range are different because things get bought/sold. Ex: A3:L900 and the next day is A3:L1000. *Simple example: Day 1: Macro starts recording on a sheet with data range A3:L900 -...

Hi! Looking for some help with macros. I've never used them before. Basically, I need a list of employees (Index Worksheet) to be split on two separate worksheets (IndexDriver worksheet, IndexLaborer worksheet). I have the code to complete this task, but I need it to not duplicate these rows...

Hello all, I am trying to automate a task that I regularly have to do at work however I don't have much experience using VBA/Macros so I was hoping someone could help? I will try my best to explain what I want to do in words but I have also got a mini sheet below which should make it a lot...

Hi all, I was wondering if you could help me with this problem I have (I include an image for reference), I am trying to clean and sort a list of products that gives me a system that I can not change. What I am trying to do is to copy the value enclosed in red (product group mark) from the...

Hi am new to VBA, Could you please help on the below code. I have 2 workbooks and i want to copy the columns from one to another with the matching header. It shows an error in the following line as (Runtime Error - 1004 --> Application-defined or object Defined error)...

Hello, can anyone please help me to write a code which delete all the rows if Column AM in sheet "Sponsored Products Campaigns" has text as same as in sheet "Control Panel" Cell S7, so for example it will search the text from Cell S7 Sheet "Control Panel" in the Column AM sheet "Sponsored...

I have a workbook that serves as a database with an Input page. I want to make Column A dynamic, which will update header rows on all pages of the worksheet. I have created a macro that copies these header names from Column A on the Input Sheet, and pastes these values as headers on the next...

I have a simple Double Click macro that works elsewhere but in this particular workbook nothing happens. I double click into the cell and it just goes to edit mode, no macro runs. EnableEvents is True and the only other thing I can think of is it has something to do with both sheets being SQL...

Hi, Im trying to see if its possible to build a macro with the scenario mentioned below: We have 3 people (Person A, B, and C). All have different set of apples that are each uniquely barcoded that need to be evenly distributed into 6 baskets. When it comes to uneven numbers divisible by 6...

Hi, so I need to delete the complete row if specific criteria is met, the criteria is as follows, In a sheet named called "Data" If column B contains either of "John", "David", "Susan", "Macro", few of them, or all of them, then delete those specific rows leaving the others (Note: If any of...

I have a worksheet with a number of macros. some of them allow me to run them or edit them. but some dont have that option. thes are saved to the individual workbook. Basically when I pull up my ist of macros, I can run some but not others. Pleas help me understand why some of these are...

Hi- I have a xlsm workbook that two nights in a row the macros disappear. They even disappeared from the files that I archived as a backup ( also xlsm files). I checked that macro is enabled and I checked that there were no disabled add-ins. I have never had this happen before. Any suggestions...

Hi, I developed an ETL tool called EtransL and have placed it on Github. How can contributors who might want to join the development effort submit code changes if it is embedded inside an Excel as a macro? Thanks

Hi , I have multiple workbooks with 100's to 200's sheets in which I want to count number of entries of A2:A10000 range has, if the cell C2:C10000 has some value then only count should be considered else Not to be considered. This value should be stored in V2 cell of each sheet Similarly, I...

Hi All, I have been given a data set in Excel which is consist of 20k+ rows. The data is for the past six months' SLA for 3000+ processes. Within the last 3 months, I need to identify the processes which have failed to meet their SLAs. Based on the below, the raw with the latest month needs to...

I have a form where information is being from a form is being added to a sheet "Database". How can I add to the current VBA and have the the same information added to the "Database" sheet on the Active workbook and another workbook "WF Manager-Database.xlsm Sheet "Activity Database". Code below...

Hello Everyone, Was wondering if anyone has ever had this problem, it looks like it's a problem with Excel 2016 in this PC specifically. I've made a Macros for sorting data from a CSV File, and put it in a normal Worksheet. I created the Macros in Excel 2013, on a PC at work. This PC has as...

Running Windows 10 & Office 2010. 1. Most of my Excel workbooks work fine...when no macros used. 2. My "budget" workbook has slow performance & freeze issues...it uses macros. 3. Some/most slowness is due to many imbedded, conditional formulas in 12 sheets. 4. Open & close workbook is slow. 5...

Hello, can somone help me to run this userform menu to start on 32 and on 64 bit (excel vba). I try with convert but I wrong and dont know where. Can you give me advaice what I change? Thank you menu maker

Hi everyone. I'm new to VBA. I have task to do. I have 3 sheets in an workbook. Sheet1,Sheet2 and output. Sheet1 and Sheet2 consits 67 and 65 columns respectively. Only few columns are common. I have created a unique column in both sheets using concatenate formula which we have to use to fetch...