urgent help needed

Hi all, Need an urgent solution to the below please, if possible. It is beyond my VBA capabilities. I have created a new Excel workbook and inserted a macro button name "Import NC Data". What I need the macro VBA code to do it to ask me to select / specify a specific folder (folder and...

For example…… ( Please explain and give a solution step by step) Student ids (sheet 1-it has more column like this) Column 1. Column 2. Column 3 0000 Sunil. Maths 1111. Gayan. Science 2222. Ranjith. History 3333. Tharsh. ICT...

I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high) If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column If I choose High to low my pivot should get sorted in...

Hi, I want to populate a cell when I click another cell Example: I have a list of data in Column A, if I click any of the cells in Column A the value in that cell should populate to B1 or some cell which we want

Hi guys, Need some help on the below code please. See code below. What I would like it to do is to do the following, in sequence: 1. Create a new folder in the location of the Workbook. Name this folder based on the contents of worksheet cells "D2" and "D3", then the current date and time...

Hi guys, Need help on this one please, not sure how to go about doing it. I have the code below that I have been using up until now which prints the active sheet to PDF in the Downloads folder. What I would like it to do is to do the following, in sequence: 1. Create a new folder in the...

Hi guys, Need help with the formula below. What I need it to do is search through the workbook sheets (2-101) and check on each sheet if cell "D1" shows a result of TRUE or FALSE. If it is TRUE, then I need the formula to change the contents of cell "E6" on that sheet to read the current date...

Please assist i want display all info in a row in the listbox currently its only showing the data in the first line i presume its something to do with the offset please help me Private Sub TextBox207_Change() Dim rFound As Range Dim sFirstAddress As String Dim LName As String...

I got a task in which i have 2 Files One is a Master File containing the names of the clients and the EMI amount with Payment 1 detail And there is Another file containing Daily Collection with payment 2 Detail In Master File there are two column Pay 1 Pay 2(Values Coming From Another File...

My question is hopefully rather simple, but I'm relatively new to VBA and I know nothing about Acrobat API. After spending the better part of the past two days scouring the web for an answer, I've only found long-outdated results (like like this post from 2016 based on this blog from 2009 and...

So Firstly I help with accounts in a hospital and on the spreadsheet I am asking help for on helps show what the doctors get paid. A lot of doctors pay gets messed up because its easy to make mistakes on. What I require is we do different exam type so say I put MRI ankle it comes up under one...

Q: you intend to bring the year-end saving balances to at least $45k at year 10, $80k at year 25 and $150K at year 20. Work out three combinations of saving, interest and return rates, one for each goal that you can realistically apply. Anyone pls help !! I am submitting this for assignment...

Hi Everyone, I have a button and i need help your assistance in a macro on this button with following output. 1. Motive of this button is to insert document into excel as an icon 2. Document path should be based on A1 (Drive Location) + file name mentioned in code (.pdf) 3. Document caption...

Hello Folks, I have a requirement to extract the domains from a list of URLs. I know this is quite trending and a petty common topic across generic internet search, however no formulas quite seem to match my specific query. My file has a list of domains (which include subdomains and multiple...

Please help! i have a spreadsheet i put together for a Manager (see below) Each column (H,M,R) represents locations on a job we need to close out. I used "CONDITIONAL FORMATTING" > HIGHLIGHT > DUPLICATES"..... showed to my manager, he loved it and wanted to know if we could highlight the...

Hi, I posted a similar question a few days ago and I thought I had solved the problem but something else came up. Basically what happens is my last row keeps changing as I run my array formula macro and it gets bigger and bigger every time the formula runs and as such after a few times using...

I have an excel sheet that has numbers 1 - 20 in row 2 and various dollar amounts above them. I need a formula that if the number I put in cell D5 equals any of the numbers in row 2 it will return the dollar amount specified above it.

Hey All, So what I'm trying to do is pull data from 1 table or sheet into another. I have tried VLOOKUP & INDEX MATCH, on both separate sheets & also with both tables on the same sheet. I am trying to get Height Width & Depth fields to pull from one table to the other, by matching the UPC. So...

Hi, The following macro works, however I am trying to clean up the code Sub ShowSet1() Dim xWs As Worksheet Dim xName As String xName = "Sheet5" For Each xWs In Application.ActiveWorkbook.Worksheets If xWs.Name <> xName Then xWs.Visible = xlSheetHidden End If Sheets("Sheet1").Visible = True...

I have let's say two sheets linked between one another. One sheet has external links to the other and vice versa the first sheet let's call it the "master sheet" has about 3 different scenarios 1, 2, and 3 if I were to input "1" into a cell on the master sheet, then a number of values in...