The discussions

Black screen with massege, disc boot failure insert

Hello, My computer says disk boot failure, insert system disk and press enter. What should I do? Thank you, Charlotte Configuration: Windows ...

1 reply Last reply on 17 Mar 2014 by
leonnyx

Excel macro to list current costs by code and extract previous

Hello, I am looking for a macro, that will list one set of values by a code and then move a precious list of codes with values and subtract one from t...

7 replies Last reply on 17 Mar 2014 by
TrowaD

Lan computers sending messages to each other without internet

Hello, Could you please help me with a problem. I have computers running windows 7 and networked and am trying to get a way to train users to use ...

3 replies Last reply on 17 Mar 2014 by
Amanda1991

Macro gives me expected en sub error

Hello, I have the below macro, but it gives me compile error expected end sub. This macro below I have copied and paste hoping it would work becau...

1 reply Last reply on 17 Mar 2014 by
venkat1926

Conditional formatting excel drop down list

Hello, I want to color code a drop down list in excel? I have done conditional fomatting on each cell in the list, it is a text list, but not wor...

2 replies Last reply on 16 Mar 2014 by
tch1908

Type name into a cell removing name from another unique list

Is there a way to manually type a name into a cell on one worksheet, that removes that name/entry from another large list, with unique names, whether ...

12 replies Last reply on 16 Mar 2014 by
venkat1926

Merge the selected sheets data into one data

I am having 5 sheets (Name as Ricky, Rambo, Input, Output, Time) data combined into combined sheet , for this i need to run through macro Please hel...

1 reply Last reply on 15 Mar 2014 by
ac3mark

Comparing values in multiple columns

Hi All, Would appreciate if you people can help me, as am not that excel expert :( My argument is like this- Column: 1. 2. 3...

9 replies Last reply on 15 Mar 2014 by
Mazzaropi

Powerpoint advance course

i did powerpoint and i want to know if theres any advance courses for powepoint

1 reply Last reply on 15 Mar 2014 by
Ambucias

Use of max and min functions.

hello there ,, I have two column names & numbers in different cells i need the highest number to display with the name next to it same with the...

8 replies Last reply on 15 Mar 2014 by
taghreed almuhajiri

Delete name from sheet1 as i type same name in cell of sheet2

I have a list of 10,000 unique people with corresponding statistics on a worksheet. These are also included on additional worksheets into smaller subc...

1 reply Last reply on 14 Mar 2014 by
axxeshredder

Automatically calculate random number as invoice number

Hello there! I am fairly new to macros and am trying to create an excel document that automatically insert a new randomly generated number (as the ...

7 replies Last reply on 14 Mar 2014 by
ac3mark

To start the sumif from partial text on first row of the day

Hi, I have formula IF(COUNTIF(A$2:A1747,A1747)=1,SUMIF($A$2:$A$10000,$A1747,$G$2:$G10000),"")), which sums daily figures only for agencies by days....

1 reply Last reply on 13 Mar 2014 by
jutulu

Autofill destination

I created a macro to add a column and then to make the number in the column to the left of that column a negative number. I do that in the first cell...

2 replies Last reply on 13 Mar 2014 by
clouser

Duplicate rows based on cell value

 Solved

Hi, Can somebody help me out with this. I want to duplicate rows based on input in a cell. can it be done in VB or macro or formula array? User wi...

16 replies Last reply on 13 Mar 2014 by
TrowaD

Macro recorded to copy and paste only values

Hi, This is the first time I use this site and hopefully will get some help with this. Basically, I have a basic workbook which is populated everyd...

4 replies Last reply on 12 Mar 2014 by
jutulu

Chosen text in dropdown adds number in cell

Hello, I have a problem with my formula, If i choose a product "text" in a dropdown menu in cell C2, i want it to display a serial number in C...

1 reply Last reply on 12 Mar 2014 by
GeoffRies

Excel payroll work

 Solved

Hello, I'm using Excel to do payroll system. e.g. I create worksheet that showing data as below table :- basic more than 0.01 less tha...

4 replies Last reply on 12 Mar 2014 by
Winndixie

Need help in date conversion

Please help me with a formula to convert ' 17/08/2013 02:06:02 PM' to ' 08/17/2013' in XLSX . Thank you.

1 reply Last reply on 12 Mar 2014 by
venkat1926

Move data from one workbook to another

Hi I would like to move data from one workbook to another (copy & paste basically but there's tons of lines). The second workbook is in a differen...

2 replies Last reply on 11 Mar 2014 by
Niv.2

Take out the ceros of specific cells, not the whole worksheet

how could I make the 0 ceros of an empty cell not to appear? I've tried going into customs and entering £#.##.00, which I got from somewhere though do...

2 replies Last reply on 11 Mar 2014 by
jutulu

Microsoft office word 2007 - displaying numbers across the pages

Hi all I have an issue which I have tried to find the answer to myself but have had no luck so wondering if anyone on here could help, the problem ...

3 replies Last reply on 11 Mar 2014 by
Ambucias

Excel formular

 Solved

Hello Sir, Can you let me know the formula in Excel: I have a table as below: 1 A B ...

9 replies Last reply on 11 Mar 2014 by
TrowaD

Excel equation

i want to formulate for eg:- inv date pymt terms amount payment due date jan feb mar apr 01.01.2014 30 1000 31.0...

1 reply Last reply on 11 Mar 2014 by
TrowaD

Excel greater or less than

 Solved

Hi all, I'm having a problem that with multi counting with less than, eg. case 1: A1 = 1000 (total revenue) B1 = 3% (rebate) C1 = 2000 (free ...

2 replies Last reply on 10 Mar 2014 by
Winndixie

Create worksheet based on lists & populate data from another...

 Solved

Hello, I've been recently working on trying to create a fairly large excel workbook & trying to automatically populate sheets inside of it. I h...

5 replies Last reply on 10 Mar 2014 by
sv2bnv

Highlight cells based on a specific day of the month

Hi there. I have a bill spread sheet that is layed out pretty simple. I basically have all of my bills listed in the order they are due each month. Th...

1 reply Last reply on 10 Mar 2014 by
TrowaD

Conditional formatting

 Solved

hello I did a table in Excel ( its a vacation tracker) I'll give you an example for what i'm trying to do Ex : my vacation starts from 15-mar ...

9 replies Last reply on 10 Mar 2014 by
Mazzaropi

Attendance sheet

Hi, I'm getting Confused and just need someone to help. I know I am looking for something simple but can't figure it out, i got some manhour she...

1 reply Last reply on 10 Mar 2014 by
venkat1926

Search column b for matching value from a row in column a ....

 Solved

Search column B for matching value from a row in column A and populate D with the value that is in the matching row of B that was in column C, ie XYZ ...

10 replies Last reply on 7 Mar 2014 by
ac3mark

Automatic transfer- with just one word

I just started a new job and my boss asked me to see if I could have the clients information automatically sent from the master page over to the overd...

2 replies Last reply on 7 Mar 2014 by
Kberg1

Excel protect a column and a cell

Hello, how can i proctect excel column and cell Configuration: Windows 7 / Firefox 23.0

1 reply Last reply on 7 Mar 2014 by
ac3mark

Compare column a to column b and return column c

 Solved

Hello, I have spreadsheet with names in Column A, phone numbers in Column B. Column C has the same names in different order. How can I ha...

2 replies Last reply on 6 Mar 2014 by
ad1959

Monthly spreadsheet for equipment hours- i'm stuck!

Daily log for equipment hours I want to make a file with 31 days of worksheets in the workbook for the complete month. The order of the workshee...

3 replies Last reply on 6 Mar 2014 by
TrowaD

Convert datagrid data to raw data

Hello, i've a excel grid with data in rows and coluns with values in each pair (row/column). i need to transform each combination in raw data to p...

7 replies Last reply on 6 Mar 2014 by
TrowaD

Possible to import pdf data onlin into excel?

 Solved/Closed

Hello, Does anyone know if it is possible to import pdf data from the internet into excel? Or do I need a special adobe acrobat program to do so? ...

9 replies Last reply on 6 Mar 2014 by
Rajesh

Pdf to ppt converter

does anybody have pdf to ppt converter?

1 reply Last reply on 5 Mar 2014 by
ac3mark

Copying data from one sheet to another conditionally

 Solved

Hi gang, I have a spreadsheet with columns A thru H being populated with text. I need to copy columns A thru H from spreadsheet 1 to spreadsheet 2 i...

2 replies Last reply on 5 Mar 2014 by
sorceres13

Highlight row on one sheet if a number matches on another sheet

 Solved

Hello, I have a spreadsheet with multiple tabs. I am trying to figure out how to get a row to highlight on the tab called "Directory" if a number in ...

10 replies Last reply on 4 Mar 2014 by
TrowaD

A macro to create new spreadsheet and copy data

Hello, In the example below, I want to copy all the date from all the worksheets present in excel. In addition to my requirement to edit value of ...

1 reply Last reply on 4 Mar 2014 by
TrowaD

How to define specific format for number?

 Solved/Closed

Hi, I would like to define specific format in excel. For example, if I type 123456789 and hit Enter, it should be 123-456-789 or 123-45-6789 autom...

5 replies Last reply on 4 Mar 2014 by
ugn10

Add days to date

 Solved

Hello, I need a formula that help me to add days to Date and it gives me the result in date format For example 03/01/2010 + 25 = 28/01/2010 Th...

3 replies Last reply on 4 Mar 2014 by
zhinghur

Macro won't paste in second sheet "run-time error:9" out ofrange

I am trying to copy from sheet 1 and paste in sheet 2. Checking row "G" for the letter "x", the "x" marks the rows I would like to copy from sheet1...

1 reply Last reply on 3 Mar 2014 by
venkat1926

If statement using date to change row colour

 Solved

I have a sheet with the following header row: Reference Client MAWB / BoL Date logged Date completed Days to resolve Logged by Caller type Error ar...

2 replies Last reply on 3 Mar 2014 by
Z Kindo

Excel 2010-vb macro formula into many spreadsheets

 Solved

Hello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable me ...

4 replies Last reply on 3 Mar 2014 by
AnFey

Automate the sheet in order to calculate costs

I have an order sheet and 3 reference sheets. I would like to automate the sheet in order to calculate costs and for selling different types of produ...

1 reply Last reply on 1 Mar 2014 by
Mazzaropi

If function using dates

 Solved

Hi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date filled ...

2 replies Last reply on 28 Feb 2014 by
Escalation

If function using dates

 Closed

Hi I am trying to write an IF function for an escalation calculation. What I want is to have a date filled into cell B13 (22 February 2014). The I...

1 reply Last reply on 28 Feb 2014 by
Ambucias

Data comparison

 Closed

I have a database compiled in my office of current students in a college program for a particular semester AND a database from administration with the...

2 replies Last reply on 27 Feb 2014 by
Ambucias

Macro syntax error

HELLO THERE NEED HELP TO RESOLVE AND MAKE THE BELOW CODE WORK IN EXCEL(MACRO) ActiveCell.FormulaR1C1 = _ "=IF(RC[-2]=""10X"",""Acquisition on do...

1 reply Last reply on 26 Feb 2014 by
ac3mark
Results 4051 - 4100 out of a total of 12,258