#excel

The code finds a match for the each cells in Sheet2_Column_1 from Sheet1_Column_1....If a match is found then replace the range in Sheet2_Columns_1 to 5 with Sheet1_Columns_7 to 11. The blow code only replaces the cell data in Sheet2_Column_1 with Sheet1_Column_7 when the match is found. Is...

Hi! I'm having trouble writing out the syntax for a VBA code that compares two workbooks. I have the logic figured out, I'm just not sure how I'm suppose to write it. The Logic goes as follows: if classification is equal to "fruit" then check group number if group number is equal to "1" then...

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???

I am working with a database and right now I am manually inputting the name along with a specific number value. However some names have multiple number values that are different, right now I am having it where if the person has multiple number values I am placing them in a different row. This is...

Hello, I'm trying to automate a Boolean process on Excel and was hoping to get some help with the loop/vba logic. Column A contains integers that range between 1-4. I would like to create 4 columns on the side (since "A" contains 4 possible values) which have the following logic: If...

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

I am looking for a way where I could consolidate inputs from multiple user (with different network and environment) to one excel file (Database) stored on the cloud. Is this possible with VBA?

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...

Requirements before closing the file: Protect all sheets Hide all sheets except sheet name "Permissions" Replace the file without prompt along with password to open the file (Same file name, Same file path) The below code does not work as required. Not sure where I am going wrong. Private...

I am looking for a code which adds PASSWORD TO OPEN FILE in the current workbook before closing it. This will help if the user has removed the protection by applying the password automatically before closing it.

Hi, I have a table with 45 members and let's say 100 columns. Each column is a date and members will have a negative figure within the cell referencing their name and the date if they have a holiday. (EG John Smith is off on 12th June so he would be -8 in cell H22). I want to be able to...

# HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....

Hi I have a very badly design report where there's a lot of duplicate data in many rows. (sadly, the IT has not consult me before they launch the system) T-T Basically, I'm working on employee's development plan where one person has more than one row of action plan. I need to combine the data...

The below code works completely fine. I just want the code to retain the source formatting. For example: my source data also contains numbers which are stored as text, however the below code coverts them into numbers in the output. I don't want the code to convert them instead retain the source...

Hi, I have seen this code here: Postcode finder in Excel and caculate the distance between two postcodes I would like to understand how could I add my API key to it. How could I add my API key on the code below? Thank you for your help.

# How to Find particular text in Date ?????? i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"

Hello guys! I want to write a macro to receive data from the 'Transaction' sheet and gives me an 'Inventory' sheet but I don't know how to do it (the 'Transaction' sheet may contain many shares so the macro should count them all and if we sell a share that we don't have in the first...

Hello, How can you auto higlight selected field on userform? So basicly I need this line to be highlighted (Me.lstDatabase.TopIndex = Me.lstDatabase.ListCount - 1) ListBox1.BackColor = RGB(153, 153, 255) ??????

I was try refresh but not show data in pivot table, how to update data ...???

Hide Row with Zero value with Entry