Excel Forum
-
Conditional format range if one cell contains certain text [Closed]
Hello, I'm looking to use conditional formatting to make the cell next to a particular recurring word (for example, "new") highlighted. I have a s...
-
Copy a row based on a cell value. [Closed]
Hello, I have a very large spread sheet that I am trying to sort on to new tabs. Example tab one has the data and column A is the sorting column t...
-
Filter multiple worksheets based on data input in a master works [Closed]
Hi, I need some help with creating a VBA. I have a workbook that contains 6 worksheets. The first worksheet is a summary of the data listed in the...
-
Copy\paste [Closed]
Hello, Please help with below query Have 2 worksheets in same workbook and below macro is extracting data from other sheet based on firstname a...
-
Creating macro to search two values and delete them [Closed]
Hello, I´m new here. but I´ll try to do my best. I am looking for a macro where I can search in the column "I" all the values between two value...
-
Auto transfer from one tab to another [Closed]
Hello, I have been looking for ways on how to transfer a data in gdoc sheet from another tab. Example.. From Original File all data for ca...
-
Verifing-Vin Numbers [Solved/Closed]
Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...
-
formula [Closed]
I have multiple rows and one field is called product and the other is color. I am trying to figure out one formula that can be used on all the cells. ...
-
macro to search 2 values in a colum and delete them [Closed]
hi friends I´m new here. but I´m trying to make a macro where I can search in the column "I" all the values between two values. Those values are loc...
-
convert 4012016 and 24012016 in date format [Closed]
dear sir how we convert 4012016 and 24012016 in date format as dd/mm/yyyy in excel.
-
Dates from an IF statement [Closed]
Hello, I ve selected some dates via a simple if statement and can see the dates in the cell where I want them. But when I try to use them in anoth...
-
.xlsx, xls file [Closed]
Hi, I am not able to open the MS Excel file i receive in xlsx or xls format.How can i open it ? Thanks, Manwendra
-
Macro auto fill is not working [Closed]
Hi all I am trying to write for my excel .I am begginer and this first time I tred Macro. I wrote this code Private Sub Worksheet_Change(ByVa...
-
Weekly Totals [Closed]
Hello, I have a column of dates and a column of transactions. Often there are multiple transactions on the same day. How can I enter a formula in ...
-
To find a word in a sentence columnwise [Closed]
Hello, I am trying to find a particular word in a set of sentences columnwise. For example cells A1:A100 has the sentences and cell B1:B20 has the...
-
Counting a text Range if another text range has a value of.... [Closed]
Hi Everyone... Finding this really hard to figure out... I have Cell A1:A50 Containing lots of names And I have Cells C1:C50 Containing the Statu...
-
Modify the Macro [Closed]
Hello, I would like to request please modify the below macro. The below macro create a line (shape), in all sheets. If it once created (or it a...
-
If date exists (or any value) in B2, return value of 1 to C2 [Closed]
Hello, If for example there is a value of a date in column B (Row b2 or other) I need it to return a value of 1 in column C (C2 and corresponding)...
-
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
Subscribe To Our Newsletter!
