Office Software Forum - solved topics
- Excel (9,871)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
How to use a macro to check data in 2 work sheets Solved/Closed
Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...
-
How to generate a STATIC unique identifier for each Excel row Solved/Closed
Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...
-
Two IF forumlas inside an IF formula Solved/Closed
Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...
-
Autopopulating multiple sheets from one main sheet Solved/Closed
Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...
-
How to sum a number from a range of cells, based on value Solved/Closed
Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....
-
Rank of numbers between specified range Solved/Closed
Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...
-
Formatting cells based on certain criteria Solved/Closed
I want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...
-
SUM IFS function Solved/Closed
Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...
-
Excel Macro: Copy formulas across worksheets Solved/Closed
So first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...
-
Arrow keys scrolling in Excel Solved/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 not...
-
Help with formula please Solved/Closed
Hi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...
-
Subtract last column from first column Solved/Closed
Hello, I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last colu...
-
Need to calculate monthly avg and yearly miles from odometer Solved/Closed
Good 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 Solved/Closed
Hi, 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/Closed
Hello, 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 ...
-
Update data from one sheet to the next. Solved/Closed
The 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...
-
Conditional formating - apply on more cells Solved/Closed
Hello, 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 ...
-
How to change the date format in Excel 2007 Solved/Closed
Hello, 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....
-
Search for input criteria, return designated cells. Solved/Closed
Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...
-
Copying dates to another worksheet. Solved/Closed
Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
-
Excel formula - Add days to date based on drop down selection Solved/Closed
I 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 ...
-
How to auto-populate values from certain cells into a new sheet Solved/Closed
Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...
-
Highlight only one column which has greater value Solved/Closed
Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...
-
Office 2007 files will not open Solved/Closed
Hi.. I am Dipu Michael from India. I am using the software office2007 in windows7.For the checking purpose I installed 0ffice 2003 in my system. Afte...
-
Enter current time in a cell by clicking it Solved/Closed
Hello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to fil...
-
True or False Value based on 3 difference cells' criteria Solved/Closed
Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...
-
Repeating a simple macro loop up to 1,500 times Solved/Closed
Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...
-
Excel external data connection not working properly Solved/Closed
Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...
-
Convert PST to MBOX for importing into Thunderbird Solved/Closed
I have a pst file which contains all my outlook mail backups. I want to convert .pst to .mbox for importing those mails into my Thunderbird account. ...
-
Create a date from 3 different cells Solved/Closed
Hello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...
-
Macro to insert multiple rows between existin Solved/Closed
Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...
-
Copy and past the not equal value using macro Solved/Closed
Hi guys!! Please help me with this. I'm trying to compare two sheets in excel. If it is NOT a match then copy the entire row into a new third sheet. ...
-
Script is really slow and sometimes crashes Solved/Closed
Hi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...
-
Need help with script or formula Solved/Closed
Column A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...
-
Matching cells but exclude blanks Solved/Closed
Hello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...
-
Rounding up time Solved/Closed
Hi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...
-
VBA compile Error: Do without Loop Solved/Closed
Hello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...
-
Problem with script in Excel Solved/Closed
Hello, I have a problem with my script. What I want is IF the value in column J is equals to "0" then I want the column H to be blank. Ex. J1 ...
-
Cell colour containing specific info Solved/Closed
Hi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a differ...
-
Validate copied data in excel Solved/Closed
Hi, I have a below scenario one row is copied and pasted, this pasted row needs data validation such that total of each cell shouldn't exceed the r...
-
Multiple worksheet data input Solved/Closed
hi TrowaD, I am an on the job trainee at a company, i was ask to encode data from our furnace but its too much time consuming for me to encode all...
-
Conditional format based on text in same row Solved/Closed
Hi all, New to this forum. I'm running Excel 2016 on Win7 -- my spreadsheet has results of inspections in columns E, G, and J. The possible valu...
-
How to manage hours and rounding in Excel Solved/Closed
Hello, I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E...
-
Removing " false" value in "IF" Solved
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C11="Evening",200,IF(C11="Gaze...
-
Formula Solved/Closed
I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...
-
Convert date of birth in word Solved/Closed
Hello, pls tell me formula for convert date of birth in word in excel
-
Comparing values of two Excel sheets Solved/Closed
Hello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...
-
Copy/paste a range 'n' times. Solved/Closed
Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...
-
Conditional Format Solved/Closed
Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has
-
Vlook up Solved/Closed
Hello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help
