The discussions

Different currencies

 Solved

Hello, could you please advise what could be the best way to show in the same table different currencies. Lets say there would be a button which w...

8 replies Last reply on 30 Mar 2013 by
DG83

Vba lookup

Hello, I currently have a macro built that takes a value from a specific cell and looks against a lookup table in another work sheet. If the valu...

6 replies Last reply on 29 Mar 2013 by
froggy6703

Nested if formulas with times not caclulating correctly

I have several start/end times and need to also calculate the difference in minutes of those times on occasion. START A END A ...

2 replies Last reply on 29 Mar 2013 by
Kevin@Radstock

Formatting dates

Help! I need to do a vlook-up between two workbooks with the date being the common between the two. The problem is that the date is formatted in a ...

4 replies Last reply on 29 Mar 2013 by
Zohaib R

Selecting columns in excel

Hello, I tried to select a range of cells in excel 2010, using Range("A:H").Select But this selects the whole worksheet. I have tried different w...

2 replies Last reply on 28 Mar 2013 by
Zohaib R

Outlook is not responding to in/out mails

Hello, am using official domain.com mail with outlook but all my mails are not going out neither am i receiving mails. can anyone help me on this ...

2 replies Last reply on 28 Mar 2013 by
mariapeter

Outlook 2007 does not send all emails

Hello, Outlook 2007 does not send all emails in the outbox. I reset send/receive to send and receive every 5 minutes on and offline; it did not work....

2 replies Last reply on 28 Mar 2013 by
mariapeter

How to convert number to word

Hello, ow to fix it in excel always. I get it result only when apply it. but can not fixed. please how can I fixed (Permanently Save) in my computer...

4 replies Last reply on 26 Mar 2013 by
rizvisa1

"remove duplicates" macro gives error on protected worksheet

Hello, Configuration: Windows 7 / Firefox 19.0 I have a macro that sorts and removes duplicates from a fixed selection in a single column. ...

1 reply Last reply on 26 Mar 2013 by
Zohaib R

Animated ppt templates

 Solved

Hello, can you tel me the website of animated ppt templates???plzzz Configuration: Windows XP / Opera 9.80

4 replies Last reply on 26 Mar 2013 by
Royal Diamond

Macro: copy row to another header or sheet from a drop down

Hello, I am creating a spreadsheet which contains a drop down list of categories. I am looking for a solution so when a category is selected it wi...

2 replies Last reply on 26 Mar 2013 by
VTUK

How to compare data in multiple columns

Hello, I have the below data in four columns 14 25 36 214 14 785 114 2563 I have to find out if any two value from the c...

1 reply Last reply on 26 Mar 2013 by
TrowaD

Changes on a pdf document

 Solved

Good morning Please can you advise how to make changes on a PDF document that was send to you via email need to change some text

2 replies Last reply on 25 Mar 2013 by
rizvisa1

If function with dates

 Solved

Hello, I'm trying to compare cells with dates. For example: column A column B column C Mar-25 Apr-3 ? In column C I need a...

2 replies Last reply on 25 Mar 2013 by
ukie113

Pop up message stating empty cells

 Solved/Closed

Hello, I am relatively new to VB and I am trying to help a friend build an application form for work. Basically what I am trying to do is, there ...

7 replies Last reply on 25 Mar 2013 by
shalom1506

Getting and error msg "the file you are trying to open "xxx.xls"

Hi folks, getting and error msg "The file you are trying to open "xxxxx.xls" is in a differernt format than specified by the file extension. Verify...

1 reply Last reply on 24 Mar 2013 by
rizvisa1

Help set up my browser

Hello, Is my bowser set up.with this yet? I want to start my blogging Job,please help. I have a Visual Land tablet.If that will help. Config...

1 reply Last reply on 23 Mar 2013 by
xpcman

Dates change when copying...

 Solved

Hello, Thanks to this kind of forum, I've been able to deal with issues around the date systems 1900 vs 1904. It remains a problem though since ...

2 replies Last reply on 23 Mar 2013 by
NgangaKP

Need a macro which copy values from rows and paste into a table

Hello, Actually I have a payroll in Excel. Each employee's salary detail is in a row. eg S# Name Basic Allo1 ...

1 reply Last reply on 23 Mar 2013 by
rizvisa1

Copy row based on value of cell, and update row data back

Hello, I have 3 sheets, "WHOLESALE", WEB SALES" & "ORDERS". If "WHOLESALE" or "WEBSALES" have a value "SPECIAL" in Column "A", it must copy th...

1 reply Last reply on 23 Mar 2013 by
rizvisa1

I would like to compare 2 columns.

 Solved

Hello, I would like to compare 2 columns A to F, if the value is the same I would like to populate the value of column C with the value from Colum...

13 replies Last reply on 22 Mar 2013 by
Zohaib R

How to do an automation for copy paste, added new row (macro)

 Solved

Hello, I have attached file http://www.sendspace.com/file/wjh0oe I want to automated a some step (tab table Z) Thus, for example, that in X 201...

11 replies Last reply on 22 Mar 2013 by
jpppol

Kindly request for excel help in cell formating

Hello, Configuration: Dell laptop with vista If you have some time, can you please try to help me, I would greatly appreciate any help ...

3 replies Last reply on 21 Mar 2013 by
Zohaib R

Formula help needed

 Solved

Hello, I am in need of a formula. I own a business in which I receive payments from my clients in various ways. I also have multiple locations...

9 replies Last reply on 20 Mar 2013 by
cromwelld

Updating multiple sheets from a master sheet

Hello, Please, how do I create a mapping between multiple sheets and a master sheet all in the same workbook? I have at least 400 sheets and ther...

1 reply Last reply on 20 Mar 2013 by
Zohaib R

Dj setup

Hello, I want to buy SVM-1000 / 2xDVJ-1000 setup Do you have this ? and 220V ? Your addres plz . Thanks Configuration: Windows 7 / Chro...

1 reply Last reply on 20 Mar 2013 by
Ambucias

Entering value for column at once, displaying in all sheets

 Solved

Hello, I have a workbook with multiple sheets(1,2,3) , each sheet has list of items randomly placed, the same items are repeated in other sheets ran...

1 reply Last reply on 20 Mar 2013 by
Zohaib R

Import files into excell 2003 from path

Hello, I would like to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path t...

1 reply Last reply on 19 Mar 2013 by
rizvisa1

Help combining worksheets in excel 2007

 Solved/Closed

We use excel 2007 to store information about our products and have a different worksheet for each range. Is there any way of combining all these wo...

12 replies Last reply on 19 Mar 2013 by
rizvisa1

Conditional formatting

 Solved

Hello, I need a help on Conditional formatting: I have a data in A2:E5 (Sheet 1), and in Sheet 2 i have reference data in Column A. i need to...

2 replies Last reply on 19 Mar 2013 by
Matheswaran

Use of formula

Hello, l try to add up figures with vat but l coudn't get de total thanks. Configuration: Windows 7 / Firefox 19.0

1 reply Last reply on 18 Mar 2013 by
Zohaib R

Inventory

 Solved

Hello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...

6 replies Last reply on 17 Mar 2013 by
Ashley

Vba how to create new worksheet and move value

 Solved

Hello there, I am zero in vba, can anyone please assist me what code to be used given following conditon Given,(I have data converted from csv t...

5 replies Last reply on 17 Mar 2013 by
rizvisa1

Have to update data from one sheet to other sheet automatically

Hello, I have four excel sheets , in which some field names are similar. When i update a common field in one sheet i want other sheets to update ...

3 replies Last reply on 16 Mar 2013 by
rizvisa1

Format range of cells based off another range of cells

Hello, I have a set of values in column $A. I want to format cells in columns $B:$Z to be red if any of their values are equal to any values in co...

3 replies Last reply on 16 Mar 2013 by
rizvisa1

Excel, if / then or is there a better way?

Hello, I have a spreadsheet that lists each kid in my class. I have entered the answer they gave for each and every question on a 40 quesiton test....

2 replies Last reply on 16 Mar 2013 by
rizvisa1

Project 2007

Hello, I have just downloaded project 2007 from this site but I need a product key to activate it. Can anybody help me with this? TNX, Tekii...

1 reply Last reply on 16 Mar 2013 by
rizvisa1

Password macro help

Hello, I have a code that unlocks sheets I need to use that are password protected but I have other code I used to combine the worksheets into 1 w...

1 reply Last reply on 16 Mar 2013 by
rizvisa1

Vb how execute code for each file open & open multiple files

Hello, The top half is code for opening my file. I tried opening multiple which seems to open but not execute the code I want ran for each file. I'm...

5 replies Last reply on 15 Mar 2013 by
rizvisa1

Copying and pasting images without the white background

Hello, i have microsoft excell and im trying to coppy and paste an image from the internet my picture folder but i copy to excell first then save...

1 reply Last reply on 15 Mar 2013 by
rizvisa1

Facing difficulties in implementing charts

I have file1, file2, file3 and I want to have a chart with each's G column from 2 to final and each's I column from 2 to final. G in X axes and I i...

1 reply Last reply on 15 Mar 2013 by
rizvisa1

Excel macro

Hello, I need a help in using the excel macro I have designed the Userform for searching the particular value from the excel.By typing the valu...

2 replies Last reply on 15 Mar 2013 by
rizvisa1

Compare two columns in different sheet and retrive corrspo value

Hello, How to compare two columns in one sheet with that of two columns in other sheet and retrive the corresponding Key value of the third column...

1 reply Last reply on 14 Mar 2013 by
Zohaib R

Excel macro; adding password

 Solved/Closed

Hello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do so...

13 replies Last reply on 13 Mar 2013 by
Pujdo

Summing up data from groups & pasting it another column

 Solved

Hello there, I need to write a macro for the following example: A 2 A 3 A 3 B 4 B 1 B 4 C 7 D 3 D 8 Etc. Basicallly i ne...

3 replies Last reply on 13 Mar 2013 by
rizvisa1

Special sum of a column

 Solved

Hello, In have some columns with plenty of data. And I need to make a column which will have ... D2=C2 D3=C2+C3 D4=C2+C3+C4 ....................

3 replies Last reply on 13 Mar 2013 by
rizvisa1

Number to word

Hello, i want to covert number in to word like 1000(one thousands) 100 (one hundred) Plz help me to convert number to word in this format Conf...

1 reply Last reply on 13 Mar 2013 by
rizvisa1

Comparing data in multiple excel worksheets

Hello, For work, I was given an excel document with a different worksheet for each month in 2012. Clients can come to our food pantry one time in ...

1 reply Last reply on 12 Mar 2013 by
Zohaib R

Calculation of time

Hello friends Pls help me to calculate time in excel. Time value is A1 is 15:25. I have to subtract 11:30 hrs from A1 and doing calculation lik...

11 replies Last reply on 12 Mar 2013 by
Zohaib R

Formula not opened new excle

Hi Dear All Really thanks for this and this function is working well but that working only in formula contained not in all if i opened newly , ple...

1 reply Last reply on 12 Mar 2013 by
rizvisa1
Results 4751 - 4800 out of a total of 12,258