Excel Forum
-
Macro: copy, paste, unitl Closed
Can someone please help me out with this? I am trying to create a macro that will: 1. Find the cell to the right of where there is an ‘AE’ in colum...
-
Copying down/pasting across and not all of them! Closed
well here's to hoping someone can help, this is far beyond any ability that I have, so my apologies in advance! I have included a picture so that you...
-
how to show a specific column Closed
sir i want show only a specific column on another sheet.for example i have A-Z column with data and i want to print only specific column means show da...
-
Generate excel workbooks based on excel list Solved/Closed
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...
-
Multiple Cell Conditional Formatting in Excel 2013 Closed
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 ...
-
If Then Solved/Closed
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...
-
Copy specific data from Master sheet to multiple sheets. Closed
Master sheet if first tab in workbook containing following: Case # Case Name Open date Atty Destroy Box # All rows in numerical orde...
-
Macro building Closed
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...
-
Macro Closed
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...
-
copy from one worksheet if yes to differnt worksheet Closed
if i8 of worksheet a is yes then copy c8:e8 of worksheet a to worksheet b in location c8:e8
-
to find the grades in excel Closed
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...
-
create workbooks using a template and information from a table Closed
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...
-
create workbooks based on a given template using data in a table Closed
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...
-
Excel CSV problem Closed
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...
-
formula for if specific contains text Closed
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 ...
-
Help in creating a macro to copy row Closed
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 ...
-
How to copy the data in a row to another sheet using a macro Closed
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...
-
EXCEL FORMULAS Closed
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 ...
-
Choosing a list item Closed
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...
-
Email with Multiple Attachments through VBA Solved/Closed
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...
-
Send an email using VBA when a cell value changes Closed
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...
-
can anyone pls help me Closed
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...
-
How to import data from one excel workbook to another using VBA Closed
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 ...
-
Conditional format based on another cell containing text Closed
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...
-
Tracker for License, Registration and policies and Letter updat Closed
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...
-
Date Value of a cell Determined by Specific Text in Another Cell Closed
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...
-
Separating Dates Using IF Function Closed
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...
-
Macros/VBA Closed
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...
-
Copy rows into sheets depending on a condition in one column Closed
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...
-
automatic copy paste Closed
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...
-
IF and IS TEXT or IS NOT Blank Solved/Closed
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...
-
Conditional Formatting range of date cells based on another cell Solved/Closed
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...
-
ExcelVBA-Find a listed Keyword & move entire string to the Sheet Closed
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...
-
Compare 2 excel documents and find the same data in both sheets Closed
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...
-
See which names are duplicates Closed
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...
-
convert number to word with currency Closed
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...
-
Search for a Keyword. Add Value from another cell. Solved/Closed
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...
-
A IF(istext) formula that needs a trimming, please help? Solved/Closed
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...
-
trying to drag the formula down it just copies the same Closed
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...
-
Conditional Formatting Closed
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...
-
Worksheets into Workbook Solved/Closed
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...
-
Text from two different cells to give value shown in certain cel Solved/Closed
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...
-
VBA: Send last updated row via email Closed
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
-
Conditional Formatting for Word and Date Solved/Closed
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...
-
Pasting multiple ranges from excel into powerpoint slide as link Closed
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...
-
Macro that can scrape websites Closed
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...
-
Macro that will scrape emails Closed
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...
-
Macro that will copy/paste data each week Closed
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...
-
Auto copy and paste cell range to a separate sheet Solved/Closed
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...
-
Need to create multiple tabs based on data in table Solved/Closed
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...
