macros

I have had a search online but haven't been able to find something specific to what I need. The main Wb "Dataset" stores the raw data sample (around 5k lines). Each of them belongs to teams and I only have use for 12 of them I.e. "Team 1" & "Team 2" etc. The sheet includes 7 colours, all of...

Hello, I can see the advantages for an excel table, i've tried it before, but all the articles give always examples that belong to the mathematics and statistics not to an address list, or text containing list... when i try to convert to a table i immediately see that my macros dont work...

I have folders set up by manufacturer name and in those folders are there monthly invoices that are billed to them. I want a macro to be able email all invoices in each individual MFG folder to the respective MFG. Is there a way to set up a macro that can do this and possibly prompt me to...

I was able to find and write code which hides all specified columns for a report at work that I am slowly trying to automate. The report in question has 20 or so columns and I only really need 8 from the report. I can easily use the code to write 12 or so lines to hide them. However it seems...

Hey, I'm looking to create a table with pre-determined sentences in, so that all I need to do is add a person's name in the middle cell, and hit copy on a command button, and I will have copied the multiple cells, to be able to copy as one sentence in another program elsewhere. I have found a...

I am running Excel 2003. I have 16 Macros that I have created for one of my projects. They do remain from session to session. I have assigned each Macro to a toolbar button. However, the Macros do not remain assigned to the buttons after I have closed a session of Excel 2003. The next session I...

Good afternoon all, I have created a simple macro that creates an email, and all of a sudden it has stopped working? Any ideas as to why it would just stop working?

Hy Excel Experts, Is it possible to automate print and save using macros, like I have a list of URLs in Column A and a list of its file name to be saved in Column B, I want to go to each URL and save the pdf in it to a specific directory. Hope it's possible because there are 100+ pdfs every...

Hi everyone! I am relatively new to using macros and have been having some trouble using macros to compile data into a new excel sheet. My goal is to have a sheet that looks as follows: Item Name Measured Value Source File Name A X Patient1.xls B X Patient1.xls C X Patient1.xls A X...

Hi, this is such a strange one I had to post a thread (not something I've done before, so forgive me if I make any errors). All our users are on Office365 (installed locally, not the web version). Most users are on Win 10. My boss has a macro-enabled template that is used by multiple staff...

Hi Everyone, I am new to Macros ,I need to do Vlookup for the column S from First sheet with Column M in another sheet by adding Extra column after S in the First sheet and if i get N/A in any rows after doing Vlookup i need to move those N/A rows to Third sheet and remove those from first...

Hi I wanna create a workbook containing all the macros I am likely to need. I will have a table already downloaded and the first macro I wanna create involves adding additional columns from AU with these headings Postcode ID_for_db Firstname_for_db Lastname_for_db Postcode_for_db...

Hi everyone! I hope you're all doing great Could you please help me with this? I need a macros that helps me move from tab 1 (OPEN REQUESTS) to tab 2 (COMPLETED REQUESTS) the records that have a date under the Completed Date column, but I need these records to be automatically removed from...

I need to be able to insert the formula to copy a cell in 'sheet 1' to sheet 2 with skipping rows. I have to take A1on 'sheet 1' and copy it to A1 on 'sheet 2'. That's the easy part I need to now take A2 on sheet 1 and I have copy it to A19 on 'sheet 2'. I have to basically I have to take...

Hello! I am quite new to Excel Macros/VBA and I could use some help with this problem I'm facing: Year Week # Doughnuts Shop 2020 1 34 Krispy Kreme 2021 25 23 Dunkin Doughnuts 2021 3 34 Crosstown Doughnuts 2020 32 354 Dunn's Bakery 2020 51 98 Bread Ahead Bakery...

I do a LOT of scheduling people at my job. Kronos spits a nasty excel sheet with 1000's of rows and about 40 columns. I've got created enough macros to where it fine tunes it to what you see below BUT I would like to do a few more things to really make it so I can print these schedules for staff...

Hi guys, I am getting an error of "Expected =" when trying to clear a range. My code is: ThisWorkbook.Worksheets("Ind Output").Range(IO.Offset(2, -1).Address(0, 0), Range(IO.Offset(2, -1).Address(0, 0)).End(xlDown).End(xlToRight)).ClearContents But the following section is returning this...

I have a large data set that I need to filter for category and use. That is to say, filter column D and then filter column E. D is the category and E is the use. Category A has 3 uses, Category B has 4 uses, Category C has 17 uses and Category D has 4 uses. I filter by category then individually...

Hi, Can someone help me with the below requirement. I have data as below in the sheet1 of workbook1. Team RegionEmployee NameCurrent ManagerTS/GS26-Jul27-Jul28-Jul29-Jul30-Jul31-Jul01-Aug02-Aug03-Aug04-Aug05-Aug06-Aug07-Aug08-Aug09-Aug10-Aug11-Aug12-Aug13-AugCXYrYvYnYn XhYnmugYmCHYrXh...