excel macro coding

Hello, I have an excel sheet of products. I've created a dropdown but what I want now is whenever from the dropdown I select a product, it's price is fetched from another tab and also expenses of that from another sheet. I'm attaching a screenshot which will make it easier to understand...

I have two Excel sheets with named : Patching_MainSheet and ESL_Inventory In Patching_MainSheet D column have 100 Servernames and ESL_Inventory Sheet A Column have 1845 Servernames and also I column have DataCentre name. I need Macros to take one servername from Patching_MainSheet of D...

I would like to distribute my excel workbook to other people, and I was wondering if there's a way to protect my VBA code so that it would be hard to hack, and also make my workbook work as a trial, so that after a certain amount of time, it wont open anymore?

I have a sheet "data-dump", which has data from row 2 (column A to D) onwards where row 2 has got headers. The first 2 columns of the sheet has Start-Date & End-Date. I need to create a macro such that it reads the data in the sheet "data-dump" and based on the column A & B i.e. Start-Date &...

Sub Saving(ws As Worksheet) Dim dt As String Dim wbNam As String Dim sFileSaveName As Variant wbNam = "Salesforecast_" dt = Format(CStr(Now), "dd_mm_yyy_hh_mm_ss") sFileSaveName = Application.GetSaveAsFilename(InitialFileName:=wbNam & dt, fileFilter:="Excel Files (*.xlsm), *.xlsm") If...

So, I created a series of formula on a sheet called Extractor in a workbook called "Processor*". The filename of the workbook "Processor*" will usually vary, having other characters to the right of it. My intention is to copy the range covering all formula I created in a sheet named "Extractor"...

Hi, I'd like to ask help with excel. Is it possible to detect which comes first? example: John smith took his break 3 times a day, how can i identify the first break and the other 2, like is it possible that a formula can Make it like Break 1, Break 2, Break 3?

Good morning, all - I download files from an SFTP site, but the files don't always have a unique name. Files on the site have a naming convention of File_Name.xls for the first file in the group and File_Name_X for each subsequent file in the set where X is an incrementing value from 1 to the...

Hi all, I have a CSV file I need to open using notepad then import into exce when importing I need to convert Column X to text. The specific steps must be followed because if you do not open the CSV file with the notepad column X ends up with scientific notation due tot he long string of...

I have a workbook with 40 sheets, I have created query that should provide a Table of Content. What I need is the query to provide the page in sequence with the next TAB providing the next PAGE number, "not the total amount of pages". In other words, if my Executive summary has 3 pages in...

I'm very new to VBA and found a code online that sends emails to multiple recipients but can only attach 1 file per email. I cannot find a code that works wherein it goes to a specific folder and attaches all PDF files that are stored in the folder and goes to a different folder and does the...

Hi, I have an Multi-Line ActiveX TextBox1 that has the below strings as separate lines: 'Cat' 'Dog' 'Snake' 'Bear' 'Dragon' I have TextBox1 linked to a single cell, so that it will output these lines to one cell. I'm trying to figure out a way (if indeed it's even possible) to output each...

Good day, I'd like to ask for your kind assistance please, I couldnt use the macros on this sheet when i lock the worksheet is there a work around on it?, even if I sent the macros unlocked. can anyone help me please thank you so much. below are the Macros i use in a sheet. Sub Resolved() '...

I have two excel first excel output file and second excel Exchange rate excel, first check in second excel date column and pick every month 1 date exchange rate and convert in Main file currency in (INR,USD,EUR) convert in GBP format. 1: Main Output file : Empno Ename...

I have two excel first excel output file and second excel Exchange rate excel, first check in second excel date column and pick every month 1 date exchange rate and convert in Main file currency in (INR,USD,EUR) convert in GBP format. 1: Main Output file : Empno Ename...

Hello, Below is my code which I am working on. It is running but keeps prompting for user windows credentials. Can anyone tell me how to stop that.? Do I need to any line of code to stop asking for credentials or pass credentials through code. Sub testit() Set shFirstQtr =...

Hello friends, After searching all over the internet, I have a VBA code here which copies cell AG2 and pastes the data into the first empty cell in column AG. The same process repeats for cell AB2 for the second line. Range("AG2").Copy Range("AG" & Rows.Count).End(xlUp).Offset(1, 0)...

Hi I have a excel sheet in which i have to compare a UID and qty in one sheet to another sheet. I do this every morning however it is very tedious and i thought a macro would be best so i could just run it as i could get 100s of records. Record Sheet UID QTY Shipped 1...

Hello all, I believe long ago I found on this forum a very helpful VBA code for sending an automatic email from data that was contain in a table structure in excel. I would like to use the same characteristics (i.e: referencing data from certain rows and based off expiring dates) but I no...

Hi Team, I use to run a report daily of my clients. Hence i am trying to create a Macro for the same. While creating i face some difficulty. My data includes Name of clients in 1 coloumn and there comments in 2 coloumn and so on... I want macro to search a specific word for example "Good"...