Excel Forum
-
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...
-
Copy cell from a column into multiple worksheets [Closed]
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...
-
Return Value in Cell Address [Closed]
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...
-
Compare Data [Closed]
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 ...
-
How To Copy Data Between Several Sheets using another sheet [Closed]
Hi All, I have a requirement to copy the data from source to target using macro excel file name: Testbook1 Source sheets Target sheets Test_Src1...
-
how to delete misline rows one worksheet by using macro [Closed]
Hello, how to delete misline cloums by using macro plz give me code.i hoping you give me answer.
-
Copy a range of cell x number of times [Closed]
Hello, Friend my query is I want to copy value from range (E1:F1) Base on the value from G1 And paste on range from A1&B1. It should continue ...
-
transferring data from one sheet to another in Excel [Closed]
I followed the instructions for transferring data between Excel spreadsheets using the +Sheet(X)!((XY) formula. So glad I found your article! This w...
-
Excel changes field format from date to text when date entered. [Closed]
I have an Excel worksheet that has a variety of formula's and conditional formating in it. There are four different date formated columns in the spre...
-
Popup Reminder Excel 2010 [Closed]
I am completely new to VBA and do not really know how to manipulate a code. I was hoping someone would be willing to formulate the codes I need to i...
-
excel arrow keys are moving the entire spreadsheet [Closed]
Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do no...
-
how to copy row to several sheets based on cell value [Closed]
Hi Ladies and Gents i really hope i can get some help here and your patience and support is highly apreciated. i have a daily tracker for all daily ...
-
Find what is the number, that will make 2 cells ABS equal [Closed]
Hey guys, I will appreciate your help on this. I'm trading on CFD's and trying to build something that will help me calculate different scenarios. ...
-
Comparing and scoring 2 workbooks for students quiz [Closed]
Hi all I am teaching students basic Excel skills and they have a quiz to do where they do certain basic tasks on a spreadsheet. I have a workbook wi...
-
function in excel 2013 [Solved/Closed]
Hello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...
-
find what is the number, that will make 2 cells ABS equal [Closed]
Hey guys, I'm trading on CFD's and trying to build something that will help me calculate different scenarios. As you can see on the file attached, I...
-
sum if.. it think? [Closed]
Hi, I have a column of cells that may contain either a 1 or 2 or.5 I need to add the column together and get a 1 to equal 15min, 2 to equal 25min a...
-
Copy all data from 2 worksheets into summary, excluding headings [Closed]
Hello, I would like to automatically copy the entire rows of 2 different worksheets (excluding the top 3 header rows) into one complete summary work...
-
How to compare data between two worksheets, [Closed]
Hi I have "sheet A", and "sheet B". I need to match the information in sheet A with sheet B and select the information needed from sheet B and writ...
-
macro to create a new sheet by copying a template from a list [Closed]
i have two sheets one is "profile" and second is "template" . this second sheet has a defined layout. in the first sheet i.e profile sheet contains a...
-
creating different sheets in same workbook from master sheet [Closed]
Hello, I have data in master sheet from Column A to Column L and about 17,000 rows. Column H contains the name of the sales persons. I have to cre...
-
how to spell in euro [Closed]
Hello, Dear sir / Madam I apologise for my latest message. I need your help concerning the formula to spell in figures that is euro 7000. Which for...
-
Any faster version of the same code to handle 5000+ records [Closed]
Hello, May i plz get a faster code for the same? currently for around 5000+ records this code takes around 10 minutes... i.e. Match all the cellva...
-
Moving information from one table to another [Closed]
I need to move data from one table to another, then loop back through until all the information has been moved, I suck at vba code etc... can any...
-
Automatic inserting a picture in a cell field [Closed]
Hello, I have maybe big unsolved problem. My question is how automatically insert picture to cell field, for example B1:H40, on condition that cell ...
-
Auto populating from one excel sheet to another [Closed]
Hello, Hi I am trying to figure out how I can have my employees names and department auto populate in another excel sheet once updated in the master...
-
Cell format - COUNTIF then subtract from another cell [Solved/Closed]
Hi, I have a spreadsheet with holidays on. I'm using =COUNTIF(D16:D380,"H") I want to then subtract this number from another cell - What do I need ...
-
markup price [Closed]
Hello, I am trying to find a formula for that will show the mark up price of a product. Configuration: Windows / Chrome 55.0.2883.87
-
Save Group of Reports as PDF Macro [Closed]
Hello, I created a sheet that pulls from other sheets in my workbook to create a report. When one cell value is changed, the entire report on my mai...
-
excel macro; automatically add text to number in column [Closed]
Hello, I am a newbie in excel macro's and I was wondering if anyone could help me. I want to write a macro who once I write a number in a cell of co...
-
need help autopopulating from master list [Closed]
Hello, I am building a budget and inventory tracking system for a landscape company. I have data that I import from a field service tracking software...
-
Private Sub Worksheet_Change(ByVal Target As Range) [Closed]
Hello, please do the needfull.. I am trying to run the below macro,but it is not running,can anyone help me on this please, Private Sub Worksheet_...
-
Auto copy info/charts from a master sheet to a second sheet [Closed]
Hello, I'd appreciate if somebody could please point me in the right direction on this... I'm a sales/supervisor for a rough interior construction ...
-
date format in Excel [Closed]
Hello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- 25101990 please give formula & example
