The discussions

Conditional formatting excel 2010 based on content in other cell

Hello, I have a conditional formatting issue - and I think maybe the cause is that outcome is already a formula? In cell U5 I have the following...

1 reply Last reply on 27 May 2013 by
TrowaD

Re: make a macro run when data entered in a cell -multiple event

 Solved

Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...

1 reply Last reply on 27 May 2013 by
TrowaD

Compare columns match and insert data from another column

Hello, have a sheet with following info A B C D E F G H I J date-sum-item percentage- date sum item now i need to match the date su...

16 replies Last reply on 27 May 2013 by
TrowaD

Daily attendance sheet that calculates monthly percentage

I am trying to design a daily attendance sheet that students sign in on via computer, but I need it to also have a column that shows their attendance ...

1 reply Last reply on 27 May 2013 by
TrowaD

Conditional format

 Solved

Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...

2 replies Last reply on 27 May 2013 by
boon1d

Look at column and match and add this text te

 Solved/Closed

Hello, I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the ad...

7 replies Last reply on 23 May 2013 by
Ajith

Copying excel formula in different ranges

I want to copy a formula using different data ranges. The formula can't take dynamic range once copied. Example I want to use sumif formula from...

1 reply Last reply on 21 May 2013 by
TrowaD

Excel macro - selection of data from column using flag (0 or 1)

Hi, In Excel, I have a column of data and corresponding flags (either 0 or 1) in another column. I want to copy only those data which correspond ...

1 reply Last reply on 21 May 2013 by
TrowaD

Convertion number into word

 Solved

Sir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...

1 reply Last reply on 21 May 2013 by
TrowaD

40 % add formula in excel cell

 Solved

i want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...

1 reply Last reply on 21 May 2013 by
TrowaD

Insert row data into every second row

 Solved

Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...

1 reply Last reply on 16 May 2013 by
TrowaD

Macro

 Solved

Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...

6 replies Last reply on 16 May 2013 by
TrowaD

Incoming and outgoing mail servers

 Solved/Closed

Hello, I am having multiple email accounts. I like to configure all my email accounts in OUTLOOK EXPRESS. I am not able to do the same in OU...

32 replies Last reply on 16 May 2013 by
nirmalkumar

Macro vba message run-time error '1040'/ i am getting this messa

I akeep getting error message any time a try to test the Ctrl code. Please help. b PrintChart() ' ' PrintChart Macro ' Created 5/7/2013. Macro...

1 reply Last reply on 14 May 2013 by
TrowaD

Multiple if statement not returning numbers - returning words

Okay now I need the column to say if the amount in c18 is 500.00 then put 20.00, but if c18 is 38.46 then put 38.46. When I enter the formula below, ...

3 replies Last reply on 14 May 2013 by
TrowaD

Graphic will only move up- all arrows nudge it up

After copying an image into word, I'll set it to be behind or in front of text and try to position it exactly where I want by clicking and dragging it...

2 replies Last reply on 14 May 2013 by
MattTrain

Pdf won't open

Emailed attachment in PDF won't open in my windows XP. After double clicking the file it asks for ... tried all the selection (as I don't know what to...

1 reply Last reply on 14 May 2013 by
Ambucias

How to find out two words matching with one additional number

Hi.. Please tell me how to find out matching two words with only one differnce. If Two Columns of Excel contains Data like Vehcile Numbers MH01A123 an...

1 reply Last reply on 13 May 2013 by
TrowaD

Greater than/less than between 2 dates

 Solved

i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...

3 replies Last reply on 13 May 2013 by
TrowaD

Macro to highlight cells.

 Solved

I am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...

2 replies Last reply on 13 May 2013 by
steveo0707

Lookup/index data with multiple match

Hi, I am not an expert in excel but have some experience. Could some find me some excel formula or VBA code preferably for my data: 01/03/2013 C...

2 replies Last reply on 10 May 2013 by
Jason 22

Button to delete a row

Hello, i'm trying to create a comand button on excel to delete a slected row, using vb, i need to know the whole procedure and the code appreciat...

2 replies Last reply on 9 May 2013 by
David

Ms excel found a problem and has to be finished

Hello, XP, Excel 2002 I have a data sheet with a Line-gragh and scroll bars (up/down) The scroll bar shut increase/decrease a cell value. Done b...

5 replies Last reply on 8 May 2013 by
juppkk

Date change with column paste

 Solved/Closed

Hello, Whenever I try to paste the dates and times from one spreadsheet to another, the dates changes from 2008 to 2004. Why won't the dates just...

10 replies Last reply on 8 May 2013 by
pleb

Help me with formulas please?

 Solved

Hi all, I need a set of 3 to 4 formulas which would show a monthly grow of accrued interest on each of the new amounts eg: formula 1:Month 1- 1...

5 replies Last reply on 8 May 2013 by
svdwest

I want to put a date in b1 when i enter a1

Hello, I have a scanner that reads barcodes and when I read a barcode is there any way for it to put the date in B1 and the time in C1? I want ...

2 replies Last reply on 7 May 2013 by
matcooper

Conditional formatting vb

Hello, I wonder if you can help me please? I have an excel 2003 document which requires more than 3 conditional formats, i am using this piece of...

4 replies Last reply on 7 May 2013 by
TrowaD

Macro

Hello, I need to insert a multiple rows according to the count mentioned in column d. for example column A,B,C,D contains the data in Column D...

5 replies Last reply on 6 May 2013 by
Zohaib R

Excel macro to create new worksheet

I have a invoice tracking spreadsheet, which I would like to update to highlight overdue payments in a new worksheet. I would like the spreadsheet to ...

7 replies Last reply on 6 May 2013 by
Zohaib R

Inserting pictures into excel based on file name

Hi, I found the below macro on another thread and used it successfully to insert pictures into Column A based on file names in Column B. Howeve...

5 replies Last reply on 6 May 2013 by
fantomvv

Searching and copying

Hello, I am working on patent data and now I need a macro to transform the text to table. There are 30267 patent and it cannot be done by hand. One...

1 reply Last reply on 4 May 2013 by
rizvisa1

Replace charecter string with leading character

Hello, I'm working on an extremely large catalog project where I'm basically taking one column of text and breaking it up into several different c...

4 replies Last reply on 4 May 2013 by
rizvisa1

Creating an if function using dates

 Solved

Hello I am trying to formulate an if function, should the date in the cell be less than six months old from today's date the font is red, should the ...

4 replies Last reply on 3 May 2013 by
Kevin@Radstock

Extract data from other spreadsheets in the same document

Hello, I have about 100 sheets with different names in my excel document. I am trying to extract two numbers for each sheet into a summary sheet....

2 replies Last reply on 2 May 2013 by
luigi206

Outlook 2007 using windows 7 home premium os ...

 Solved

Hello, I've not been able to SEND e-mails, only receive them. Outlook 2007 continues to try to send an item from the 'outbox' to no avail; then iss...

4 replies Last reply on 1 May 2013 by
mariapeter

Unable to send email. outlook 10.

Hello, Suddenly unable to send emails from either of my two computers for two days now (Outlook 10). Sitting in my outbox and cannot get them to mov...

3 replies Last reply on 1 May 2013 by
mariapeter

Sum numbers in a column by corresponding number

Hi there My question basically boils down to payment / invoice match. In one column I have amounts (paid or invoice - often one payment will inclu...

3 replies Last reply on 30 Apr 2013 by
sgmpatnaik

Unable to copy selected cells after apply autofilter function

 Solved

Dear All, I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When...

4 replies Last reply on 30 Apr 2013 by
stonehendriks

Spellnumber for excel

Hello, Good day to all. I have this problem about supplying automatic spell number in writing checks. Actually, I already have seen so many ways ...

1 reply Last reply on 30 Apr 2013 by
sgmpatnaik

Num convert to text in excel 2007

 Solved

R/Sir, As per your instruction i have done how to num convert into words.But i have face a problem when i have writeen above 99999, than num co...

1 reply Last reply on 30 Apr 2013 by
sgmpatnaik

Warn the user of empty cell and indicate the location based on v

Hello, I am new to VBA. I have a problem which I believe is very simple, but I am failing foolishly. I have to generate a MsgBox warning the user t...

3 replies Last reply on 30 Apr 2013 by
Zohaib R

Calculate average $/hr by pulling data from two workbooks

Hi, I have been researching trying to figure out how to do some data manipulation with VBA, I have been going nuts trying and failing at making this w...

1 reply Last reply on 29 Apr 2013 by
sgmpatnaik

Problem sending emails from outlook

Sometimes I live in the UK and sometimes in France. When working in the UK, using a landline wireless network Outlook works fine. When in France, I...

2 replies Last reply on 29 Apr 2013 by
Johnaitch

Search for text in multiple tabs and copy result

Hi. Help needed please. I have a 2010 workbook which tracks income and expenditure, by month, for a small voluntary organisation. I want to be able...

4 replies Last reply on 29 Apr 2013 by
venkat1926

Need help sending automated email in excel

Hello, I need help. I am a rookie to excel and I would like excel to send an email everytime there is a change made to the drop down cell of my ex...

1 reply Last reply on 29 Apr 2013 by
sgmpatnaik

How to add day automatically after giving the date

Hello, Please tell me the formula that i want that days are automatic displayed when enter any specifica date. For example if i write in excel...

6 replies Last reply on 29 Apr 2013 by
sgmpatnaik

Create new sheet,rename and allow duplicates numbering them sequ

I have a workbook with 3 worksheets. 1) MENU 2) Arrears Report 3) NEW ACC and a button on the menu sheet with the following macro below The pro...

3 replies Last reply on 27 Apr 2013 by
rizvisa1

Sum a range of values only if it has certain value

Hi, I need a formula to sum the values in a column but only for the cells in the next column that have a specific value. In my case I have range o...

3 replies Last reply on 26 Apr 2013 by
Zohaib R

Looking for formula.

hi looking for a formula to combine two worksheets in one both have 3 columns. if i copy the both worksheet in one than i have 6 columns like this. ...

1 reply Last reply on 23 Apr 2013 by
Zohaib R

While pasting the un protected cells became protected an locked

Hello, I made A excel work book called (Customer Daily balance) to be used by my Employees(users), this sheet is calculating the recent balance o...

2 replies Last reply on 23 Apr 2013 by
TrowaD
Results 4651 - 4700 out of a total of 12,258