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...
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...
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...
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...
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...
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...
Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...
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. ...
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...
dear sir how we convert 4012016 and 24012016 in date format as dd/mm/yyyy in excel.
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...
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
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...
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 ...
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...
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...
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...
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)...
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 ...
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...
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...
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...
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...
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...
Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...
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...
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...
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...
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 ...
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...
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...
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 ...
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...
Hello, how to recover previous version of an excel file already saved Configuration: Windows 7 / Mozilla 11.0
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
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.
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...
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...
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...
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...
Hello, How do i make a cell increase by 40 every 180 days from known date... Configuration: Windows 7 / Chrome 50.0.2661.94