urgent helped needed!

Hi all, I'm chasing a VBA macro urgently but don't know how to go about it. Thanks in advance, please see below: There are 3 documents, I have links to them below: Doc_1: Loading Google Sheets Doc_2: Doc_2.xlsm Doc_3: Loading Google Sheets What I require is a VBA macro in "Doc_3" which when...

Hi guys, I'm after a VBA macro code that I can have saved in a workbook that, when run by pushing the macro button. Brings up a window where you can select a folder and it will find all excel workbooks in that location and print them to PDF. I would like the Print to pdf to only print used...

Hi guys, Id like to have the conditional formatting setup in cell G6 so that it does the following: 1. When cell G6 is below a cell value of 18 cell G6 has a green fill. 2. When cell G6 is a blank cell G6 it has no fill. 3. When cell G6 is above a cell value of 18 cell G6 has a red fill. 4...

Hi guys, Not sure where to start with this one, any help is greatly appreciated. I am after a code that would run as soon as the workbook is opened. I would like it to first check the "Device name" and compare it to a list of names in the code which are allowed to open the workbook. If the...

i create daily stock distribution order and want to distribute a value (warehouse stock) based on 2 different values(pharmacy stock & pharmacy sales). For example, my stock in warehouse is 20 units and in a pharmacy the stock for same item is 10 units but the sales of that item in that pharmacy...

I have a pre-built Word form document that I use that has multiple fields that I fill out (customer name, dates, etc.). I usually copy/paste information to this document from other sources (Excel, Word docs, etc.). QUESTION: I need to create a way to automate moving the required data from...

Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...

I have data in excel as mentioned below Input 1a 1b 1c 4a 4b 4c 7a 7b 7c 2a 2b 2c 5a 5b 5c 8a 8b 8c 3a 3b 3c 6a 6b 6c 9a 9b 9c Output 1a 1b 1c 2a 2b 2c 3a 3b 3c 4a 4b 4c...

Hi Everyone, I am struggling to create a macro which will import all files from predefined folder having same prefilx. Kindly refer below for more details: C2 = ShareDrive link in which i have files Files Name = Sample 1.pdf, Sample 2.pdf, Sample 3.pdf I have below code by which i can upload...

Hello, Can someone help me with same... I am using Sumproduct funtion which is as follows: =SUMPRODUCT((F5:F19)*(E5:E19))/SUM(E5:E19) It uses values from two colums (one is the weight and the other the values 0 and 1) the formula work fine except if the Values column is BLANK. How can I...

Need help with vba code that should merge multiple workbooks into one workbook from a folder that the user chooses, but it should only merge the 1st sheet of each workbook. I found this code only it does half of what I need but I'm clueless about the rest. Scheme for macro working: 1st - Ask...

Hello, I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table. e.q. consider i have a table with Subscriber Effective_date Expiriation_date Service_Code Now i want to dynamically create a custom table...

Hi Guys, I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...

I am wanting to move select data to another existing sheet in my spreadsheet. Any that say "Yes" will need the first column data and the reason (last column) to be brought across to the other sheet. In this case the "Sad" and "Angry" data is not needed on the new sheet for the report. Example...

Hi, I have a large data set over 200,000 rows but I would like to select a range i.e. A1-J2000 copy to another sheet then A1001-J2000 copy to another sheet? I was doing this manually but it will take forever does anyone have a simple code for my macro do this automatically without inputing...

<quote> I was curious if someone could tell me how to change this formula and add some properties. Such as: To ignore number strings lead by zeros, if an x is directly behind a + = - its counted as a 1 is extrated (or in the case of the - a -1), and if a - is directly in front of a number...

Hi, i'm a very new user at excel and forums, so please be patient with me. I do reading tests, and would like to graph the results, I have a sheet with the name of the student on top with what text being tested on, which i guess will be the title of the chart, i then have the the date tested...

Hi All Could somebody tell me how to return solver err msgs like" no feasable solution found" via vba msgbox?

Hi there, I have values in two columns A and C. I need to write a macro to copy the values in every 11th cell in both columns to a new worksheet. The first value in column A that I would like to copy is in row 32. So the subsequent values are in rows 43,54,65 etc. In column c, the first value...