excel & macro

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 iam looking for a way to open .xlsb files in a folder one by one and then rename or update its links as .xlsb. For example if "C:\FINAL ANSWER\edit.xlsb" file has links as ='C:\FINAL ANSWER\MAIN VALUES.xlsx!L30' then the code should be able to rename that link as ='C:\FINAL ANSWER\MAIN...

I have a data table (B:E) with values that looks something like this: <tbody> ID DATA 48 5 7 10 47 4 3 46 6 11 21 30 45 44 1 8 43 1 2 3 5 42 2 5 6 41 12 13 etc </tbody> So the data table may have a maximum of 4 values. Some rows...

Good Morning, I have an excel workbook that has multiple tabs. Here is what I am trying to accomplish: 1. I would like a macro to save the current active sheet by its worksheet tab name: Some_Active_Sheet_Name2 or Some_Active_Sheet_Name3 or Some_Active_Sheet_Name4 2. I would like to...

Hi Everyone, I am new to this forum and specially subscribed to get my query resolved. I have a system from where I download the report which is not in good format. Also the data is dynamic it keeps on increasing and decreasing I always have to copy it to a new workbook and format. Since this...

I have multiple excel workbook files with the same format, like column A1:A2-" payer id " column B1:B2-"payer name" column C1:D1-"payments" column C2-cash payment column D2-Credit payment. Each excel workbook gives different month payers & their payments. and the payers also repeated in the...

Good day friends! I have a large worksheet that I need to filter column B and email the filtered results to a specific contact based on the cell value. For example Column B: Banana Orange Strawberry Orange Strawberry Banana With all results with "Banana" in column B, email rows A:J to...

Hello, I am trying to generate a macro to select a particular name from a dropdown list. i tried using the record macro function, but the result was just a range.select Is this possible? Thanks in advance

hi Friends, please help i am not very much familiar with VBA Need help with the below code this is being used for Random Sample picking tool, Currently set to pick 10 accounts for evry users, now i need to pick 10% of Users productivity, the higjlighted part shows slecting 10 and from...

Since I am very new to the excel macro I am trying to develop a code which is able to open the PDF file.But There are some PDF files in my system which are generated by another system therefore those files names change day by day and some figures are included too. As an example,"Process Report...

Hi Guys, Can you possibly help me on this? I'm trying to create a macro wherein in Column A, I need to look for these words Football, Basketball & Tennis and will replace as Sports. In column A as well, I need to look for Math and Science and replace as Subject. I have below codes for the...

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

it keeps ignoring the last condition... If zz Like Left(Replace(activ_code, 0, "?"), Len(Replace(activ_code, 0, "?")) - 1) & "1" _ And Left(zz, Len(zz) - 1) <> Left(activ_code, Len(activ_code) - 1) _ And...

Hello folks, I am not an expert at excel, so not sure how to resolve this issue. I have two excel worksheets: File 1: Subset: This file has a subset of employees with various details including training status such as in-progress, completed, etc. File 2: Full-Pop: This file has a complete...

Hi everyone, I am working on a project that requires me to expand the acronym in column A of excel and copy the expanded term to column B. The acronyms i am working on mainly revolves around the engineering mechanical side. An example would be: Column A Column B AHU-L8-01...

Hello, just hoping to get some help with this. I’ve two words that have different values associated with them, I just want to findthe words and copy the values from the adjacent cells into separate cells for example Cell R43, R45, R47 etc for the value associated with Wait and a separate cell...

Hi All, so i have probably a common question but i cannot figure it out. I am trying to move a whole row based on what is entered in column F. so if i enter "Yes" in column F the whole row should move to Sheet6 finding the next available line in the table. i have the code below that moves...

i'm New VBA and Marcos and am hoping someone can help. I have workbook with 50 plus sheets and I am trying to create a Macro that will copy the same range of cells on all sheets that have "Box" in the in the name and copy it to a Master Sheet in the same workbook with the originating sheet...

Hi All, I'm new to this blog, so I hope I follow the rules correctly. Thanks for accepting me. I need help setting up a macro/VBA to copy a specific column (G) range "G1:G550", which contains data in some cells and formulas in the others others. The column needs to be copied to the next 50...

Hi Guys, I need to copy and paste data from multiple workbooks and multiple sheets. (name keeps changing of worksheets as well as workbook) I have a code but here I need to manually select the cells. I just want to select the sheet and it should automatically import the entire data in the...