Hello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...
I have three columns related to the prices of equities. Column A is for the name of individual equity, Column B is for the individual equity price of ...
Im trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...
Master sheet if first tab in workbook containing following: Case # Case Name Open date Atty Destroy Box # All rows in numerical orde...
I am trying to create a macro that will: 1. Find the cell to the right of where there is an ‘AE’ in column B 2. Copy that cell (example: C1 (218453...
Hello, In the following macro, I don't want it to remember the number 100004 which is a number I scanned in after performing Control Find. I wan...
if i8 of worksheet a is yes then copy c8:e8 of worksheet a to worksheet b in location c8:e8
Hello, in column 1 i have entered one subject mark and in column 2 i have entered another subject marks , if both the subject marks are greater than...
Please help me out, an example of data I have on sheet two Name bio Chem phy lug John 40 60 50 20 Luke 70 50 30 77 Eric 80 90 89 60 I want to c...
an example of data I have on sheet two Name bio Chem phy lug John 40 60 50 20 Luke 70 50 30 77 Eric 80 90 89 60 I want to create a workbook per n...
Hi all, I have a problem with CSV files or with Excel, Excel only places quotes around certain fields, how do I force excel to save a CSV file with q...
i am looking after purchase dept. kindly send us formula that one column contains text"BUY" and i want paste some columns in other sheet. Means cell ...
Hello, I have a data sheet showing names , numbers and date of termination in different columns. I would like to copy the details of the members in ...
I have a data sheet showing names , numbers and date of termination in different columns. I would like to copy the details of the members in a row ,w...
HI, I NEED HELP WITH CREATING A FORMULA FOR A SPREAD SHEET. THE WORK BOOK HAS THREE SHEETS (UNITS, COMPONENTS, LOADLIST). IN THE UNITS SHEET SETS OF ...
I wish to populate $values in f14 by choosing a name in a drop down list located on the same worksheet Qty Unit Price Price YT004-Oscar Terr...
Dear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column B Ro...
Can someone help? I have been struggling with this for days. VBA is something new to me and I think it hates me I have a spreadsheet that updates bas...
Hello, Private Sub CommandButton1_Click() Dim orange As Range, acell As Variant, bcell As Variant, ccell As Variant Dim ws As Worksheet Dim fin A...
I have two different files. 1. Name of the Source file - "Dump" 2. Name of the target file - "SLA File" I have the data in source file from A to G ...
Hello, i want to format a cell(make it red and negative value) if the cell next to it cantains one of the words: cancelled_by_guest. thanks stavro...
Dear sir, Please provide me a excel tracker which could be used for find out expiry date of License and intimate before one month of expiry. For kee...
Hello, This is a two part question: 1) I have three columns (A, B & C). Column A is populated with specific text such as "interviewed" or "set apar...
Hello, I'm trying to set up an IF function, I believe...I have a spreadsheet that lists dates back to 2013 as MM/DD/YYYY. I'm trying to create a for...
Hi, I'm trying to add 2 different cells in a work sheet to the header in a new worksheet. Then I need to excel to save the new worksheet as a new fi...
Hi, This thread has been really helpful. The first part of my code works and copies data that includes the term "EMAS" into the appropriate sheet. Ho...
I want to copy same highlighted cells from one sheet to another ,for example sheet 1 contains a column with different highlighted colours now i want t...
Hello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...
Hi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...
Hello and greetings CCM Expert team. May I request you to kindly help me with the following request: 1. Looking-up a Keyword [one-by-one] from a pre...
Hi I have 2 separate excel documents, 1 which had 2015/2016 data and the second which has 2014 data. What i need is to compare the 2 documents for m...
Hi, I have a massive list of about 12,000 names and then another list of about 1000 names, formatted in different columns such as First Name | Las...
Hello, I wank to ask you guys about exel. I want to convert number to word with currency. Ex: 150.5 to One hundred USdollars and fifty cents. H...
I'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...
Hello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...
Hello, I am using the " proper" formula on my mac , but when trying to drag the formula down it just copies the same name ? Please help Confi...
Hello, I conditionally formatted cell D4 that it's color changes from white to red when value in A1 is increased from 1 to 100. Now, can I make E4 a...
Dear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...
Hello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...
Hi, I am looking for a VBA excel code to capture the last updated row and notify me via email. Thanks for help. regards, SAS
Hello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...
Hello, I'm an absolute beginner in VBA. I'm using the code below to copy and paste multiple ranges into PowerPoint slides. Instead of copying and pa...
Hello, I want to create a macro that can scrape clearance data from a retailers website. I basically want to know each week how many items are on cl...
Hello, I want to create a macro that will scrape promotional emails I receive from retailers. I have a spreadsheet where I keep all the promotions i...
Hello, I want to create a macro in a master sheet that will copy last weeks data and paste in the rows below. Then I want it to open a sheet that th...
Hello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...
Good Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...
Good Afternoon! I've got a column of data (Months) that I need to insert into a cell in multiple worksheets. I know if it was within one worksheet...
Hello, I'm having an issue returning the value cell A32. I have "A32" stored in cell H3 (it was a long drawn out process to isolate the "A32" that i...
Hello, I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need ...
DON'T MISS