macro - formula

=COUNTIF('05-23'!$B$1:$B$5566,"d*total") =COUNTIFS('05-23'!$B$1:$B$4935,"D*total",'05-23'!$P$1:$P$4935,0) =VLOOKUP("Grand Total",'05-23'!$B:$N,9,0) =VLOOKUP("Grand Total",'05-23'!$B:$N,13,0) These are the formulas I copy from left column. After i copy, I want to change the lookup tab to the new...

Hi Everyone, Am wondering if someone could do a macro on this to help me to speed up the process. I do following steps when I receive new address sheet to match with old. Old-Data sheet1 Select Colum H [ Phone1 ] Ctrl+F [Find & Replace] [ - ],[ + ],[space],[ . ] (Removing symbols and spaces...

Hello, I want to record a VBA that uses =index,(match),0)) formula into the same cell for multiple excel files. The files will be in .XLSX format and will =index,(match),0)) against a separate excel file. I want this function to work for a folder path containing multiple files Please let me...

Hi I need random record to be selected from a group of categories in column. Eg- from the table below- I need two names randomly highlighted, from each city type. i.e two randomly selected names from NYC, seattle, toronto and california each. <tbody> Name Class city ABC 1 NYC DEF 2...

Hi Guys, Can you possibly help me clean up below codes? The range of cells with data is from A:AD 1. Basically starting in AG5, I will create a sum formula from E5:T5 which will be copied down to the last non blank cell (not just till range 681). 2. The macro will hardcode the sum column and...

i have three columns : department id, names , holiday hours > 10 different department id >n number for names and at the end has a 'total' > holiday hours need to be put in the same row as the total of the department what i need help for? i need a macro in which it looks for the department id...

Hello Fellow Mr. Excel Users, Thank you in advance for any assistance or guidance you can offer. I am using Excel 2019 on the Office 365 platform. I have a master excel file that I would like broken out to separate workbooks, each containing specific worksheets, based on the data contained in...

Hello, I'm a strong excel user with no coding skills. I have recorded a Macro that takes raw data and creates a table then creates a Pivot Table. I am getting an error that I can't explain. Run-time error '1004': Application-defined or object-defined error When I select "Debug" it highlights...

Hello, I am trying to find a macro or a formula that will delete out interdependent dropdowns. I am a macro noob so thanks in advance for your patience. Right now, I have a sheet that is set up using the indirect formula via data validation to allow the user to select various dropdowns. For...

Hey guys keep getting an error msg of object variable or with block variable not set..excel highlighted the string of code that may be giving me the issue I a completely stumped need help! the code is below..any help is appreciated Sub Macro5() ' ' Macro5 Macro ' ' Keyboard Shortcut: Ctrl+e '...

I am trying to compare two file. I receive a file once a week. And I need to compare last week’s file to this week’s file. I have them both in the same file on two different tabs. One called Old and the other is called New. I need to look at these two file and see where the Location has...

Hi Guys, I have 2 workbooks on my deck namely Project (source file) and Reference (vlookup reference file). In Project workbook, I need to look for the Value of F in Reference Sheet column B and populate it in G column. Project Workbook: I was able to populate the data in column G using...

I need to write a macro. I have two tabs each tab has the same type of rows they are just from different dates. I need to look a Sheet A at column C and compare it to Sheet B column C and find the ones that match. If both column C match I need to look a column B for that row and see if they...

Hi Folks, I was given an excel sheet today that contained data that was missing a few fields. Sheet1 <tbody> Column1 Column2 Column3 Column4 Column5 Column6 Unique Key1 Data4 Address City State Zip Unique Key2 Data5 Data8 Data11 Data14 Data17 Unique Key2 Data6 Data9 Data12 Data15...

Hi I have an excel sheet showing the SKU and image URL i need a way to export these to a folder on my desktop (New Folder) i understand there is a way of doing this with a macro and the ones i have found i can't seem to get to work. The excel sheet is Column A | Column B SKU | ImageURL...

Hello Folks, I'm new to this community and to Excel coding. Need some urgent help. I'm trying to show specific row based on a drop-down list. Below are the methods I've tried so far but no luck, really appreciate if someone can help! Code 1: Giving Error - Compile Error - Syntax Error...

Hi All, this is a most excellent forum with a wealth of information and a wonderful user base! I have learned a lot from this forum, and see many thoughtful answers. I have a macro which I need help with, I'm attempting to display a list of RGB codes to the recent colors section within excel...

Hello I'm trying to create a vlook up macro so I won't look up for each diifferent tabs as you may see below. 1. Master Worksheet 2. Reference Worksheet 3 Tab sheets namely - Sheet 1, Sheet 2 & Sheet 3 Master Worksheet - Master Tab <tbody> ID Name Age Subject Score 001 002...

I am hoping someone can help me. I am creating a form in excel using the active x combo drop down option. I am trying to hide rows based on the option they pick. I added the active combo box in cell B3 with options A, B, and C. Based on what they pick I need the following to happen... If...

I have a userform open and my Application.visible = False on start up, i want to add a macro that will Application.visible = True with assigned shortcut Ctrl+Shift+Z it currently does not work and have ran out of ideas, any help is appreciated?