The discussions
Copying formula by changing only one rule.
SolvedHello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...
Can't open documents with a w.
SolvedIn my documents, I have some items with PDF and some with a W. When I try to open the ones with a W, I am asked to sign up with Word. How can I open t...
How to compare a range of data in excel?
SolvedDear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...
Ms visio setup free download
Solvedi got a little challeng dowenloading free Ms visio setup could u send me please
Vba for copying from data entry sheet to corresponding sheets
SolvedHi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...
Copy rows from one sheet to others based on a condition
SolvedHello, I have a workbook for our teams budget that has 1 master sheet with 28 columns. The master sheet will be updated with more rows often (addi...
Delete or insert rows in a workbook
SolvedHello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...
How to use a macro to check data in 2 work sheets
SolvedHi 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
SolvedHello, 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
SolvedHello, 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/ClosedHello, 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
SolvedHello, 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
SolvedHello, 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
SolvedI 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
SolvedHello, 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
SolvedSo 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/ClosedHello, 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
SolvedHi, 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/ClosedHello, 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/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 ...
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...
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 ...
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....
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 ...
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...
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 ...
How to auto-populate values from certain cells into a new sheet
SolvedHello 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
SolvedHello, 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
SolvedHi.. 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/ClosedHello, 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
SolvedHello, 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
SolvedHi 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
SolvedHello, 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/ClosedI 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
SolvedHello, 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
SolvedHello, 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
SolvedHi 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
SolvedHi, 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
SolvedColumn 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
SolvedHello, 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
SolvedHi, 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
SolvedHello, 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
SolvedHello, 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
SolvedHi, 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
SolvedHi, 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
Solvedhi 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
SolvedHi 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
SolvedHello, 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...
