The discussions

Working out the difference in times between two columns

 Solved

I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...

5 replies Last reply on 12 Nov 2017 by
sailingdemon

Sku011.cab

 Solved/Closed

when I go to open ms word or ms excel computer ask for sku011.cab file. I have no cd of office 2003. please help

Last reply on 12 Nov 2017 by
ss

How to copy columns to a specific column header and repeat?

 Solved

Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...

2 replies Last reply on 10 Nov 2017 by
stylus33

Changing format of date in excel

 Solved/Closed

Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...

Last reply on 9 Nov 2017 by
Dnbaugh

Outlook 2010 configure for gmail

 Solved

I have created an account and tried configuring through Outlook 2010. Though the test message is successful for sending and receiving, outlook is able...

10 replies Last reply on 8 Nov 2017 by
Ambucias

Copying formula by changing only one rule.

 Solved

Hello 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 ...

2 replies Last reply on 7 Nov 2017 by
shan_asa

Can't open documents with a w.

 Solved

In 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...

3 replies Last reply on 1 Nov 2017 by
Bob.C

How to compare a range of data in excel?

 Solved

Dear 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 ...

4 replies Last reply on 29 Oct 2017 by
shan_asa

Ms visio setup free download

 Solved

i got a little challeng dowenloading free Ms visio setup could u send me please

2 replies Last reply on 28 Oct 2017 by
huda-rezk

Vba for copying from data entry sheet to corresponding sheets

 Solved

Hi, 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 ...

7 replies Last reply on 24 Oct 2017 by
TrowaD

Copy rows from one sheet to others based on a condition

 Solved

Hello, 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...

6 replies Last reply on 19 Oct 2017 by
TrowaD

Delete or insert rows in a workbook

 Solved

Hello, 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...

1 reply Last reply on 12 Oct 2017 by
TrowaD

How to use a macro to check data in 2 work sheets

 Solved

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...

1 reply Last reply on 9 Oct 2017 by
ac3mark

How to generate a static unique identifier for each excel row

 Solved

Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...

4 replies Last reply on 6 Oct 2017 by
ac3mark

Two if forumlas inside an if formula

 Solved

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! ...

4 replies Last reply on 6 Oct 2017 by
Mazzaropi

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"...

Last reply on 5 Oct 2017 by
TrowaD

How to sum a number from a range of cells, based on value

 Solved

Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....

3 replies Last reply on 5 Oct 2017 by
TrowaD

Rank of numbers between specified range

 Solved

Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...

3 replies Last reply on 2 Oct 2017 by
TrowaD

Formatting cells based on certain criteria

 Solved

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...

7 replies Last reply on 29 Sep 2017 by
sailingdemon

Sum ifs function

 Solved

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...

2 replies Last reply on 25 Sep 2017 by
dshaviv

Excel macro: copy formulas across worksheets

 Solved

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...

12 replies Last reply on 24 Sep 2017 by
OCG

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...

Last reply on 20 Sep 2017 by
Upthewall

Help with formula please

 Solved

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 ...

3 replies Last reply on 19 Sep 2017 by
CB7373

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...

Last reply on 18 Sep 2017 by
vcoolio

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...

Last reply on 13 Sep 2017 by
vcoolio

Auto-populate info. from master sheet to multiple sheets

 Solved

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 ...

15 replies Last reply on 12 Sep 2017 by
TrowaD

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 ...

Last reply on 9 Sep 2017 by
BogelBot

Update data from one sheet to the next.

 Solved

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...

3 replies Last reply on 5 Sep 2017 by
ac3mark

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 ...

Last reply on 30 Aug 2017 by
Raj

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....

Last reply on 26 Aug 2017 by
Praveen

Search for input criteria, return designated cells.

 Solved

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 ...

12 replies Last reply on 19 Aug 2017 by
vcoolio

Copying dates to another worksheet.

 Solved

Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...

12 replies Last reply on 17 Aug 2017 by
vcoolio

Excel formula - add days to date based on drop down selection

 Solved

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 ...

3 replies Last reply on 17 Aug 2017 by
Mazzaropi

How to auto-populate values from certain cells into a new sheet

 Solved

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...

18 replies Last reply on 12 Aug 2017 by
vcoolio

Highlight only one column which has greater value

 Solved

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...

3 replies Last reply on 11 Aug 2017 by
Mazzaropi

Office 2007 files will not open

 Solved

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...

1 reply Last reply on 10 Aug 2017 by
xpcman

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...

Last reply on 2 Aug 2017 by
avega

True or false value based on 3 difference cells' criteria

 Solved

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...

1 reply Last reply on 26 Jul 2017 by
ac3mark

Repeating a simple macro loop up to 1,500 times

 Solved

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 ...

5 replies Last reply on 20 Jul 2017 by
TrowaD

Excel external data connection not working properly

 Solved

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...

1 reply Last reply on 19 Jul 2017 by
kvil

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. ...

Last reply on 14 Jul 2017 by
jhonnyeng

Create a date from 3 different cells

 Solved

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...

11 replies Last reply on 13 Jul 2017 by
Udeni

Macro to insert multiple rows between existin

 Solved

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...

7 replies Last reply on 11 Jul 2017 by
Pedro

Copy and past the not equal value using macro

 Solved

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. ...

3 replies Last reply on 10 Jul 2017 by
Sam

Script is really slow and sometimes crashes

 Solved

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...

5 replies Last reply on 7 Jul 2017 by
vcoolio

Need help with script or formula

 Solved

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...

5 replies Last reply on 5 Jul 2017 by
josh07429

Matching cells but exclude blanks

 Solved

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...

11 replies Last reply on 4 Jul 2017 by
Hira

Rounding up time

 Solved

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...

1 reply Last reply on 30 Jun 2017 by
nickname missing

Vba compile error: do without loop

 Solved

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...

1 reply Last reply on 28 Jun 2017 by
ac3mark

Problem with script in excel

 Solved

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 ...

6 replies Last reply on 26 Jun 2017 by
josh07429
Results 351 - 400 out of a total of 2,608