macros

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...

Hello, I wanted to see if it is possible to create either a button or a drop down that can take me to a section on an excel sheet. I have 10 sections that are the same but can take different values in the section The title "Section 1" is on C12 then the next section is c78 and so on meaning...

I have a code to copy paste entire row which met condition, but how to copy not entire row, but specific cells from that rows? For example just A, C and D cells from row. Sub CopyRow_Item() Application.ScreenUpdating = False Dim LastRow As Long Dim last_row As Long Item =...

Hello everyone. I am using a macro to consolidate two files and have the information referenced between two sheets, but when the macro is supposed to paste a formula {=IFERROR(VLOOKUP(B6,GTN!A:C,2,FALSE),""}, what I end up getting is a different one {=IFERROR(VLOOKUP('B6',GTN!A:M:M,2,FALSE),"")}...

Hi, I'd like to use excel vba to loop through values in a column and get hyperlinks that are associated with each of those values from another sheet using Vlookup and use the original values in the column as the friendly name. Is this possible? I've tried the below code but only get Run-time...

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...