The discussions

Copy data from one sheet in a workbook to another sheet

Hi, I'm trying to copy one sheet automatically in one workbook to multiple workbooks. For example the workbook is May 2015 Sales Numbers and the S...

1 reply Last reply on 7 May 2015 by
MaxStart

Get a percentage in microsoft excel

 Solved/Closed

Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...

Last reply on 7 May 2015 by
kb

How to use name range..please help to solve this issue..

 Solved

Hello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...

4 replies Last reply on 7 May 2015 by
Mathewmunna

Automatically syncing data from my master sheet to individual sh

Hi, What would be the procedure for automatically Syncing Data from my master sheet to Individual Artist sheet. I basically would be enteri...

1 reply Last reply on 6 May 2015 by
vcoolio

How to change date in order of dd/mm/yy in excel 10

Hello, I want a solution for this!?! pls Configuration: iPhone / Safari 4.0

1 reply Last reply on 4 May 2015 by
MaxStart

What it mean rs = 7: sheets(f1).select

Hello, im stater excel vba i see this code and im not clear what it mean please any one explain me.

1 reply Last reply on 3 May 2015 by
MaxStart

Pop3 and smtp for yahoo.ca

Hello, What is Yahoo.ca not Yahoo.com mail's incoming mail server (POP3 or IMAP)? And what is the Outgoing email server's (SMTP)name?

4 replies Last reply on 2 May 2015 by
Sir.Raph

Excel master list

Hello, I will be creating a spreadsheet with lots of text data, addresses, phone numbers, names, ect. I have all the data set up in rows so I will j...

1 reply Last reply on 1 May 2015 by
MaxStart

Excel vba input data to next empty range

HI everyone, I am excel vba stater I have crazy problem to solve. I want to input data into range j6 by use inputbox and if j6 had value next input wi...

1 reply Last reply on 1 May 2015 by
MaxStart

Exam layout help

 Solved

Hello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...

8 replies Last reply on 1 May 2015 by
addseo1115

Conditional formatting cell if every cell contains "yes"

 Solved

Hello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...

2 replies Last reply on 1 May 2015 by
LizzyDashwood

I need my reset password

Hello, i dont no my gmail password plz help me Configuration: iPhone / Chrome 30.0.0.0

1 reply Last reply on 1 May 2015 by
mharon

Replacing any alphabet with c, and number with 0 in an alphanume

Hello, I have huge list of alphanumeric string in each row. And I want to replace any alphabet with C, and number with 0 in an alphanumeric. e.g I...

1 reply Last reply on 30 Apr 2015 by
TrowaD

Excel help

I think I need to use multiple formula to find this. I think an If function is used for sure. I need to find a formula that gives me the difference be...

1 reply Last reply on 30 Apr 2015 by
TrowaD

Compare 2 sheets -> summary differences

 Solved

For an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...

4 replies Last reply on 30 Apr 2015 by
SidK

Conditional formatting for a particular column

 Solved

Hello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...

11 replies Last reply on 30 Apr 2015 by
Harish51290

Copy & paste based on specific condition

 Solved

Please provide me the macro coding for the below scenario. I have four columns in my sheet 1 say Date,Name,Reference and Rate. When I am entering the...

53 replies Last reply on 29 Apr 2015 by
Ahmed

How to search for a value in a range if found run a procedure.

 Solved

Hello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...

4 replies Last reply on 29 Apr 2015 by
Tiny

Change the date format in excel 2007 worksheet

Hello, i want to know that howcan i change the date format in excel 2007 worksheet if i want it like :- yyyy/mm/dd regards, Amol. ...

1 reply Last reply on 29 Apr 2015 by
MaxStart

Finding a date (n30) in a date range b5:b30 and returning a3text

 Solved

Hello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...

3 replies Last reply on 29 Apr 2015 by
MaxStart

Removing false word in excel

Hello! How to remove the false word in this formula and retain only the amount instead? =IF(O50,VALUE(M5)) Thanks!

2 replies Last reply on 29 Apr 2015 by
baren91

After pushing command button on sheet1, sheet 2 auto. opens up.

Hello, I have created a workbook with several pages of Information. One of the pages sheet2 ("Order Form") will figure information. There is a ...

1 reply Last reply on 28 Apr 2015 by
MaxStart

Counting the number of times a cell changes colors and archive

Hello, Hello, I would like to count the number of times a cell goes green and archive it. How can I do this? Thank you for any help you can give. ...

1 reply Last reply on 28 Apr 2015 by
MaxStart

Auto. copy a row of data onto another sheet using conditions

 Solved

Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...

8 replies Last reply on 28 Apr 2015 by
Don't Know

Auto populating multiple sheets

Hello, I have read some of the Qs and As and they are scary if you don;t know Excel. ! Is there not a simple formula for entering data into a sp...

1 reply Last reply on 28 Apr 2015 by
MaxStart

Macros to copy conditional data

Hello, I am beginner in macros and am trying a macro code which does the following. I have 2 sheets by name sheet1 and sheet2, sheet1 consists of...

1 reply Last reply on 28 Apr 2015 by
TrowaD

Amexxx1

Hello, I don't seem to be able to run this simple code; I copy and paste but when trying to run in my General tab by pressing alt+F8, no macro is ...

3 replies Last reply on 28 Apr 2015 by
TrowaD

Macro to search for a word and put a code on the cell next to it

 Solved

Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...

2 replies Last reply on 28 Apr 2015 by
A.E

Macro which can be calculated every month rent

I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are differ...

1 reply Last reply on 27 Apr 2015 by
xpcman

Can't open scanned document when broken up into 2 pdf's

 Solved

When I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...

1 reply Last reply on 27 Apr 2015 by
thierryhauet

Search functionality,copy and paste

Hello, I am new to VBA and looking for a search functionality macro.I am looking for three steps;- There are three sheets,in sheet one i just cre...

2 replies Last reply on 27 Apr 2015 by
pinkipanchal

Repair outlook express dbx file

 Solved/Closed

has a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...

Last reply on 26 Apr 2015 by
ruudromein

All my office apps are not showing its icon.

Hello, I am using Office 2013. Now I can only see the windows generic icon instead of the Office icon. I am using the Professional Plus 2013 full ve...

2 replies Last reply on 25 Apr 2015 by
appus2

Send data from raw data sheet to numerous specific sheets

Hello, Trying to make a document in whcih my laboratory can track the reagents coming in. I have a source sheet, where all the recieved reagent...

1 reply Last reply on 23 Apr 2015 by
vcoolio

Copying data directly to a specific sheet

Hi there! I am trying to create a spreadsheet in which I can enter information on one sheet and it automatically carries across that info to the c...

1 reply Last reply on 23 Apr 2015 by
vcoolio

Date format

Hello, i have date format like 20131203 (year month day) i want to change it as 03.12.2013. please suggest Configuration: Windows 7 / Chrome 2...

1 reply Last reply on 23 Apr 2015 by
kieferschild

It can not find the files

Hi i installed your program to fix the corupted files the system can not find the files it dont show in the list how to do that???

1 reply Last reply on 23 Apr 2015 by
Ambucias

A macro to name worksheets based on a list

Hello, btw how to name worksheet without creating new worksheets, i've already have data in each worksheet so i dont need to create a new one.. I ...

2 replies Last reply on 22 Apr 2015 by
nilam28

Macro for blanks

 Solved

Hello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...

3 replies Last reply on 21 Apr 2015 by
vcoolio

Space bar problem

Hello, my space bar shows dots instead of space in word 2007 Configuration: Windows 7 / Mozilla 11.0

1 reply Last reply on 21 Apr 2015 by
TrowaD

Generate id for cells containing same values

Hello, I am trying to generate the same IDs for cells containing same values and different IDs for cells containing different values I have for e...

1 reply Last reply on 21 Apr 2015 by
TrowaD

How do i not get the sum of a column when it contains text?

Hello All, I have an excel file in which I am adding the numbers of a column, but sometimes the column I am summing may have text in one of the cells ...

1 reply Last reply on 20 Apr 2015 by
RayH

Date of birth in words

 Solved

Hello, How can I enter date of birth in words in Excel?

1 reply Last reply on 20 Apr 2015 by
TrowaD

Help with formula to find/remove if same data in another cell

Hello, I am having some trouble determining a formula that would help me with my problem below. I have a large Excel sheet and am hoping you can ...

1 reply Last reply on 20 Apr 2015 by
TrowaD

Converting macro into function

Hello, How to change the below macro into a function, so that, we could invoke this macro as =image() Sub Picture() Range("A6").Select 'This...

1 reply Last reply on 20 Apr 2015 by
TrowaD

Get value of last cell in column b from a closed workbook

Oh Dear - back again... Im trying to improve a macro I have been working on. It works as far as it goes, but I realsed that data needed to be input...

3 replies Last reply on 17 Apr 2015 by
BrianGreen

Conditional formatting cells a and b based on value in c

Hello, As you can see from picture: I want to fill with red colour cells A and B if value from C is equal with value from A. I want to do this wi...

2 replies Last reply on 17 Apr 2015 by
easyyu

Powerpoint 2003 gives error

Hello friends! I need help. Powerpoint 2003 gives the following error: "Powerpoint can't create the storage required for an inserted or linked obj...

1 reply Last reply on 16 Apr 2015 by
xpcman

How to find missing text or values comparing 2 cells

Hello, i have data in 2 columns, for ex: Column A: Bearing, Ball, 1/2 in, Cast Iron Column B: Bearing, Ball, Cast Iron by seeing this exampl...

7 replies Last reply on 16 Apr 2015 by
TrowaD

Popup menu with count

Hello, Can you help me with this? I have list of 150 driver's with licence valid upto info in D3:D153. I am trying following things 1. Check if va...

3 replies Last reply on 16 Apr 2015 by
vcoolio
Results 3101 - 3150 out of a total of 12,264