vba &

Hi, I have a sheet in a workbook that displays results based on a drop-down list in that sheet. For example, if you choose "Site 1" from the list it will show the data pertaining to "Site 1" in that sheet. There are about 100 different options (100 different Sites) in the drop-down list. I am...

Hello Gurus, I'm currently have below code DATA 1 Sheet: ITEM 1 ITEM 2 ITEM 3 ITEM 4 DATA 4 001 002 003 Note: In cell E1, that is the Sheet where the data should be look up. Usually, manually filled as there are too many data sheet tabs. In the code below, it...

Hi, I have a question that I would like to ask you my good friends Is it possible to display a help text when the mouse pointer is placed on the button?

Hello. I have 1100 part numbers in column A, against that in Column B we have some data that has been entered on separate lines within the cell Part Number Origial Part 1 Audi (A3 A4) BMW (5 6 7) Volvo (V50 S40) Mercedes (C S) BMW (5 6 7) Volvo (V50 S40) Part 2 Mercedes (C S) BMW (5 6...

Hello, I was wondering if there is it possible to Link an IF condition with a cell color instead of a specific data using VBA. For example: A range of cells B4:B20 have data lets say numbers. some of those cells will change color to blue. for the sake of the example lets say B7 changed color...

Help needed... I have 34 activex command buttons on the worksheet all named "Bridge_cmdbutton1" and so on until "Bridge_cmdbutton34". My code generates a random number (stored as "randomnumber") between 1 and 34, but what I can't do is make the code recognise the command button that corresponds...

Hi Guys, I have reviewing many blogs and websites to see if there is a way to select the data inlcuding if users leave blank rows in the middle of them. My code is not taking the rest of the rows with data since one row is empty. Example: From row 1 to row 3 have data, row 4 is empty and row...

anyone help me i have a many employee folder in my pc but i want to upload all folder in excel through vba script if u have any solution help me

hello programer i need your help i want to a program suppose i have thousandof employee folder and i want to this folder upload in excel sheet and iam using this sheet any where ...

Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...

Hi Peers, I need your advice. I have the following code which works by adding the a copy of the image to a cell in a column which the JPG is visible in the workbook. However, when I send the workbook to another person the images don't appear to them unless I send them the JPG files as well...

Hello, I'm trying to assign numbers to different Products using VBA. For example, if in "Products" column product "REG_AA" appears I want to assign it a number, if it doesn't appear I want to assign the next item in the list the number and go in series. If the product "REG_AA" didn't show up...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...

I have been striving to find an solution that how to check if JSON has specific string "Processing":true if it has then copy the "newLogno":776655 the ID. Here is entire JSON {"id":16,"sku":"4926","productName":"Diforda","upc":"test", "condition":"test","uniqueID":1234,"logsCey":3...

Hi all, I was wondering if I could get your advice to why this piece of code isnt ignoring the worksheets called: "Control" & "Data". This is the piece of code that I cannot understand why it doesnt ignore the worksheets when its ran: For Each sht In ActiveWorkbook.Worksheets If...

I am new in excel VBA, I am looking for an Excel VBA code that will delete all the outlook email files (.msg) saved in local windows folder using 2 conditions and keep the last dated email file. The email files are from different suppliers that supply cement, steel and other construction...

guys i do need help for calculating range like no effect of terrain and anything. i need macro anything on my excel document to simultaneously calculate distance vs battery percentage .that is whenever it goes from 80% to 5% it will charge again means reset its counter and so on . my total range...

I have multiple workbooks and I want to refresh all data connections in all open workbooks for that I have given try to following vba code <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...

I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet Sub EOD() Dim i AsLong For i =4To ThisWorkbook.Worksheets.Count...