The discussions

Pdf into excel

I saved my excel file as x but it was automatically saved as a pdf. I am using windows 10. The pdf is microsoft edge. I need it back as excel. Please ...

2 replies Last reply on 15 Feb 2016 by
toni634

Find serial number and input average value into adjacent cell

 Solved

Hello, I'm trying to find out if there is a way to do this. i have a list of 15k serial numbers. several of them repeat because the value vary. i ...

4 replies Last reply on 15 Feb 2016 by
Cindy

Vba code for duplicating excel workbook

Hi all! My company use delay logs where we record delays everyday for different customers. At the moment every morning we're having to manually ...

1 reply Last reply on 15 Feb 2016 by
TrowaD

Formula that can automatically classify monthly expenses

Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as ...

1 reply Last reply on 15 Feb 2016 by
TrowaD

One million and two hundred thousand only

I have try edit vba code in Excel for spell cu1,200,000 = One million and two hundred thousand only change in to One million and Two San only. please...

1 reply Last reply on 15 Feb 2016 by
TrowaD

Downloading

Hi, can yoy help me how to download excel or spreadsheet using open office. I need it for my job. Thank you very much

1 reply Last reply on 14 Feb 2016 by
BrianGreen

Copy the data of a row based on identifying the data in a cell

Hello, I have data in about 20 columns and 100 rows There are some blank cells in column "I" (about 20 blank cells totally in "I" column, at di...

1 reply Last reply on 14 Feb 2016 by
vcoolio

Excels docs are opening as pdf

Hello, I am using windows 10. My excel documents are being saved as microsoft edge files. This is a nightmare. I need the excel docs. Please help ...

1 reply Last reply on 13 Feb 2016 by
xpcman

If function

Hello, How many times we can use IF function in single formula?

1 reply Last reply on 12 Feb 2016 by
rizvisa1

Make adobe the default to open the pdf attachments

Hello, My Word cannot open PDF files attached to emails, it gives me an error. When I right click on the file as suggested I do not get a properti...

7 replies Last reply on 12 Feb 2016 by
Ambucias

Cell = yes or other text return value

 Solved

Hello, I'm using IF statements to return a value for the specifc answer supplied for the question and then adding up all the questions for the t...

2 replies Last reply on 12 Feb 2016 by
vcoolio

Need to learn excel how

i need excelent in ms excel , how any ways ,suggestion or reference sites..i thank full to your help.

1 reply Last reply on 12 Feb 2016 by
smuneeb

How to check % value in excel and macro using vbscript?

 Solved

Want to check a cell with % percentage format matches the value in Vbscript code. Sub ChangeColor() Dim lRow Dim myVar lRow = Range("AC" & Row...

4 replies Last reply on 11 Feb 2016 by
anjanasundaram

Formula to copy rows a set number of times

 Solved

Hello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunatel...

2 replies Last reply on 11 Feb 2016 by
Sadat

Vba copy data from a range and paste to empty column

Hello, I have a set of values in range P6:P15. At the end of each month, I would like to copy and paste the data from the current month column to ...

7 replies Last reply on 10 Feb 2016 by
vcoolio

Automatically transfer excel row to a different sheet based

Hello, I have a spreadsheet for paid & unpaid invoices from our customers and would like to have the row automatically move once I mark it pa...

7 replies Last reply on 10 Feb 2016 by
vcoolio

Vba using subroutines - help please

 Solved

Ok guys, I have a problem (well more than one, but Im not sure I should mention those on this forum!). Im in the process of writing an Excel macro ...

7 replies Last reply on 10 Feb 2016 by
BrianGreen

Sort type and size excel formula

Hello, can someone please help? I'm trying to write a formula that would sort Type and Size on the following spreadsheet which has the following: ...

1 reply Last reply on 9 Feb 2016 by
TrowaD

Extracting matched observation and its corresponding row

Hello, I have excel sheet containing around 100K observations (rows). There is one column say "A" containing some IDs and each ID is having 10 par...

1 reply Last reply on 9 Feb 2016 by
TrowaD

Can't change format of cell

Hello, Using Excel 2013. I have a document which consists of various combinations for padlocks in a format of 00-00-00 most come out correct...

3 replies Last reply on 9 Feb 2016 by
TrowaD

Date format nightmare

 Solved

solved with this: Because it is not a date to excel. 1. Select the column in which there was date 2. Goto data and choose text to column 3....

1 reply Last reply on 5 Feb 2016 by
xpcman

Excel sum value...

 Solved

Dear I would like to know how to do the below mentioned formula I have tried but not resulted. Excel - Sum value in column when cells contains ...

2 replies Last reply on 3 Feb 2016 by
anazar

Formula help

 Solved

Can someone please help me with this formula =IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470))) What i am trying to do is : if G2 has the...

3 replies Last reply on 3 Feb 2016 by
vcoolio

Conditional formatting based on year

 Solved

Guys, I come again cap in hand with another plea for help on a sort of finished project, but I want to make it better. I have some conditional f...

1 reply Last reply on 2 Feb 2016 by
BrianGreen

Extracting rows from excel

 Solved

Hi there, I have an excel sheet with a very large data. I want to extract different rows and write them in to different sheets of the same excel (or ...

3 replies Last reply on 1 Feb 2016 by
vcoolio

Increment cell value based on change in value of another cell

Hello, Say I have a value of 100 in cell B3 and I need this value to increase/decrease based on the change in value of A2. How do I do that? For e...

1 reply Last reply on 1 Feb 2016 by
TrowaD

Excel query

Hi I looking for a formula that will calculate an average order spend by day without having to do this manually(1, 2, 3 ). So for example it tak...

4 replies Last reply on 31 Jan 2016 by
556tim

Blackberry

Hello, i cant open my blackberry mobile because i forget id or password Configuration: Windows 7 / Chrome 47.0.2526.111

1 reply Last reply on 30 Jan 2016 by
shaikrizwan

Copy and paste multiple

Hi I'm looking for away to be able to copy a single cell from multiple sheets (tabs) for example cell a1 and list it's contents on a separate summ...

1 reply Last reply on 29 Jan 2016 by
vcoolio

Auto populate record from one sheet to another

Hello, I'm working on a commissions spreadsheet for my company and would appreciate some assistance with a question I have. There is a separate ta...

3 replies Last reply on 29 Jan 2016 by
vcoolio

Data link

Hello, I'm needing help please, I'm trying to figure out how to either: Link an Access database to an Excel Spreadsheet where it has a templ...

3 replies Last reply on 29 Jan 2016 by
ac3mark

Free word processing software

Is there free office word proccessing software and how can I get it?

1 reply Last reply on 29 Jan 2016 by
xpcman

Conditionally format a cell so it turns a certain colour

I was wondering how to conditionally format a cell so it turns a certain colour when it goes past a certain date. Thanks

1 reply Last reply on 29 Jan 2016 by
BrianGreen

If, and question

Hello, I'm trying to work a formula that will change a given value in one based on dates going into several different cells. Example. If I pour a co...

3 replies Last reply on 28 Jan 2016 by
RayH

Column to vlookup

 Solved

I am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...

1 reply Last reply on 28 Jan 2016 by
NickBR

If function with time duration

Hello, I dont understanding why this can't work : =IF((g2=timevalue("0:30"));"25) G2 has a time duration time unit in it which equals 0:30. ...

3 replies Last reply on 28 Jan 2016 by
ac3mark

Disable a cell in excel using vb code

 Solved

Hello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...

13 replies Last reply on 28 Jan 2016 by
TrowaD

Conditioning formula to convert "x" into another cells value

good morning, I have a spreadsheet I am trying to create for a chili cookoff, I am trying to find a way to type an "x"(or any text) in a box showin...

1 reply Last reply on 27 Jan 2016 by
ac3mark

User friendly code for admission no

 Solved

Hello, I would like to request to Code for Admission No Range is started from B11 to B510 If user enter a123456789 or a-123456789 it always conv...

6 replies Last reply on 26 Jan 2016 by
smuneeb

Days of the week conditions

Hello, I am trying to create a template for my work. I have a table sorted by dates but need to reference the day of the week that date falls on....

1 reply Last reply on 26 Jan 2016 by
ac3mark

If one cell g4 has value 12345 then cell f4 will have....

 Solved

I need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...

3 replies Last reply on 26 Jan 2016 by
ac3mark

Auto copy row from one sheet to another via info in first cell

 Solved

Hello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...

10 replies Last reply on 25 Jan 2016 by
TrowaD

Creating a summary sheet

Hello, I have a worksheet that is recording customer interactions, and I would like to create a seperate sheet to summarize all the customers that ...

1 reply Last reply on 23 Jan 2016 by
vcoolio

Desktop publisher

Hi, I have just installed Open Office in my Dell Optiplex 755 and I wanted to work on a booklet - it seems not working well with me. Any idea plea...

1 reply Last reply on 23 Jan 2016 by
Ambucias

Button to copy sum to next row on another sheet

Hi, I think i have almost go this (pretty new with vba). On first sheet 'comparison' i have a few variables which can be changed then the sum of...

3 replies Last reply on 22 Jan 2016 by
vcoolio

Barcode help!!

Hello, I am making a barcode system and I want to be able to display the information given in the barcode in the cells next to it. For example I a...

2 replies Last reply on 22 Jan 2016 by
ac3mark

How do i exclude a value when using counta?

Hello, I am currently using the following formula to count cells that are not empty =COUNTA (D4:D17) However in this range there are certain...

1 reply Last reply on 22 Jan 2016 by
RayH

Automatic transfer of data

Dear CCM, I have a sheet with combined values for different units and I manually sort into the different units manually by copying and pasting into ...

1 reply Last reply on 22 Jan 2016 by
vcoolio

Excel

Hello, if the column a and column b are equal, i want to put "-"(minus sign) before the data of column b for further technical purpose. eg. it lo...

1 reply Last reply on 22 Jan 2016 by
vcoolio

Vba: creating new sheets based on copy, nameing them the cells

Ok, i am gonna try to be so clear i can. on Sheet 1 (Start Sida) i have a list from cells A9 to A500 with names. atm only A9-A52 have names in them. ...

1 reply Last reply on 22 Jan 2016 by
vcoolio
Results 2351 - 2400 out of a total of 12,258