The discussions

Converting rows of data in notepad to columns

 Solved

Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...

2 replies Last reply on 5 Feb 2015 by
Philgood_FR

Excel

Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...

1 reply Last reply on 5 Feb 2015 by
TrowaD

Conditionally copy columns

 Solved

Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...

2 replies Last reply on 4 Feb 2015 by
GMHerbs

Find word on sheet1 move all adjacent column values to sheet2

Hello, I have a list of accounts and information on items inside the accounts along with the account owner. It goes like this, A= account number, B...

1 reply Last reply on 4 Feb 2015 by
feeders

Change a range dynamically - vba script.

 Solved

Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...

5 replies Last reply on 4 Feb 2015 by
BrianGreen

If formula

This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...

1 reply Last reply on 4 Feb 2015 by
pijaku

Date not showing up as a date???

Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...

5 replies Last reply on 3 Feb 2015 by
BrianGreen

Conditional formating

I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...

1 reply Last reply on 3 Feb 2015 by
xpcman

Macros code

My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...

10 replies Last reply on 3 Feb 2015 by
TrowaD

Exchange inbox repair tool

 Solved/Closed

Hello, I have Exchange 2010 server that is being used to temporarily hold mailboxes. After a reboot the .edb file went from 276gb to 0kb. Of cour...

Last reply on 3 Feb 2015 by
sorincornea

Macro for transferring data from one excel to different excel

Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...

1 reply Last reply on 3 Feb 2015 by
venkat1926

Looking for help with a macro/vba for find/copy/paste

I have a lot of data in column A of a spread sheet. I would like to "search" for part of a string, and then copy the row of the cell with this data in...

7 replies Last reply on 2 Feb 2015 by
RayH

Enter current time in a cell by clicking it

Hello, I followed the instructions and it works great. My problem is how do you turn it off with out deleting the visual basic entry? AJ Co...

1 reply Last reply on 2 Feb 2015 by
RayH

If function date problem

Hello, i am trying to use excel to give me two values depepnding if its a monday or a wednesday i have a date box so every week a person will pu...

2 replies Last reply on 2 Feb 2015 by
RayH

Comparing two lists of names in excel and then sorting them

Hello, I am wanting to compare two columns of information containing names from two different excel sheets. Names that do not appear on both list...

1 reply Last reply on 2 Feb 2015 by
TrowaD

Can i accomplish this with conditional formatting or another way

Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...

1 reply Last reply on 2 Feb 2015 by
TrowaD

Excel

Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently

1 reply Last reply on 2 Feb 2015 by
kieferschild

Removing false in excel

 Solved

=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!

2 replies Last reply on 2 Feb 2015 by
umer007

Increment a cell value - conditions applied

 Solved

Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...

2 replies Last reply on 1 Feb 2015 by
peweuk

Michelle

Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...

1 reply Last reply on 1 Feb 2015 by
RayH

Want to copy sheet1 data to sheet2

Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...

1 reply Last reply on 30 Jan 2015 by
vcoolio

Apply a negative until 0 is reached in excel

I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...

3 replies Last reply on 30 Jan 2015 by
RayH

How to merge the data from 2 different sheets into 1?

I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...

3 replies Last reply on 30 Jan 2015 by
RayH

Rating from parameter lookup

 Solved

Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...

11 replies Last reply on 30 Jan 2015 by
dxa02091

Free publisher

During installation the message for product key appears and the text is in French, even though it says English on the webpage which has the downloade ...

1 reply Last reply on 29 Jan 2015 by
xpcman

Nesting if() functions?

 Solved

Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...

3 replies Last reply on 29 Jan 2015 by
pijaku

Excel macro create new sheet copy & paste cells

Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...

1 reply Last reply on 29 Jan 2015 by
pijaku

I'm not able to send emails

Hello, i use bsnl broadband at home. should i reconfigure my account settings to send emails if my broadband provider initially was different from...

1 reply Last reply on 29 Jan 2015 by
ac3mark

Automiatic email

Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...

2 replies Last reply on 28 Jan 2015 by
Ambucias

Outlook e mails

Hello, Cannot send messages but receive. Get message when sending. 0x80042109 Thank you Adriaan Configuration: Windows / Mozilla 11.0

1 reply Last reply on 28 Jan 2015 by
xpcman

I'd like to change a pdf file to word, excel and powerpoint

To whom it may concern I'd like to change a PDF document to excel, word and power point. Please help me soon as this is as a matter of urgency. ...

1 reply Last reply on 28 Jan 2015 by
xpcman

Number of days between 2 dates

Hello, i am trying to calculate the number of days between 2 dates i,e 09/08/1965-05/02/2007= 41 years and 181 days which is 15146 days Whe...

3 replies Last reply on 28 Jan 2015 by
puppy

Outlook e mail problems

I have a problem with my outlook e mail. Cannot send mails but receive mails. I receive the following message: 0x80042109

1 reply Last reply on 28 Jan 2015 by
ac3mark

Help help help excel formula

Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...

2 replies Last reply on 27 Jan 2015 by
ArashMan

Due date reminder with an email to the filtered list

Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...

1 reply Last reply on 27 Jan 2015 by
RayH

Why dbx files do not opened

 Solved

As soon as I have not tried to open the file through Outlook. Out - walked into account. Downloaded the new version - nothing helped. Outlook does not...

1 reply Last reply on 27 Jan 2015 by
wauters87

Change date format using excel macro

Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...

9 replies Last reply on 27 Jan 2015 by
SUNIL

Comparing excel sheets with only a few overlapping records

Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...

1 reply Last reply on 26 Jan 2015 by
RayH

Mtch formula required

Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...

1 reply Last reply on 26 Jan 2015 by
RayH

How to make a cell flash using excel 2011 for mac

Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...

1 reply Last reply on 26 Jan 2015 by
RayH

Major problems images into word

Hi all, At the moment I am having major issues with inserted images into word. Background: it concerns my PhD thesis of about 140 pages. In this do...

2 replies Last reply on 25 Jan 2015 by
EsoxL

I am looking for outlook express fix tool

 Solved

Hello everyone...How can i restore damaged .DBX file of OE? I am not able to see the mails. My 4 Gb data in inbox.dbx is corrupted of .dbx files by u...

2 replies Last reply on 24 Jan 2015 by
samlund

Replace cell content in excel 2007

Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...

1 reply Last reply on 24 Jan 2015 by
RayH

Macros or vba for data validation

Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...

1 reply Last reply on 24 Jan 2015 by
venkat1926

1 time data entry

 Solved/Closed

Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...

Last reply on 23 Jan 2015 by
ArashMan

Add an x to cell if other conditions met

Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...

5 replies Last reply on 23 Jan 2015 by
RayH

Convert numbers to words in excel

please clarify my problem "convert numbers to words in excel"

1 reply Last reply on 23 Jan 2015 by
RayH

Mm/dd/yy and dd/mm/yy and mm-dd-yy and dd-mm-yy in one column

Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...

5 replies Last reply on 23 Jan 2015 by
RayH

Replacing duplicates

Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...

1 reply Last reply on 23 Jan 2015 by
whatsit

Due date reminder in excel to new sheet?

 Solved

Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...

5 replies Last reply on 22 Jan 2015 by
Babu546
Results 3351 - 3400 out of a total of 12,266