The discussions

Excel macro error

I recently tried this macro to make a cell in excel blink but it gives me an error. Our of range error 9 This is the macro Dim NextTime As Date ...

4 replies Last reply on 3 Sep 2013 by
TrowaD

Time formulla use in excell

i use excell 2007 i want to use time formula in excel example for timeshit i enterd my company 7:00 am and i exit my company 23:00pm its autmatic ca...

1 reply Last reply on 3 Sep 2013 by
venkat1926

Formula to show a value in a cell if another cell has a value

Hi ............ Sheet 1 - shows a value of "Y" in A5 Sheet 1 - shows a date value in A1 Sheet 2 - A1 destination cell "Sheet 2 A1" needs to sh...

4 replies Last reply on 2 Sep 2013 by
venkat1926

Changing the format of a cell based on another cell with text

Hi There. I've spent about 4 hours trying to work out the formula or what I'm doing wrong to no avail, please help me before I lose my mind. I need ...

1 reply Last reply on 1 Sep 2013 by
Kevin@Radstock

How to get numeric value in to text?

Example: In Excel sheet Cell A1 has 125 numeric value. So I want to convert this into Cell B2 as One Two Five. PLease give the solution/form...

1 reply Last reply on 31 Aug 2013 by
venkat1926

Window software

how to install window software on my windows7 basic

1 reply Last reply on 29 Aug 2013 by
BunoCS

Excel formula output text which includes date

Hello, My problem is that I would like the cells that are included in my text to return in the format of a date. =IF([cell]="","",""&[cell]&" - ...

9 replies Last reply on 27 Aug 2013 by
TrowaD

Excel macros

Hi, I need a code for checking 2 columns with another set of two columns and display the corresponding 3rd column. Let me put in example. column...

1 reply Last reply on 26 Aug 2013 by
TrowaD

V lookup

Hai am joseph ,Please send how to use Vlookup formulas in excel, Your website is very useful for me & this is excellent .

1 reply Last reply on 26 Aug 2013 by
RWomanizer

Microsoft publisher - product key

Hi I just downloaded Microsoft Publisher and now I need the Product Key to open it. What do I do?

1 reply Last reply on 23 Aug 2013 by
ac3mark

Kies -- step one

I'm pretty dumb, never used Kies before except on initial installation to get my Samsun SII up and running. I have Outlook and I bought CompanionLink...

1 reply Last reply on 23 Aug 2013 by
BunoCS

Excel macro help, hiding columns

 Solved

So I'm trying to figure out an Excel macro that would hide row A-K on every worksheet in a workbook. Thanks for any help

3 replies Last reply on 22 Aug 2013 by
Usama

Macro to export systematically to master spreadsheet

Hi Guys, I'm quite new to excel macros, a little help would be much appreciated! I am stuck on this problem: every quarter we receive an excel fil...

1 reply Last reply on 22 Aug 2013 by
TrowaD

Need full row if coulam has figures

Can anyone help me plz . I need full row Seprately in second sheet if coulam has figures in cells

1 reply Last reply on 22 Aug 2013 by
TrowaD

My outlook 2007 gmail working for mail send and received but not

Hi, my outlook 2007 gmail working for mail send and received but not get my previous send items in outlook2007. kindly provide solution Thanks

1 reply Last reply on 22 Aug 2013 by
Zohaib R

Excel if formula

Haven't used Excel in quite some time so this is pretty beginner. I just want to make a formula that turns a cell a different color based on the date...

1 reply Last reply on 21 Aug 2013 by
ac3mark

Create a macro

Hello, Please help. I am hoping that someone will be kind enough to adapt this macro that I can run each month that will return the following infor...

8 replies Last reply on 21 Aug 2013 by
louannc

Need help to create an excel macro (combine columns)

 Solved

Hello, Inputs Col A and Col B ( all data ranges are variable), need out put in C Col. (MACRO), I not good at vba/e , kindly help. Col A ...

3 replies Last reply on 20 Aug 2013 by
ac3mark

Add two type mix font in one cell in excel 2003

 Solved

hallo i have a excel 2003 userform with textbox . I have problem in my data base . I have 2 type font in my data like DevLys 010 and arial. I want to...

9 replies Last reply on 17 Aug 2013 by
aptpsbwmraj

Finding missing data in column

Hello, I have two columns of data column A and column B. There is data in Column B that does not exist in Column A. I am trying to use a formula...

2 replies Last reply on 17 Aug 2013 by
venkat1926

Configuring microsoft outlook for yahoo mail

Hi, Can someone give me the step by step process of configuring outlook with yahoo mail? Thanks

1 reply Last reply on 16 Aug 2013 by
Crashounette

Recurring date formula

 Solved

Hi All I have the following formula in my worksheet =IF($AA$2=2,B8+28,IF($AA$2=1,B8+7,IF($AA$2=3,EDATE(B8,1),IF($AA$2=7,EDATE(B8,12),IF($AA$2=4,...

10 replies Last reply on 15 Aug 2013 by
MRafik

Cant format date in excell

 Solved

Hi, When I enter the dates as number with out forward slashes, and format them by right clicking on format cells and choosing date the date appear...

5 replies Last reply on 15 Aug 2013 by
imran123

Lookup same entry a1 in 2 worksheet & return b1 from 2nd w/sheet

 Solved

Hi, I have 2 worksheets. "Master" = Sheet 1 "Status" = Sheet 2 In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1-Status...

1 reply Last reply on 14 Aug 2013 by
ozetrezure

Trouble with if/or function in excel

Hello all! I'm hoping you can help me with a problem I'm having. For reference, I have Excel 2008. My goal is to write an IF/OR function. The funct...

1 reply Last reply on 13 Aug 2013 by
ac3mark

Macro to create new excel when last row is filled

Hi, The data will be automatically filled in my excel sheet and it will be more than 1500 rows. now i want a macro that automatically create a new ...

7 replies Last reply on 13 Aug 2013 by
TrowaD

Copy and paste range of cells in xcel

I would like to copy an paste a range of cells (A1 - A15 )in Xcel to the same row and be given the option to specify the amount of iterations of this ...

2 replies Last reply on 12 Aug 2013 by
TrowaD

Macros to insert rows defined in column "x"

Hi, I m new to macros, need your help to create macro per my below requirement... Eg.. Value updated in column "A" is 10 so it should add 10 new...

6 replies Last reply on 12 Aug 2013 by
TrowaD

Macro on a pivot

Hi I have been trying to find a macro that copies a cell and pastes into a number of cells beneath it until it reaches another cell that has data, ...

5 replies Last reply on 12 Aug 2013 by
TrowaD

Can this be done?

Hello, I have a spreadsheet that I created with the help of ac3 mark. Thank you Again. It works well and now i would like to see if i can add mor...

1 reply Last reply on 10 Aug 2013 by
ac3mark

Macro range

 Solved

Hello, I am somewhat inexperienced in the world of macros in excel. I have a looping macro that runs from the bottom and i want it to stop at ...

4 replies Last reply on 10 Aug 2013 by
venkat1926

I am just learning the basics

 Solved

Hello All, I am new to this community. I have just started learning Excel and am having a problem with a formula. the community here from what I have...

10 replies Last reply on 8 Aug 2013 by
ac3mark

Formula help

Hi, I'm looking for a formula for the following scenario: Worksheet 1 Cell A 129622 Worksheet 2 Cell A Cell B Cell C 129622 1,000 35 ...

1 reply Last reply on 8 Aug 2013 by
ac3mark

Adding a formula

Hello, how do i may be able to get auto deduct formula from a sum method of multi cells ? Thanks

3 replies Last reply on 8 Aug 2013 by
ac3mark

Conditional format based on two criteria

Hello, Can someone help me please with a conditional format that would highlight an entire Row in 2010 if Column B on my spreadsheet has any one o...

4 replies Last reply on 8 Aug 2013 by
TrowaD

Conditional formatting using a formula

I would greatly appreciate any and all help, please and thank you so much in advance! I am trying to create a conditonal format on a row of cells b...

7 replies Last reply on 8 Aug 2013 by
TrowaD

Unlock a microsd card

Hello, my 1 GB MSD CARD is locked due to password error, means I have forgot password. plz help me how to unlock it? Configuration: Window...

1 reply Last reply on 8 Aug 2013 by
ac3mark

Convert numbers to words in excel

 Closed

Hello, please give me the formula for converting numbers into words not not into currency and it should be like when I type a number such as 400 i...

Last reply on 8 Aug 2013 by
venkat1926

Create a macro

 Solved

Hello, Please help me. I am new at macros, and I need to create a macro that will automatically total a column as below: # Name ...

3 replies Last reply on 8 Aug 2013 by
venkat1926

Need help with an if function

 Solved

So, I am trying to get this formula to work. The situation is that one of our items have changed names. In the spreadsheet, I am trying to get a f...

4 replies Last reply on 7 Aug 2013 by
AY44

Convert number to word in excel

Hello, i want a number to be converted to word in excel such that if i enter a number as 600 it should show as six zero zero please help me sir ...

1 reply Last reply on 7 Aug 2013 by
ac3mark

Excel date problem

 Solved

Hi, How can I change the date format from a format such as 22042013 - (this is not a text format). One formula I have been given is: =IF(LEN...

6 replies Last reply on 7 Aug 2013 by
Nydee

About the vba

Hello, Im Kumar and would like to knoe how to setup the VBA in a snapshots. it would be more thankfull if u provide me the snapshots

2 replies Last reply on 6 Aug 2013 by
Kumar69

Downloaded pdf files not visible

Windows Vista Home Premium IE 8 Occasionalyy, after I download a PDF file using Nitro PDF, I cannot see the file. The file download completes, but...

2 replies Last reply on 6 Aug 2013 by
Kino-S

Any part of string in cell matches part of string in another

 Solved

First post after hours of fruitless googling :-) Working in Excel 2010.. I have merged two data sets and where there are instances of exact dupl...

9 replies Last reply on 6 Aug 2013 by
Scr33nager

Creating new sheet and transferring data to new sheet

With due respect I would like to have some Guidance for creating a excel sheet. My sheet is Date name in out time. This sheet contains 746 rec...

3 replies Last reply on 5 Aug 2013 by
TrowaD

Inserting multiple rows with copy and paste the existing data

Hi The below code works fine with inserting new rows but I need an extension of the code to incorporate copy and paste function on the existing ro...

3 replies Last reply on 5 Aug 2013 by
TrowaD

Help please with calculating large data in pivot table

Dear Sirs, Can some one please help me with creating a better Pivot Table in Excel 2010. I work for an automotive company and so have to track all...

1 reply Last reply on 5 Aug 2013 by
TrowaD

Conditional formatting can't caputure text...need vb code please

 Solved

Hello, I understand i can't use c formatting to insert text and therefore am looking for a piece of code that will perform the following. Consi...

6 replies Last reply on 5 Aug 2013 by
Mounta1n

Conditional formatting based on changing dates

 Solved

I am trying to keep on top of dates that are changed weekly based on last weeks dates, but i need to highlight the changed cells only. Example: ...

4 replies Last reply on 5 Aug 2013 by
SpaceMonkees
Results 4451 - 4500 out of a total of 12,267