The discussions

Trying to create an order sheet

 Solved

Hello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how may o...

3 replies Last reply on 29 Aug 2016 by
vcoolio

Creating an order

Hello, I have a multi sheet database where each sheet represents a vendor. I'd like to transfer the information from the row, Column A, B, C, to my ...

1 reply Last reply on 27 Aug 2016 by
vcoolio

Exporting data

 Solved

Hi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The data c...

6 replies Last reply on 26 Aug 2016 by
vcoolio

Conditional formatting

Hello, Can I use conditional formatting to change a number from positive to negative based on the text in another cell? For example, I have a fil...

1 reply Last reply on 26 Aug 2016 by
Mazzaropi

Add data inputed from one sheet to anther

I'm trying to do an inventory control spreadsheet where I can put the data (ex, inventory in hand, use, buy, etc and it will be saved in another sheet...

1 reply Last reply on 26 Aug 2016 by
ac3mark

Pdfcreator won't open .ps files

Hello, I downloaded PDFCreator so I could look at some postscript files, but it won't open any of them. PDF Architect just says the file is unsupp...

7 replies Last reply on 26 Aug 2016 by
A

Conditional format to highlight cell based on date

 Solved

hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...

7 replies Last reply on 26 Aug 2016 by
Mazzaropi

Formula that will make a specific text into a number

Hello, I need formula that will make a specific text into a number example: if A1 is R134a then B2 is 1430, if A1 is R404A then B2 is 3922, ...

1 reply Last reply on 26 Aug 2016 by
Mazzaropi

Conditional formatting

Hello, if i type "T" in one Cell i want to be fill colour to entire row how can it possible Configuration: Windows 7 / Chrome 53.0.2785.80

1 reply Last reply on 25 Aug 2016 by
TrowaD

Select a single line even if there are merged cells with vba

Hello, I'm creating a worksheets that needs to be protected at all time. However, users may need to duplicate a line sometimes. What I want to do ...

1 reply Last reply on 25 Aug 2016 by
TrowaD

Excel "if" function with date in test cell

Hello, I am trying to use the IF function with a date in the 2 logic test cell; If the 1st logic test cell has a date then I want the word "IN TRANSI...

1 reply Last reply on 25 Aug 2016 by
TrowaD

Keeping data

Hello there, I have what I consider an interesting issue and would certainly appreciate some options for resolving it as I am no Excel expert. We h...

2 replies Last reply on 25 Aug 2016 by
vcoolio

How to separate data between sheets

Hello, I'm don't know much about Excel in regards to functions and formulas, what I'm trying to do seemed like it may be a simple task but I'm le...

1 reply Last reply on 25 Aug 2016 by
vcoolio

Vba search column for matching string

 Solved

I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a c...

5 replies Last reply on 25 Aug 2016 by
Juzer

Enter date in dd-mm-yyyy

Hello, Please enter date in dd-mm-yyyy only. I have give 25-12-1988 but not accept Configuration: Windows 7 / Chrome 52.0.2743.116

2 replies Last reply on 24 Aug 2016 by
fdibbins

Outlook does not open the .pst file created by the outlook

 Closed

Hello, Outlook does not open the .pst file created by the outlook. There are important emails. I have zipped outlook 2010 .pst file and copied ...

1 reply Last reply on 24 Aug 2016 by
Ambucias

Need a formula

on 1/1/16 (a1) , John (b1) told me he'd pay me $1 in 30 days. i want a formula that will automatically add 30 days from (a1) in date form in another...

4 replies Last reply on 24 Aug 2016 by
Mazzaropi

Negative cells

 Solved

Hello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become positive n...

3 replies Last reply on 24 Aug 2016 by
Mazzaropi

Code for transferring data

i Have an excel workbook with different sheets. In sheet 1, i have date picker, where i select date and enter all the data for that particular date. T...

1 reply Last reply on 23 Aug 2016 by
ac3mark

Calculate no of days left from today to a future specified date

 Solved

Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116

2 replies Last reply on 23 Aug 2016 by
TrowaD

Formula zero return

Hello ~ How can I get a zero return instead of a FALSE statement with the following formula? =IF(F4>E4,(F4-E4)*24,IF(F4

1 reply Last reply on 20 Aug 2016 by
Mazzaropi

Another libra base question

Woe is me. Im going to cry :( I need to know how to do basic arithmatic with dates in Libre Base queries. All I want to do is find the number...

5 replies Last reply on 20 Aug 2016 by
BrianGreen

Help regarding a pricing sheet

Hello, I'm looking for help regarding a pricing sheet I'm trying to create on excel. I have my quantity in C5 = 2500 and cost in C15 = 75,000 if C...

4 replies Last reply on 19 Aug 2016 by
Kev1027

Changing colour of cell once multiple other cells contain text

Hello, I would like to indicate in a cell at the beginning of a row whether multiple 'mandatory' cells within the row contain text. Red for incomple...

1 reply Last reply on 19 Aug 2016 by
fdibbins

Count if formula

Hello, I have a Excel file where i have specific paths of the files and i Need a formula where it should reefr that cell path and Count the rows w...

1 reply Last reply on 19 Aug 2016 by
ac3mark

Format the color font depending on the value of another cell

Im new to Excel. Is there away or formula to change the color font of a cell depending on another cell? I want my text in colum A B C to be the font ...

1 reply Last reply on 19 Aug 2016 by
Mazzaropi

Creating remarks from grades

How do I create corresponding remarks against letter grades?

1 reply Last reply on 19 Aug 2016 by
Mazzaropi

Insert 1 result if a cell contains one of several possibilities

Hi All, I am new to this level of excel - but what I need is a formula that does the following : Insert if an adjacent cell contains one of up ...

1 reply Last reply on 18 Aug 2016 by
Mazzaropi

Copy values only when using a filter

Hello, VBA below, this is doing exactly what I want... however I can not get it to copy values only...not the formulas and a list which is in a co...

3 replies Last reply on 18 Aug 2016 by
vcoolio

Problems using outlook after changing gmail password

Using Outlook 2007. I have 2 email accounts which both worked fine. Yesterday I changed my password for both accounts through Gmail online. Account...

1 reply Last reply on 17 Aug 2016 by
Ambucias

Macro

 Closed

Hello, in excel 2013 I have column of cells a:2:a4955 of the cell.interior.colorindex = 3 then I need to return "red" I can't get his to work.

1 reply Last reply on 17 Aug 2016 by
KarenPostell

Copy paste data from one sheet to another automatically

Hello, First of all thanks for your wonderful site. I have a large set of information on one sheet. Column b has the name of the sheets in the ...

12 replies Last reply on 17 Aug 2016 by
ssdgeek

Without key activation

Hi I have some problem in ms office 10 getting error code 0x8007007B Its product code activation error code How to activate ms office 10 without ...

1 reply Last reply on 17 Aug 2016 by
Ambucias

Create duplicate sheet

Hi all, Is it possible to create a worksheet automatically in the same excel workbook. For e.g i have a sheet "1" with some content (includes f...

1 reply Last reply on 17 Aug 2016 by
PoulJ

Auto-copy rows from one tab to another based on cell value

Hello! I'm really hoping this works to get a response because I am stumped. I've read a lot of sites and lot of similar posts but nothing seems to...

1 reply Last reply on 16 Aug 2016 by
fdibbins

Nested if functions using time values

Hello, I have an excel formula here, but it wont work. =IF(AND(G2>=TIMEVALUE("06:00:00"))*(G2=TIMEVALUE("00:00:01"))*(G2

2 replies Last reply on 16 Aug 2016 by
fdibbins

Auto fill in for list - based on another cell's value

Hi! I have different sections of an excel document that feature the same lists over and over again. Sometimes the values selected will be different...

1 reply Last reply on 16 Aug 2016 by
fdibbins

Pdf now in word document

Hello, I downloaded adobe reader and now all my PDF files is in word and not opening in pdf like it should be. Even my mail i cant open in pdf. Pl...

1 reply Last reply on 16 Aug 2016 by
richmondmiles

How could i do automatically find the price

Hello, I have question for Excel, it is small hotel booking system? If I have for example 6 rooms, and they have all different prices, i.e. 1...

1 reply Last reply on 16 Aug 2016 by
Mazzaropi

Copy row if criteria is met macro

Hello, I am looking to make a macro that will copy the entire line from sheet 1 to sheet 2 if criteria from column H is met. Essentially if th...

4 replies Last reply on 16 Aug 2016 by
Ram

Compare columns and create list of duplicates

 Solved

Hello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...

2 replies Last reply on 15 Aug 2016 by
CarlosIRL

Auto generate a copy of a template worksheet and rename each

Hello, I am very new to Excel and VB and am trying to create a macro that will do the follow; 1. Create a copy of a template worksheet (named Tem...

2 replies Last reply on 15 Aug 2016 by
vcoolio

Conditional formating of cells

Hello, I am trying to set up the conditional formats of cells as follows :In column D place the company name - have the next 13 cells to the right t...

1 reply Last reply on 15 Aug 2016 by
fdibbins

Copy data from one sheet 1 to sheet 2 only if text

Hello, I have sheet 1 tracking a lot of different information (Client name, date in, date put etc...) for 2 machines. (Machine A & Machine B) N...

1 reply Last reply on 14 Aug 2016 by
fdibbins

Need help to macro my invoice number

 Solved

Hello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...

6 replies Last reply on 12 Aug 2016 by
ac3mark

Search value error

 Solved

HI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...

3 replies Last reply on 12 Aug 2016 by
Mazzaropi

Selecting the different range of cells based on values

Hi all, consider the Excel sheet A B C D 1 NAME CITY AGE CLASS 2 ALEX NEWYO...

1 reply Last reply on 11 Aug 2016 by
ac3mark

Information automatically updated

Hi, So I am creating a file for my boss on excel 2016 that I want to automatically update information from one table to the other without me havin...

1 reply Last reply on 11 Aug 2016 by
ac3mark

Need help with conditional formatting.

Hello, I need to have my spreadsheet enter a date that is 6 months (180 days) from an original date once it is entered. I have 2 columns - Date Pl...

1 reply Last reply on 11 Aug 2016 by
Mazzaropi

Searching and replacing dates

I need to search and replace dates. For example, in one row (representing one employee), all dates prior to 8/9/16 and replace those dates with 8/9/1...

1 reply Last reply on 11 Aug 2016 by
TrowaD
Results 1851 - 1900 out of a total of 12,260