automate excel

Hi, Let say I have a list of keywords to search in Excel like below (more than 20) Milk,Apple,Meat,Money, Phone,Parking , Car,TV,Sign,Laptop (...) If I find a cell with one of this keyword I need to highlight the column where its belong too. Sometimes one column can have multiple keywords...

I am currently trying to construct a table of raw materials that will automatically adjust based on information entered about productions. The system currently consists of 3 excel sheets: 1. A general ledge of all finished product stock in and out. This consists of columns for date, product...

Hi all, i have an excel column of 4000 rows that contains internet website and i want to know if this internet website have inside them relations with their facebook, twitter or linkedin page. Is that possible? and if it were possible how can i automate the compilation of another three...

Hi everyone i need to built a VBA code to extract data from the sap and add those data into the excel file. I need to extract data based on the product number, Can anyone help me out how to do that. Thanks in advance

Hello! I just signed up and this place looks like heaven to me right now after hours of sweating and crying over this spreadsheet. I have data for thousands of people. The people all have a name, listed in column A. Then in column B is the date at which they logged their weight on an app. In...

Thank you in advance for any suggestions. I have tried looking up SOLVER, GOAL SEEK, and most recently KNAPSACK. I'm not sure what is best., or if it is possible. There are 3 types: BASIC, SMART, and DEVICE In this particular group there are 17 BASICs 48 SMARTs 22 DEVICEs Now here's the...

I have a workbook which includes a master list of needed bike repairs. It's intended to be "evergreen", with no more than about 20 pending repairs in the queue at any given time. So, as repairs are completed, the Repair # (or row) can be "recycled", and used for a new/ incoming repair. I also...

Hi Everyone, I am looking to select a column with numerous 4 digit numbers in it and have any of those numbers in the column be automatically highlighted or font color changed in multiple worksheets. Example: worksheet 1 4 Digits need to found in all other worksheets 5496 4526 9600 1234...

I'm relatively new at VBA, and I am developing this excel based tool that creates two .xls files, whose paths are saved in two variables. The next step is the user has to select these two files, right click and select an application called Compare. I was wondering if this process could be...

I have created a spreadsheet to do the following... Upon entering a valid date in cell C1, VBA runs the code for R2D2. The code I used for this is: If Target.Address = "$C$1" Then Application.Run "R2D2" This works fine except the spreadsheet will also run if the cell is blank and you...