The discussions

Fix the code

 Solved

Hello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...

3 replies Last reply on 9 Nov 2015 by
rizvisa1

Date format changes when editing it

 Solved

Hi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...

5 replies Last reply on 9 Nov 2015 by
rizvisa1

Copying entries from multiple sheets to new sheet, then summing

 Solved

I run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...

2 replies Last reply on 9 Nov 2015 by
nahidule

Cutepdf writer for windows 10

When will the free version of CutePDF Writer become available for Microsoft Windows 10? Thank you for your time and assistance.

1 reply Last reply on 8 Nov 2015 by
Ambucias

Merge two macros of 2 diffrent workbooks

 Solved

Hello, I have 2 macros in 2 different workbook Currently i have to run 1 st macro(!st work book),then open 2nd macro workbook then have to run...

6 replies Last reply on 7 Nov 2015 by
rash

Can't open powerpoint files. pptx

I've got a user on a Windows 8 laptop with Microsoft Office 2013 installed. Whenever he tries opening PPTX files, no actual content is displayed but i...

1 reply Last reply on 6 Nov 2015 by
ac3mark

Remove or clear data

 Solved

Hello, I am grateful if this query be solved. If user Enter any value in C2 and also user enter "Best" or "Worst" in Cell D2, how it may clear th...

10 replies Last reply on 6 Nov 2015 by
smuneeb

Enter data to run command button

Hello, How can I prevent a command button from running before data is entered into a cell? I have a workbook that refreshes data based on when a...

1 reply Last reply on 6 Nov 2015 by
rizvisa1

Multiple if in data validation

 Solved

Hello, Its being requested please help in the below multiple IF function used in Data Validation =IF(ISNUMBER(E2),AND(E2>0,E2

3 replies Last reply on 6 Nov 2015 by
smuneeb

Formula - if (text), "text"

If a column has a number entered into it, the second column needs to auto populate with corresponding text. eg column I: User enters "22" co...

1 reply Last reply on 5 Nov 2015 by
rizvisa1

Using command button to post on another sheet!

Hi, So to brief you..I created a database that has a searchable drop down combo box that gives you suggestions as you type. I have my combo box se...

1 reply Last reply on 5 Nov 2015 by
TrowaD

Lookup functions

I have a spreadsheet with various tabs including data which has been dumped in from various sources. Data includes: worked hours by department, and pr...

1 reply Last reply on 5 Nov 2015 by
TrowaD

Conditional formatting of one based on the other cell.

Hello, I was wondering if there is a way I can say to excel without coding: 1)IF cell A1 is equal or greater [equal or less] than cell B1, then...

4 replies Last reply on 5 Nov 2015 by
TrowaD

Conditional copy of cells with corresponding values

 Solved

I have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but ...

2 replies Last reply on 5 Nov 2015 by
DR999

Conditional formatting of one cell based on the other cell.

Hello, I was wondering if there is a way I can say to excel without coding: I have three cells A1, B1 and C1. If A1 value (which constatly chan...

2 replies Last reply on 5 Nov 2015 by
nogapok1

Count formula (need help)

 Solved

Hello, everyone I want to thank you in advance because I know that excel can be frustrating. I hope this is an easy one I have the following data list...

1 reply Last reply on 4 Nov 2015 by
RayH

Using if function with dates

 Solved

Hello, I want to thank everyone for their time in advance. My problem is that I have a two cells/rows (78 & 87) in a column on this worksheet ...

18 replies Last reply on 4 Nov 2015 by
RayH

Windows 7 excel 2013 jump lists

I'm using Windows 7. My Excel 2013 Jump List only lists the latest CSV files. How can I also get my excel files to show in the jump lists? (This...

4 replies Last reply on 4 Nov 2015 by
Sandy

Compare three columns in three sheets

Hello, I have two excel sheets. Sheet 1 has A,B,C,D columns and sheet 2 has A,B,C columns.Now I want to compare A,B,C columns in both the sheets. ...

1 reply Last reply on 4 Nov 2015 by
rizvisa1

Insert a row below a given cell of a table

Hello, I have a table on Excel 2013. I would like a macro to do the following: 1) insert a row bellow a given cell 2) copy the format of the origi...

1 reply Last reply on 3 Nov 2015 by
rizvisa1

Finding the last used column

Hello, Can anyone help. I want to find the last column used so that I can compare it with the first column Configuration: Windows XP / Firefox ...

8 replies Last reply on 3 Nov 2015 by
Rayh

Macros editing

 Solved

Hi Guys, I have created a macro that splits a master worksheet into separate tabs based on specific criteria then saves each tab as a separate wor...

1 reply Last reply on 3 Nov 2015 by
rizvisa1

How to create a macro to find the value in specified cell

Hello, i need to create a macro to find a cell based on the value of other cell. for e.g. i want find the cell by copying cell "DH1" (in which t...

1 reply Last reply on 3 Nov 2015 by
rizvisa1

Formullas

Helo i need some formulas .e,g.TA,DA,HR,INTEREST% in like insurance. And Grade,%,fail,pass. Please help me undefinedHelo i need some formulas ....

1 reply Last reply on 3 Nov 2015 by
TrowaD

Adobe photoshop software

After downloading , how do you open the zip file

1 reply Last reply on 3 Nov 2015 by
TrowaD

Vba to protect cell in excel

Hello, Hello, I need a help if some one can help me. i a fresh in excel vba code writing. please provide a code to protect a cell with passwor...

1 reply Last reply on 3 Nov 2015 by
TrowaD

Search and extract up to 10 lots of 46 sequential cells

Hi, I need to search and extract up to 10 lots of 46 sequential cells from column A containing 1400 cells. These 9 or 10 lots of 46 cells need to be c...

6 replies Last reply on 3 Nov 2015 by
spekky2

Refer only one column from named range

 Solved

Hello everyone and thanks in advance! I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns s...

2 replies Last reply on 2 Nov 2015 by
maya

I need a program that will automatically make invoices weekly.

I own a small window washing business and I need invoices for every job printed weekly. What I am looking for is a program that I can enter the invoic...

2 replies Last reply on 2 Nov 2015 by
ac3mark

I need to copy 3 cells into one cell

Hello, I am having a problem in excel I can't figure out. I have an example of what I am working with below. There are 3 columns A (SKU), B (Numer...

1 reply Last reply on 2 Nov 2015 by
rizvisa1

Conditional formatting in a vlookup

Hello, Not sure if what I am wanting is possible but thought I would ask... I have a database in which I will always update and add to. And ea...

1 reply Last reply on 2 Nov 2015 by
TrowaD

Trying to copy from sheet all values to another sheet

Hello, I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.

1 reply Last reply on 2 Nov 2015 by
TrowaD

Compare two columns with another two columns and return

Hello, I need to compare two columns with another two columns and return date from a third colum. Example I have a zip code with 90004 with 3 dif...

1 reply Last reply on 2 Nov 2015 by
TrowaD

Find a word based on # and copy word to another cell

Hi all, I have a lot of social media messages in row 1 below eachother, and my goal is to find all the hashtages from the messages. For example: ...

1 reply Last reply on 2 Nov 2015 by
TrowaD

Data transferred from macro

Hey guys can you please help a desperate girl out lol I have a report I do every 2 hours at work through excel. I have two reports that go into a m...

2 replies Last reply on 31 Oct 2015 by
bigdridog

Macro to repeat a row n times

Hello, I want a macro to repeat a row n times. Example A B C if n=2 A B C A B C Thanks in advance

2 replies Last reply on 31 Oct 2015 by
Shorouq

Lookup relevant value from table

 Solved

Hello Team, I have a doubt, Consider the table : Event A B C 1 3020 3420 1324 2 3005 3405 5462 3 2990...

4 replies Last reply on 31 Oct 2015 by
Gokuneo

Macro for insert picture

Hello, Please help i have to insert item pictures in column A i have item code in column B. All pictures saved in D drive folder name pictures. fi...

3 replies Last reply on 30 Oct 2015 by
ac3mark

Recovering deleted mails from trash

 Closed

Hello, i just deleted my mails from trash. how can I recover that mails deleted from trash.please suggest me

Last reply on 29 Oct 2015 by
Ambucias

Can i use word now?

 Closed

can i use word now?

Last reply on 29 Oct 2015 by
Ambucias

Copying dates in excel

 Solved

Hello, I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in...

3 replies Last reply on 29 Oct 2015 by
berry

Combine text from multiple cells if other cell has a value of 1

As per the picture I have a spreadsheet that tracks what courses an individual has completed and if that course has a Certification attached to it. If...

1 reply Last reply on 29 Oct 2015 by
TrowaD

Moving data in sheet depending on contents of a cell

Hello, I have a sheet, where at the top, I have a table of all orders in production. In column "I" you can set the status of the order using data ...

1 reply Last reply on 28 Oct 2015 by
ac3mark

How can i restore corrupt .edb?

 Solved/Closed

Hello, I have an exchange server with a .edb that is in a dirty shutdown state. I have 2 storage groups. The second storage group will not mount d...

Last reply on 27 Oct 2015 by
JacobusdeKoning

Formula for convert number into word

dear sir, i want to formula for numeric value (Ex. 12,350/-) into word (twelve thousand three hundred fifty rupees only) please rep...

1 reply Last reply on 27 Oct 2015 by
TrowaD

Change color of one cell based on another cell

Hi, I am trying to create a speadsheet based on customer sales. In one cell it has "yes" or "no" to inform me on whether or not the customer is commi...

1 reply Last reply on 26 Oct 2015 by
Mazzaropi

Restrict user from printing empty pages in excel vba

Hello, I have three print areas in a single sheet. If I print that sheet, it prints 3 pages(print areas). Is there any way to print only the p...

2 replies Last reply on 26 Oct 2015 by
pooja

If statement

 Solved

Hi, Could you please tell me what I'm doing wrong in this statement? I can't find the issue :( =IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Pass...

5 replies Last reply on 24 Oct 2015 by
BrianGreen

Copy data from 1 workbook to another based on sheet tabs

 Solved

Good day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...

8 replies Last reply on 23 Oct 2015 by
bimmy80

Match requests sent to bank with requests processed by bank

Hello, I am trying to match the requests processed by the bank with the requests sent to the bank for processing. The bank could process part of ...

4 replies Last reply on 22 Oct 2015 by
VSK
Results 2601 - 2650 out of a total of 12,264