The discussions
Need help with data sorting & updation
Hello, I have a sheet with 6 coulmns each with (ABC & DEF) some value and different data Column A & D have same values. e.g. A B C D E F I want...
If then else
Hello, Please help me with a formula for Excel(?) in Open Office. I want to say....If =IF(G59=date;then_date;otherwise_0) I am trying to say i...
Filters for rows label coming as (blank)
Hello, I ran a Pivot on office2013 and some reason my filters for Rows label coming as (blank) Any idea?please? System Configuration: Windows /...
Need to calculate monthly avg and yearly miles from odometer
Solved/ClosedGood afternoon, I am having an issue figuring out how to get excel to calculate the yearly mileage and monthly avg by just monthly odometer reading...
Auto-populate info. from master sheet to multiple sheets
SolvedHi, I have been working on an excel sheet for the past month and have not found a solution that would do what I need it to do. I'm sure there have ...
Find word within cell & put value in adjacent
Solved/ClosedHello, I'd like to scan a column for a certain word (e.g. "apple") and put a code (e.g. "A") on the cell next to it each time it finds it. In this ...
Ms office product key
I am in the process of downloading microsoft office. a product key is required how do I get it
Enter data into main worksheet and have it update separate ws
I have a workbook that I would like to enter all my data into one main worksheet "2017 Job Cost Analysis" and have that data automatically populate al...
What will be the formula
Hello, if A1>A2 THEN C1+C2 AND IF A1
Lock a cell based on another cell in the entire sheet
Hello, I have drop down selection (Yes/No) in Column A, and I need to lock corresponding cell in Column B if the result is "No" in Column A. Please ...
Where to get the product key which was downloaded
where to get the product key which was downloaded
Date of brith in words 05/06/2016
Hello, date of brith in words 05/06/2016
Update data from one sheet to the next.
SolvedThe macro I want just takes data from one tab and adds it to another like an update. i suspect that the macro will take some time to make as the updat...
Microsoft office recovery
I've been using MS Office on my lenovo laptop ever since. But recently my windows crashed and i had to reinstall the software. Upon rebooting, i lost ...
Working in word, trying a file
When you try to open the file .doc (with a finished thesis!!!) crawls this message: Word experienced an error trying to open the file. Try the fol...
Transfer activity data to new sheet with yes/no criteria.
Hello, I need to prepare the excel summary with the help of Master sheet. If the drop down in master sheet is yes, than that option should be copy...
Help with adding columns for state totals
Hello, I have a worksheet that shows clients (col A) by state(col B) with total spend (col E). I have all states abbreviation in col H and woul...
Want the coding to paste some data to another sheet
Hello, I want to copy one data to another sheet. But I want the data to be pasted one after another as many time I submit it System Configurati...
Ms office home use
Hello, If I was to purchase MS Office Suite 2013 for my Laptop computer, do I get a key so I can also install it on desktop computer home both 201...
Locate 7 digits after 'dell#' in one column and have it replicat
Hi I am trying to locate 7 digits after 'dell#' in one column and have it replicate those digits to another cell.
How to look up a value within only a subset of another column?
Hello, Thanks in advance for any help! This is my data: X 1 3 X 2 4 Y 1 5 Y 5 4 Y 3 2 And I want to know, does the value in C1 ('3') ...
Google sheets to keep up with high school football scores
Hello, Ok I am creating a google spreadsheet to keep up with High School Football Scores. I would like help with a formula that allows me to color...
Conditional formating - apply on more cells
Solved/ClosedHello, i'm not so familiar with conditional formatting, so I would like to ask something: I'm making a doc where Column A has number values, column ...
If and or functions using a date
Hello, I am trying to make a formula that says IF Cell is dateA then the answer is Blue If cell is dateB then answer is Green If A9=(2017,9,9)...
Automatically transfer data from multiple sheets to one sheet.
Hello, I have a price book in Excel with multiple sheets. Sheets are formatted differently except for first three columns (QTY,PartNo,Price). I ...
Date format
Hello, i downloaded one excel sheet containing dates in format December 13th, 2011 . i want to change its date format . i tried changing in form...
Change date format
How do i change the below date format into mm/dd/yyyy? 15-12-2015 22-07-2015 22-07-2015 your response is highly appreciated
Ms office 2010 product key
i have downloaded microsoft office 2010 free version and it is asking for product key. now where i can find the product key????
How to change the date format in excel 2007
Solved/ClosedHello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- monday,1dec.2008 plz. answer me soon....
Macro to create new workbook and copy data at each change of x
Hello, I get large spreadsheets with thousands of lines with close to 200 patient names (one patient contains multiple lines for each different da...
How to compare column and spot the difference
Hi. I really need help to solve this problem. I have few hundred data in 4 columns as below. Is there's anyway I can use excel formula to find the ...
Convert date into month and year to use > <
Hello, I have two sets of dates that I need to compare using ,=. One of my dates is formatted mm/dd/yyyy. the other date is mm/yyyy. The goa...
Sentence peekaboo
In excel. I am typing a sentence and as soon as I click in another cell half of my sentence disappears. Only to reappear when I click back into the be...
How to make workbook autocreate new sheet every month with data
Hello, I am looking for some help, I am wanting my workbook to auto create a new sheet at the begging of every month and that when it makes the ne...
Copy names from one worksheet to another and copy
Hello, I have an issue at work that a macro, if it is possible, would be extremely useful. I have an excel file with a list of hundreds of first...
Excel help please!
Hello, I am in the process of creating an action tracker so it has all the actions that come out of different meetings. Each meeting has a seperate...
I forgot my gmail password
Please I need help I forgot my Gmail password
Excel macro
Hello, I'm also very new to macro, so I don't know what I'm supposed to be adjusting! My main sheet is titled "Project Timeline" and my other s...
Search for input criteria, return designated cells.
SolvedHey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...
Inserting and formating date with userform
Hello, I am trying to Insert a date with a Textbox in a Userform. It should have this format: Friday, 18.08.2017. This entered Date is used...
Ms outlook can't access my mail
I like to use MS Outlook 2007. For me it is the best. But some hours ago something bad happened with .pst file. All my email aren't accessed. I have t...
Free ms office download
I just bought an HP Pav laptop and I have noticed that no MS Office is installed. Do you know where I can download the full version for free, I badly ...
Copying dates to another worksheet.
SolvedHello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
How to convert numeric into words in excel
What is the formula to convert numeric in words?
Excel formula - add days to date based on drop down selection
SolvedI want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...
Comparing two excel sheets and copying like data to third sheet
Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...
I am facing problem after download the ms office 2010
hi ,, I am having a problem after download the ms office 2010.. it is not opening .. please tell me the solution .. ASAP
Vba: cell range
Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...
Search for text , cut and paste into new work sheet
Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...
Transfer data from one sheet to another
Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...
