Office Software Forum
- Excel (9,803)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
-
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...
-
i have a problem in match function Closed
Hello, i want to ask u that if i have a text in one cell and i want to match more than one text from cell.for ex. cell contains(buy now this is a spa...
-
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...
-
wifi connected but no internet access Closed
Hello, wifi conected but o inetrnet access Configuration: Windows 7 / Chrome 55.0.2883.87
-
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...
-
Lettering malfunction (appearance) Closed
there is a problem with my LT in lettering appearance!
-
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...
-
Delivery date should be change in one word DELIVERED Closed
Hello, Is there any formula that we can change delivery date into just one word "Delivered" Configuration: Windows 7 / Chrome 55.0.2883.87
-
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...
-
Nested IF functions using time values Solved/Closed
Hello, can someone tell why this wont work. The time value functions work separately on their own, and I followed the excel help for nested if func...
-
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...