The discussions

How to find missing text or values comparing 2 cells

Hello, i have data in 2 columns, for ex: Column A: Bearing, Ball, 1/2 in, Cast Iron Column B: Bearing, Ball, Cast Iron by seeing this exampl...

7 replies Last reply on 16 Apr 2015 by
TrowaD

Popup menu with count

Hello, Can you help me with this? I have list of 150 driver's with licence valid upto info in D3:D153. I am trying following things 1. Check if va...

3 replies Last reply on 16 Apr 2015 by
vcoolio

Writing a macro

I am struggling trying to figure out how to move data to a new line by inserting and not copying over other data, plus removing data based on specific...

4 replies Last reply on 16 Apr 2015 by
SabKeel

Macro to copy column, open existing document, paste & save?

Hello, First of all, I'm essentially a VB novice - I've copied and applied a few very basic scripts, but nothing of this magnitude, so any and all...

7 replies Last reply on 15 Apr 2015 by
sarahzim

Recover corrupted outlook express folders

 Solved

I accidentaly deleted some folders in my Inbox Folder. My problem is now, how do I get back the .dbx files without losing any important information? P...

1 reply Last reply on 14 Apr 2015 by
balighawad

Transfer data from one sheet to another automatically

 Solved

Hello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...

19 replies Last reply on 14 Apr 2015 by
vcoolio

Formula with @ in cell

Hello, Could someone please let me know if there is a formula to get a total if row 4, column D is 8 @ 2000 and row 6, column D is 9 @ 2000. The...

1 reply Last reply on 14 Apr 2015 by
TrowaD

Vba code for bank recos

Hi All, Greetings I am looking for a VBA code for bank recons where I want to reconcile cash & bank statements, where i want to move match items...

5 replies Last reply on 14 Apr 2015 by
TrowaD

Please help resolve this

Hello, =IF(B1=Sheet2!A1,C1=Sheet2!B1) i have a cell in sheet 1 need to write the price from sheet 2 when I put a certain text in sheet 1 Conf...

4 replies Last reply on 11 Apr 2015 by
vcoolio

Can not open any documents in word

Hello, I would like to open files and not able to open in MS Word Configuration: Windows / Chrome 41.0.2272.118

1 reply Last reply on 10 Apr 2015 by
xpcman

Macro for deleting everyother six rows starting with row 7.

Hello, I am trying to use the macro function to delete six rows, skip six row, then delete six and so on. Can you help me? Configuration: Windo...

1 reply Last reply on 9 Apr 2015 by
TrowaD

Microsoft outlook pst file cannot repair

Experts, I have a user, who has left the company, however the manager of the department needs to view this user's outlook pst file. The pst file i...

1 reply Last reply on 9 Apr 2015 by
Computertech

Conditional formart

Hello, i have like four colums like below Name Age DOB Status AAA 23 XXXX Active BBB 25 xxxx ...

1 reply Last reply on 9 Apr 2015 by
venkat1926

Input repetetive data

Hello, I have to input 100 + truck weights, number plates, ticket nrs and loading times. I was wondering if any one had an easy to use template ...

1 reply Last reply on 8 Apr 2015 by
MaxStart

What cell is my data coming from?

 Solved

Oh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...

4 replies Last reply on 8 Apr 2015 by
BrianGreen

Complicatied find and copy cells to new sheet macro help

Hi I am new to excel macros and trying to sort out a large sporting club file. Basically what I want to do is copy all player information from team "X...

1 reply Last reply on 7 Apr 2015 by
MaxStart

Conditional formatting with dates

I am trying to fill cells in a column which contain a date that has already passed. I go to 'Conditional Formatting', choose 'Manage Rules' and click...

1 reply Last reply on 7 Apr 2015 by
MaxStart

Conditional formula - what if

I need to create a what if statement for a workbook. Example below... here's what I need, if Column B has the words "Left Blank" I need for it to ...

1 reply Last reply on 7 Apr 2015 by
MaxStart

Set up a count loop

Hello, How do i set up a count loop Configuration: Windows 7 / Chrome 41.0.2272.118

2 replies Last reply on 7 Apr 2015 by
TrowaD

About comments.

Hello, I have a data in A1 cell and certain information of this data is in other sheet. Now i need a pop-up comments when mouse just moves near...

3 replies Last reply on 7 Apr 2015 by
TrowaD

Transferring information from previous spreadsheet

 Solved

Hi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...

17 replies Last reply on 7 Apr 2015 by
skreechy

Excel- a macro to copy data from one sheet to another

Hello, Could anyone help me with this. I am trying to write a macro with following criteria. 1. Every week a set of data is entered into she...

1 reply Last reply on 7 Apr 2015 by
vcoolio

How do i resolve file corruption errors in powerpoint 2010?

 Solved

Dear All, One of my colleagues is getting an error frequently(attached) in powerpoint 2010 and as a result he keeps losing many slides that he prep...

3 replies Last reply on 6 Apr 2015 by
montesquinto

Single quote - excel 2007

 Solved

Hi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not ...

8 replies Last reply on 6 Apr 2015 by
FLAWLESSVW

Conditional formatting based on expiration dates

 Solved

Hello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to b...

2 replies Last reply on 6 Apr 2015 by
BC

How to convert ost file to pst file?

 Closed

Hello, We only have the OST file and no longer the PST file for outlook 2007 application. Can you please send me some easy to use and reliable sugg...

Last reply on 5 Apr 2015 by
stefanobolivar

Two criteria to check if a date in excel

 Solved

Despite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or "Out" ...

13 replies Last reply on 5 Apr 2015 by
vcoolio

Formula to add big number of day to date in excel sheet

 Solved

Dear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180 day...

3 replies Last reply on 4 Apr 2015 by
mgkimmel

Using the last few characters on a different sheet

 Solved

Hi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script that n...

2 replies Last reply on 3 Apr 2015 by
BrianGreen

How can data automatically go into a calendar created on excel?

Hello, I created a calendar on excel to collect past, present and future data but I wish to run it automatically. I know how to link data from on...

1 reply Last reply on 3 Apr 2015 by
RayH

Excel question

Hello, I am looking for a formula for excel: I have three tabs, how to make one cell automatically return to "1" within the first tab; and the cel...

1 reply Last reply on 3 Apr 2015 by
RayH

Conditional formating

I have a spread sheet with 2 columns; In column 1(one) I am tracking Employees. in column 2 (two), I track the employees position. When a position i...

3 replies Last reply on 3 Apr 2015 by
RayH

Vlookup won't work

 Solved

I am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...

2 replies Last reply on 2 Apr 2015 by
Cookie5

Adding one day to a date

Hello, I have a spreadsheet that i use for planning truck maintenace, I am trying to work out how to have 2 buttons that i can assign 2 macrows too,...

1 reply Last reply on 1 Apr 2015 by
tripped

Error message when sending an email to a specific address

Hello, When I send an email to a couple of addresses, from Outlook, I receive the following message: "Delivery to the following recipients was abo...

5 replies Last reply on 1 Apr 2015 by
Ambucias

With the help of name we can get the data one sheet to another

Hello, with the help of name we can get the data one sheet to another sheet in excel in pdf Configuration: Windows XP / Firefox 12.0

1 reply Last reply on 31 Mar 2015 by
TrowaD

Please help, counta and countif same formula

Hello, Please help me, I am trying to accomplish is this: I would like to count the text in Range (B1:b5) excluding duplicates, however only i...

1 reply Last reply on 31 Mar 2015 by
TrowaD

Autogenerate worksheets from a list of names... adding names?

Hi, I'm trying to auto-generate worksheet from a list of names. Reading other questions in the forum I found the solution for this questions. But I ...

1 reply Last reply on 30 Mar 2015 by
TrowaD

Not showing save as dialogue box.

I am an office assistant. Every time I have to spell the numbers in words. I got a solution from net that a function can be added to the function libr...

1 reply Last reply on 30 Mar 2015 by
TrowaD

Set cell value

 Solved

Hello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...

1 reply Last reply on 28 Mar 2015 by
MaxStart

Vba copy sheet to new excel file + automated manual data entry

 Solved

Configuration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...

4 replies Last reply on 28 Mar 2015 by
MaxStart

Ms office 2010 save as message shows

Hello, When working on a network shared file in MS Office 2010 , file opens quickly but when saving file shows Saving as massage comes & takes 40-50...

1 reply Last reply on 27 Mar 2015 by
Ambucias

Excel formula

 Solved

hello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...

4 replies Last reply on 27 Mar 2015 by
Nic

I need a macro that can extract data

Hello, I need help with creating a macro that can automatically copy data from different worksheets and put it into a master worksheet for a repor...

26 replies Last reply on 26 Mar 2015 by
vcoolio

Recover deleted emails in outlook express...

 Solved/Closed

Hi! Prompt please... Is there any way to recover deleted e-mail messages in Outlook Express? An important message was accidentally deleted from the...

Last reply on 26 Mar 2015 by
joseph.robinson

Code visual basic

 Solved

Hello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...

2 replies Last reply on 26 Mar 2015 by
mcculloch1dj

Compare range of cells and get the result of a third cell

Hello, i have a file with 3 columns, i need to compare each cell of the first 2 columns and of it match print the data that in the third column th...

1 reply Last reply on 26 Mar 2015 by
TrowaD

Copying a conditional format to other cells...

Hello, I have set a formula to calculate how many days between two dates i.e. Date in A5 - date in A4 +1 = number of days in A6. Pretty simple ok....

1 reply Last reply on 26 Mar 2015 by
TrowaD

Excell 2013 - conditional formatting using a formula- apply rule

 Solved

Hello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...

2 replies Last reply on 26 Mar 2015 by
Manos

Excel formula display in cell

 Solved

Hello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...

6 replies Last reply on 25 Mar 2015 by
rc
Results 3151 - 3200 out of a total of 12,266