excel & macro

I'm extremely new to Excel and Macros and struggling here with this requirement. I have a column having country names. The names in this column could be a single country or a list of countries separated by a semicolon. I want to write a macro which will look at the value in this first column...

I have multiple tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my "critical numbers spread-sheet" with wanted numbers per application identified in each tab but columns and rows are inconsistent. I have...

Hi! I'm rather new to excel and I'm trying to make a new workbook that automatically timestamps when a button is pressed. I've learned out to insert a button as well as the basic macro for what I'd like but I'm looking for a way to insert multiple buttons with a macro that works almost like when...

Hi guys, I am very new to this and I would much appreciate any assistance. I have two workbooks from two different software. Both Workbooks have similar headings but we want to replace one line in Workbook2 with more than one line in Workbook1. There are multiple headings, and I am wondering...

Hi everyone. Hope you all are doing well. I've been struggling with a macro update for a while now. I'm trying to count cell values ONLY when the column name is like Math, Science, or History. The issue is that the code is somewhat static. If a Math, History, or Science column is deleted, it...

Hello, I am new to VBA and my knowledge is limited. I will try my best to provide an accurate description, but if additional clarification is needed please reach out. I am trying to create a VBA to accomplish the following: I need to replicate a Master worksheet based on the number of rows from...

Hi Everyone, I need some help in my macro. Currently I have a code that will change the date format to yyyy-mm-dd, but what I want to also happen is to change it on Short date. Here's my attempt: If you can see on the SS, the highlighted yellow is what is showing on the filter but what I want is...

Hello all, I am looking for a VBA code to reconcile two data sets in Sheet1 and Sheet2 (See attached report). Looking for qty differences between both sheets and identifying if a column A, B or C and have any discrepancies. Can anyone help? Thank you in advance!

I keep getting an error message every time I try to test the macro, after assigning it to a cell in my excel file. This is what the error says: Run-Time Error '380' "Could not set the RowSource property. Invalid Property Value." I've included a screenshot of this message and a copy of my...

Hi all, i am currently trying to save my workbook at the end of my script into a one drive location. i have created a file so when it saves it also replaces. Currently it doesn't attempt to save. Please see my below code. (p.s i am very new to all of this)

Hello. I am trying to write a macro to do the following. I have a list of values that I would like to find on each tab and remove the entire row of data. Please reference the attachment. Hopefully that will help. Unfortunately my real example ...the tabs will be randomly named with over 100+...

I have a column that uses VLOOKUP to bring in values from another sheet. I would like to save the precious value of any cell in this column to the corresponding cell in the next column whenever the cell value has changed. Example: Current values: Cell A1=1, A2=2 If VLOOKUP brings a different...

Hi, I have looked around the net, but I can't find a clear answer for the following. also a linked to excel is attached at the bottom I would like a VBA code that can fill up the cells, and continues filling not start from the begging so it is based on the current date for example if the...

Hi everyone, I have copied and pasted as link (worksheet object) from excel to powerpoint, but now that i shifted the excel to another location (e.g. from Documents to Desktop), the file source path has changed. Is there any way to change all the links at once rather than clicking each link >...

Hello, Every time I data is entered I would have to scroll all the way down to see the results in a userform. Is there a way that every time the value is saved to have the scrollbars go all the way down automatically? Like to show the last row.

I have a spread sheet with "Property IDs" that each have multiple "rooms" assigned to them. I need to change the "Room Name" in a seperate column based on how many times the Property ID has been Listed. Example: I need this: To be this: The reason I am looking for a macro or formula is...

Hi Guys, I have an excel speradsheet with 22 coulunms and about 1000 rows and growing with lots of macros in it. There is an ADD command button on the main sheet that opens up a VBA scripted table that have drop downs to select data to add to the next row with another ADD DATA button in it. This...

Excel Macro to print pdf file to location based on cell value and file name based on cell value This is the VBA that works, saves the file names based on cell ("Q24") value, but will not place the file to the correct folder, Cell "Q25" has a formula...

I have a excel 2016 file with 13 tables on a sheet. The formulas in the 12 last tables are depended to the first table. Now I'm trying to create a macro to add a number of rows to all tables at once. I got this to work, but it is not starting with the first table. this creates a "gap" in the...

Hallo, I'm an admin and VBA newbie, trying to send automated reminder emails from Excel 2010 via Outlook, three months before the review date (in Column C). I've managed to send an email from Excel :) But can't get any further, have tried the YouTube videos but am baffled and was advised to try...