Excel Forum
-
using formula for conditional formatting [Closed]
Hello, Excel 2013 I need to add an if formula that creates conditional formatting and I get the basics of it but my formula is not working It's ...
-
Need to know the excel macro [Closed]
Hello, I have a data like this which I would like to know the macro function. Row column A 1 123 2 456 3 789 Am curr...
-
formula that searches in a row for a cell/column that contains [Solved/Closed]
Hi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...
-
Removing a returned value of FALSE in Excel [Closed]
Hello, Here is my formula. Please tell me how I can eliminate the FALSE value for cells that don't fall within the date range (e.g. cells with dat...
-
Verifying VIN [Closed]
I have two Excel Worksheets, ie, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to compare and confi...
-
Auto populate based on matched data from other sheet [Closed]
hi, Newbie here.. Was wondering if this could be achieved thru vba as have tried using formulas and vlookup thru matching criteria and it takes fore...
-
Error in VBA [Solved/Closed]
Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...
-
Automatically transfer data from one sheet to another [Closed]
Hello, I have never done anything like this and i just watched a video that got me the first two correct columns in the second sheet but i am unable...
-
Macro Help - Pasting [Closed]
I am trying to write a macro for updating workbooks for of my accounts. Basically I have a master sheet of some data for all accounts and need to copy...
-
Extracting data from sheets added everyhour [Closed]
is there a way to extract data from sheets i add? like if i have data from multiple hours but i put all the data in one book but in different hours is...
-
Replace function in Macro [Solved/Closed]
Hello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...
-
VBA copy based on list to specific directory. [Closed]
Hi, I am attempting to copy a file with names from an excel list and copy them to a specific directory using VBA. I am using rizvisa1's code from http...
-
Securing a Excel Workbook [Solved/Closed]
Hey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...
-
Copying function using VBA [Solved/Closed]
Hello, I have a Problem that desperately Needs to be fixed: I am trying to create a Participant List, and in order to Keep it "clean", am using ...
-
Compare 2 columns on 2 sheets for value of cell [Closed]
I have tried several different formulas and cannot seem to get it right. I have a work book with 2 sheets. I am trying to populate column E of she...
-
how to recover previous version of an excel file already saved [Closed]
Hello, how to recover previous version of an excel file already saved Configuration: Windows 7 / Mozilla 11.0
-
Copying number over from last sheet and adding to it [Closed]
Hello, I'm trying to figure to if it's possible to do the following: I have an excel doc with monthly spreadsheets and I would like a number to be...
-
tranfering of data [Closed]
how do i add symbol in cells in sheet 2 if there is data in cells in sheet 1. example: i have data in A2 in sheet one. i want to add a * in A2 in shee...
-
Extract rows of data and paste to new worksheets based on locati [Closed]
Hello Fellow Excel Users: Please help if you can. I have a difficult problem that I hope someone could please help me with. I have a worksheet of...
-
Office Home and Student Excel [Closed]
I have read everything. Been asked to submit my first question three times. This doesn't bode well. Third time typing same question. I have used exc...
-
Macro that will delete rows based on greater than current date [Closed]
Hello, I want a macro that will delete rows that are greater that the current date so if today is 2016-05-05 I want it delete all rows with somethin...
-
copy the number matched to another column [Closed]
Hello, I want help from world.i want to copy the list of number to other column which are match in original column. Start no 974314567 copy the ...
-
VB & pdf files [Closed]
Hello, Overall goal to open pdf files, copy information to excel sheets & close pdf files. From reading material on web it might be easier to conv...
-
Excel 2010 - "file is corrupt and cannot be opened" [Closed]
Hello, We're upgrading to Office 2010 and having some fun issues with old and new .xls files. Current issue is that many .xls files (as opposed...
-
make a new worksheet and copy rows [Closed]
Hello, I have a worksheet of data and I would like to copy all rows in the worksheet to new worksheets based upon location. To elaborate, I ha...
-
How to build a auto updating Training Tracker. [Closed]
Hello, I am trying to make a primary spreadsheet for a personnel training tracker, I have over 50 people and 30+ different training items. with f...
-
Graphs comparison in excel [Closed]
Hello, Is it possible to compare graphs in two excel files using macros? If not, is there any other option to do this? Kindly help.
-
Pulling Data from a note field in excel [Closed]
Hello, I wrote a formula to look through a note text field for a certain phrase and pull a YES. What I need to do is actually pull whatever number...
-
copy formulas from one sheet to another all at once [Solved/Closed]
Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to cop...
-
Excel Formulas and Functions [Closed]
I have an excel form where the user types a customer name to find if it exists in another data sheet. If it exists, a function should retrieve it to a...
-
Comparing data in multiple columns to another sheet [Closed]
Hello, In Excel 2010, I have a sheet of names and addresses that I would like to compare to a new report of names and addresses to find any names th...
-
Vacation tracking help [Closed]
Hello, How do i make a cell increase by 40 every 180 days from known date... Configuration: Windows 7 / Chrome 50.0.2661.94
-
Macro move next column to next row? [Closed]
Dear All, introducing my name is John and im new here. Ive data like below A B C D 1 John Willy Dian...
-
Macro that create a new workbook for each unique value in column [Closed]
Hi, In the example below, I would like a macro that creates a new workbook based on the names in column A and copies only data relevant to that nam...
-
Number format a cell based on the text in another cell [Closed]
Hello, I want to conditionally format a cell to change the number formatting to a percentage or currency based on the text in another cell. Fo...
-
Want to increment a Alphanumeric value in a range of cells [Closed]
Hello, I have Alphanumeric value in range of cells example from B2 to b28 number will be like H000000000000100 I want to increment the last four...
-
MS excel question [Closed]
Hello, I am having a name list in column A and category list in column D and I want to list names of same category in column G in another worksheet....
-
Percentage conversion in excel [Closed]
Hello, Kindly assist me on How to find a formula for calculating a problem like this one below; Cell A1 (Assignment 1Out of 20) Cell B1 (Assignm...
-
sum of two max out of n number [Closed]
Hello, mam /sir how to sum of two max out of n number Configuration: Windows 7 / Chrome 49.0.2623.112
-
want to know how to convert date into words(english) in excel [Closed]
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Two Thous...
-
Excel Doubt - IF Formula [Solved/Closed]
Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...
-
Conditional Formatting [Closed]
Hello, Want to apply conditional formatting for specific text but not able to do so. Below is the case:- I have two texts - 1. "N" & 2. "NA"...
-
Automatic Data transfer [Closed]
I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I want the ...
-
Macro to send notification when a cell expires [Closed]
Hello, I am working on a database with expiry dates. Is there a way to get a macro to notify me via email when the date in a range of cells wil...
-
add worksheets to excel workbook using count defined name [Solved/Closed]
Hello, I need to add worksheets based on a count which I defined as ADDTABS located in cell B4 on a worksheet called QRY-CMW. The worksheets ne...
-
Compare several columns to several columns in second sheet [Closed]
I have a list of names and addresses that I need to compare to a new sheet of names and addresses to see if there are any new addresses added and also...
-
Macro to copy from multiple sheets to another workbook.. [Closed]
Hello Sir, I have a query i guess this has been soled already, but i just wanted to have a general macro for the same. MY QUERY: I have a w...
-
Sum of Returned Lookup Values in a Text Cell [Closed]
I'm using the lookup formula below to search user comments in cell B1 to find individual words listed in column C, and return the adjacent number valu...
-
continuously import select data from one sheet to another [Closed]
I have Excel 2013 I'm trying to use Excel as a study tool where I can enter information into 1 sheet, and have it automatically copied to a more so...
-
Find and Replace with condition [Closed]
Hello, I would like to ask that in the Range D11 to D510 of all sheets in workbook find "." and replace with ". " If in the above mention range "...
