The discussions

Multible vlookups

Hello, all Hope you can help, I have a list of colums. HR Category Junior Senior Consultant R 80.00 R 100.00 Analyst R 80.00 R...

2 replies Last reply on 1 Aug 2011 by
Stormdronk

Calculate the hours per bed in a week

 Solved

Hello, I need a formula to calculate the hours per bed in a week divided by average occupancy rate. Which formula I should use? Many thanks! ...

1 reply Last reply on 1 Aug 2011 by
TrowaD

Excel data comparison and copy data

Hello, Sheet1 details A:employee no (employee no appear more than once) (a2:a5720) B: name C:address1 D:address2 E:address3 F:address4 G:pin ...

1 reply Last reply on 1 Aug 2011 by
venkat1926

Put a loop for the code which insert pictures

Hello, Please i'm using Microsoft excel 2010 and need to do this code as a loop and if all the pics are inserted then the loop should break. Co...

1 reply Last reply on 30 Jul 2011 by
rizvisa1

Mail merging from excel to excel

 Closed

Hello and Good morning Everyone. I will appreciate your expertise on this question because I have tried attempting several avenues and still didn't...

4 replies Last reply on 30 Jul 2011 by
rizvisa1

Copying & "freezing" conditional fo

 Closed

Hello, In Excel, I am tryng to copy range of cells that have conditional formatting to another sheet. is there a way to do so while prserving thei...

5 replies Last reply on 29 Jul 2011 by
Trackman51

Sharepoint link to excel via a cell variable

 Solved

Hello, Configuration: Windows XP / Internet Explorer 7.0Hello, Wonder if any of you gurus can help with the following, as it has got me totall...

38 replies Last reply on 29 Jul 2011 by
Dave122

If functions with time functions

 Solved

Hello, I am trying to combine several IF conditions but ir appears that they are always getting an error, can someone help me? The formula is a...

5 replies Last reply on 28 Jul 2011 by
rizvisa1

Not sure how to use if then statements or

Hello, I have data in Column M and if it finds exact values I entered below then Put the following text in next Column "N" (be the same row ). But...

4 replies Last reply on 28 Jul 2011 by
rizvisa1

Excel, equating 2 columns formula

Hello, I'm trying to take 3 columns and make them a bit neater. Say column A came from a customer listing such things like Apple, Orange, B...

1 reply Last reply on 28 Jul 2011 by
rizvisa1

Reading differrent excel sheets

Hello guys, I have to consolidate the data from different excel sheets (+/- 20/ files) from differrent excel files (20) how can I do it quickly in ...

8 replies Last reply on 28 Jul 2011 by
rizvisa1

Macro to capture timing

Dear All, Can anyone please assist me in composing a macro to capture the break timing of my team members. Am desperately in need of this macro to...

5 replies Last reply on 28 Jul 2011 by
rizvisa1

Remove "calculate" from excel.

 Solved

Hello, When opening a saved sheet with data in excel,I get to see "calculate" mentioned on the bottom left. The problem is when this "calculate" i...

3 replies Last reply on 28 Jul 2011 by
raj

I have forgat may mobile's m card password

Hello, My name is Rohit Dhiman. I have forget my mobile's memory card password.so kindly tell me the resolution for that. Rgds Rohit Dhiman...

1 reply Last reply on 28 Jul 2011 by
pcsces

Forgotten windows admin password

Hello, I have forgotten my password for my Windows Compaq administrator account. I really have no way of getting in because I didn't make a disc, t...

1 reply Last reply on 26 Jul 2011 by
Ambucias

Excel/vba 2010 continue with macro

 Solved

Hello, Just a quick question I've got a Macro that runs perfectly except there are two times while it runs where it stops and asks you to click Ok...

3 replies Last reply on 26 Jul 2011 by
RWomanizer

Excel to excel mailmerge, is it possible?

 Closed

I have a list of names, with their room numbers, acct. numbers, birthdays, and addresses in excel (roster.xls). Every week, I had to print several ...

1 reply Last reply on 26 Jul 2011 by
RWomanizer

Tally vat% chaning

Hello, ho to change tally vat % from 4% to 5%. help me plz...

3 replies Last reply on 25 Jul 2011 by
TrowaD

Help with finding a pasword

 Solved

Hello, I have a Acer Extensa 5220 and my XP stops by the account and asking for repair. I can't do that because my BIOs setup ask for a password Aft...

1 reply Last reply on 25 Jul 2011 by
bionik

A password on local disk

Hello, how can I remove the forgot password of my local disk (c:) in window 7 please help me!! Configuration: Windows 7 / Firefox 3.0

1 reply Last reply on 25 Jul 2011 by
pcsces

How to reduce the pdf file size 14mb to 533kb

Hello, I have a pdf file in 14 mb. I want reduce the size of pdf to 533 kb. If any have the answer plase let me know. Thanks. Configuration: ...

2 replies Last reply on 24 Jul 2011 by
bionik

Forgot security password

 Solved

Hello, Please help me i forgot security password of nokia mobile Mobile Model No: 1200. EMI No: 356816025146415. Configuration: Mac OS X ...

1 reply Last reply on 23 Jul 2011 by
bionik

Vba code did't open workbook

Hello, I'm having a major headache in figuring out why the VBA code which I'm applying at my office computer seems to work perfectly but fail to w...

2 replies Last reply on 22 Jul 2011 by
rizvisa1

Vba conditional formatting excel 03

 Solved

Hello, How can i apply a conditional format on a certain cell but with the condition in a different cell. F.e. if a cell in range C1:D5 (f.e. C...

1 reply Last reply on 22 Jul 2011 by
TrowaD

Conditional hide column

 Solved

Hello, I need someone to help me please. I want a VBA code in excel that will look to a value in specific cell (i.e: A1) in one sheet only and i...

2 replies Last reply on 21 Jul 2011 by
issa

Forget password in lock folder

Hello, Acutely I create some password in folder. But I forget Password Lock Folder. Note. Folder Files are very importent. Plz. Solve the ...

1 reply Last reply on 21 Jul 2011 by
bionik

Word with hyperlinks conversion to pdf

 Closed

Hello, I would be grateful if anyone can help me solve this problem. I am trying to convert a word doc with hyperlinks into a PDF and the hyperli...

1 reply Last reply on 21 Jul 2011 by
velveteen

How can configure my outlook express.

 Closed

Hello, sir my self is priyanshu tyagi.I have not configure my outlook express in my i.d Email Id removed for security windows xp ...

4 replies Last reply on 20 Jul 2011 by
Joe J

Transfer from one excel sheet to another..

Hello, I have an excel sheet (Sht1) with data in one format - A2,B2,C3,D2 A3 A4 A5,B5,c5,d5 A6 A7 A8,B8,C8,D8 A9 A10 I need to trans...

10 replies Last reply on 19 Jul 2011 by
rizvisa1

Excel 2007 - deleting the last three rows

Hello, I am looking for a formula to put into a macro that will scan to the last three rows with data/ information and delete them. Thanks,

3 replies Last reply on 19 Jul 2011 by
rizvisa1

Macro/ vba forumla help-deleteing entire rows

Hello everyone, In Excel 2007... I'm looking for a function/ macro/ VBA formula that can assist me in scanning one set column (but the numbers v...

6 replies Last reply on 19 Jul 2011 by
dumow880

Password forget

hi password forgetted pls sol;ve the problem

1 reply Last reply on 19 Jul 2011 by
pcsces

Microsoft office home & student 2010 licence

Hello, Will microsoft consider my copy of Office pirated if have only one working copy of office at a time? Scenario: I am planning to upgrade...

2 replies Last reply on 15 Jul 2011 by
Devrath

Excel 2007 - macros

 Solved

Hello, I need to write a macro for following example. Item Qty c 2 B 2 b 6 C 5 c 5 a 2 Basically I want to group by Column A (i....

4 replies Last reply on 15 Jul 2011 by
rizvisa1

Old password macro sd card

Hello, plz recover the my memory card old password macro sd card

1 reply Last reply on 15 Jul 2011 by
pcsces

Excel macro formula to sum column

 Closed

Hello, I need help with a macro please. I need a code to sum up Column E from line 3 to the end of the data. The formula needs to be in the cell r...

2 replies Last reply on 15 Jul 2011 by
sos

Enter a password

 Closed

Hello, My dell desktop froze up one day and will not restart. When I turn the power on it don't try to start up or boot instead it say's enter passw...

1 reply Last reply on 14 Jul 2011 by
RWomanizer

Outlook

 Closed

Hello, I have recently been getting slow reponses form my PC in general and it then results in Outlook performing a send/receive on opening that d...

1 reply Last reply on 14 Jul 2011 by
Ambucias

Excel 2007

Hello, I have a table that lists historical rates of returns for years between 1901 to 2010. I'd like to create a table that 1) will list each year...

3 replies Last reply on 13 Jul 2011 by
rizvisa1

Add two cells if one cell is not blank

Hello, I want to add E9 and D10 if D10 is not blank (or is greater than zero), whichever is best. Can anyone help please? Configuration: Wi...

1 reply Last reply on 13 Jul 2011 by
rizvisa1

Forget mobile tracker password

 Solved

Hello, Sir *2767*3855# *2767*2878# this code not working on Samsung 3310 metro mobile..please help me..... Configuration: Windows XP /...

1 reply Last reply on 13 Jul 2011 by
Ambucias

Repeating rows n times & copying

Hello, I have an excel sheet which has a lot of different columns.. what I want is to copy all the rows n number of times and paste it in another...

2 replies Last reply on 12 Jul 2011 by
patattack

I forget micro sd memory card password

Hello, i have forget my mobile nokia 3110c memory card password . pls solve my problem because that not accepted anyother download via computer.>Win...

1 reply Last reply on 12 Jul 2011 by
Ambucias

Highlighting and copying in excel

 Solved

Hello, I am just starting on visual basic and would like to record a macro whereas, once I have pressed play, Excel will select a cell 12 rows dow...

2 replies Last reply on 11 Jul 2011 by
DannyBoy

Please help me to revise the macros

Hi, The below macro is composed to capture the start time and end time of a employee. When i run the macro, the start time and end time is captured...

1 reply Last reply on 11 Jul 2011 by
rizvisa1

Printing excel sheet with jumbled columns

 Solved

Hello, Dear all, I have a typical question. I have a work sheet in excel 2007 with some headers in columns from C8 to N8 the columns C to F have t...

2 replies Last reply on 11 Jul 2011 by
suryam

Excel/vba 2010 - searching for wild cards

Hello, I'm wondering if it is possible to write a code that will search for wild cards. For example: we have a pattern of numbers that come up in ...

8 replies Last reply on 10 Jul 2011 by
whitepanther

Variable sharepoint link into excel

 Closed

Hello, Configuration: Windows XP / Internet Explorer 7.0 Looking to allow a cell value to dictate a link to a spreadsheet in Sharepoint. S...

1 reply Last reply on 8 Jul 2011 by
Ambucias

Vba macro matrix multiplication with a scalar

 Closed

Hello, I've been struggling with what should be a simple operation using Excel VBA and was hoping someone could please help me out. Basically I hav...

6 replies Last reply on 8 Jul 2011 by
MANMANI

How do i delete supervisor password

Hello, How do I del supervisor password..I have set a supervisor password at bios..I know the password..but i want to del it...i can change it...b...

1 reply Last reply on 8 Jul 2011 by
pcsces
Results 6101 - 6150 out of a total of 12,258