The discussions

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

Change the column

Hello, I have to do the same thing as you but instead of using the column B, I have to use the column A. I tried to change your code but I didn't...

3 replies Last reply on 26 Feb 2014 by
ac3mark

Excel cmd button to transfer data from source to another.

Hello, Can someone help me with my problem. Is there a way to create button to transfer data from source sheets to any other sheets in the same wo...

1 reply Last reply on 26 Feb 2014 by
ac3mark

How do i change the result of a formula to normal text or values

 Solved

Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that for...

8 replies Last reply on 26 Feb 2014 by
kelnasawa

If formulas with dates

Hi all, I have a large spreadsheet that contains revenue information tied to sales deals. Column A contains the expected deal closing date and c...

2 replies Last reply on 25 Feb 2014 by
orodriguezjr

Data sorting

Hi Folks, I need your help in data sorting. Basically I just want to automate the data to be sorted to another table, Names from table1 to table...

2 replies Last reply on 25 Feb 2014 by
TrowaD

Excel mmyy format in order

 Solved

Hello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec 2012...

5 replies Last reply on 24 Feb 2014 by
nickkyh

Macro adding a row and numbering it in excel

Hi, Please could someone help I am trying to record a macro that will add a row below and number A2 with a number say 1, 2, 3 etc. I also need to...

1 reply Last reply on 21 Feb 2014 by
venkat1926

Date format

Hi, can i have solution for this question how to change date format this case to 21/11/13 to this 21-Nov-13. Thank you............

4 replies Last reply on 20 Feb 2014 by
Kevin@Radstock

Macro

Hi, I want to setup a Macro to cary these 2 rows and coloms when I hit the Macro button in excel. Can any one help me. I am staeting with E7:F7. T...

2 replies Last reply on 20 Feb 2014 by
sjcland

Office 365 activation key ?

 Closed

How & where to get office 365 activation key? I am unable to use it now its been six months i started using Office 365 but suddenly it sopped working....

9 replies Last reply on 19 Feb 2014 by
Ambucias

Excel formula help

 Solved

Hello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my mind. ...

5 replies Last reply on 19 Feb 2014 by
ac3mark

Apply conditional formatting rule if value is true?

Hello all! I have been searching for this answer for many days now, and I am getting quite frustrated. I'm not sure if it will work or not, but here i...

2 replies Last reply on 19 Feb 2014 by
apierson0

Inserting photos or image into a pdf

I have PDF complete office edition 4 and I am trying to update a flyer that we created a few years ago but the program wont let me change or insert a ...

1 reply Last reply on 19 Feb 2014 by
ac3mark

Track office log in and log out timings

Hi Team, Thanks for providing me an opportunity to be a part of the wonderful Team. I would need a Macro to track the shift timings of the emplo...

6 replies Last reply on 19 Feb 2014 by
ac3mark

If cost is 18.66 what would be 0.6% of it (calculation method)

 Solved

and if basic pay 65000rs what would be the 2.5% of it(calculation method)

5 replies Last reply on 17 Feb 2014 by
nooblord

Copy data from one sheet and putting it below a particular cell

I have a excel with 3 sheets . My requirement is to pull data from sheet1 ,sheet2 and put it into sheet3. There would be two headings in sheet 3 1...

1 reply Last reply on 17 Feb 2014 by
TrowaD

Moving information from 1 set to another based on an if

I have two worksheets. 1 is Proposals 2 is Projects When a row in Proposals is given a Project #(a cell in that row) I need the cells in that row to ...

1 reply Last reply on 17 Feb 2014 by
TrowaD

How to move data from one sheet to another

I have an excel spreadsheet, and I need a macro , in sheet1 I have several values of 7 numbers in a cell, example 1|2|3|4|5|6|7| up to 93|94|95|96|97|...

1 reply Last reply on 17 Feb 2014 by
TrowaD

How to formula the table

Table 0 to 1000 value is 2 1001 to 2000 value is 3 2001 to 3000 value is 4 3001 to 4000 value is 5 4001 to 5000 value i...

1 reply Last reply on 17 Feb 2014 by
BunoCS

Conditional formatting with dates

Hello, Your help would be greatly appreciated I have a cell with a date in it (A1). I want that cell to change colour if the following criteria is ...

1 reply Last reply on 16 Feb 2014 by
venkat1926

Date issues

Hello, i have the following problem with excel 2010 on windows 7 pro. i select col A and format it to Date yyyy-MM-dd i enter 2014-01-08 in A...

7 replies Last reply on 16 Feb 2014 by
ac3mark

Data import from a notepad

Hello everybody. Hope you are doing well. please help me in the following situation. Suppose i have a notepad file where there are some company rec...

1 reply Last reply on 16 Feb 2014 by
ac3mark

How to convert arabic pdf file into arabic word

Hi all of you I would like to help me which software to convert Arabic pdf into Arabic word and you know most software convert pdf file into word do...

1 reply Last reply on 15 Feb 2014 by
Ambucias

Need macro help

Hello; thanks for viewing this question.... I need help creating a macro, with detailed instructions on how to put it into excel and actually make ...

3 replies Last reply on 14 Feb 2014 by
venkat1926

Microsoft office 7

how i will download free Microsoft office.

1 reply Last reply on 14 Feb 2014 by
ac3mark

Formulas

 Solved

sum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)

2 replies Last reply on 14 Feb 2014 by
Gmooney

Add video in windows 7 ms office powerpoint?

how to add video in windows 7 ms office powerpoint?

1 reply Last reply on 14 Feb 2014 by
ac3mark

For need a help.

can't support file format of office software.

1 reply Last reply on 14 Feb 2014 by
ac3mark

Copy data from current work to another

 Solved

Hi All, Please can you help me with the VBA code which copies columns from current active workbook to another closed workbook at the end of rows.....

2 replies Last reply on 14 Feb 2014 by
Sush

Excel column linking query

Hi, I would like to know how to link one column with another therefore having the second column recognise it at the same. eg Typing a name in colu...

1 reply Last reply on 13 Feb 2014 by
venkat1926

Excel 2007 - conditional format using calendar months

I'm have a workbsheet that has a bunch of dates that show when people have completed their annual training. What I'm trying to do is take the train...

1 reply Last reply on 13 Feb 2014 by
ac3mark

Software

hi may i get a free version of google earth

1 reply Last reply on 13 Feb 2014 by
ac3mark

Conditional formatting from another cell by range

 Solved

Hey, I need helpppppppp i want to change the color of a cell based on the range value of another cell eg. i need a1 to be red if b1 is < 70%, Y...

1 reply Last reply on 13 Feb 2014 by
ac3mark

#value

Hi, am trying to correct a formula. Each time am using this formula: =IFERROR(VLOOKUP(B15;'Liste des Prix Net'!$A$1:$B$8;2;0);(P15/Q15)*(L15/1000)...

4 replies Last reply on 11 Feb 2014 by
TrowaD

Auto sheets .... with common data?

Hello, I would like to have a new sheet generated on open of workbook with sheet name generated in sequence (i.e. main sheet has common data the...

3 replies Last reply on 11 Feb 2014 by
TrowaD

Macro to move mail from inbox to folder

Hello, I am looking for a macro that will move an email item from the inbox of a mail account to a folder in that mail account's inbox. The tri...

1 reply Last reply on 11 Feb 2014 by
TrowaD

How to attach a work book

Hi Sirs, I was asked from a forum member to attach the sample file When I failed to attach as desired. Pl help me regards ansharma

1 reply Last reply on 11 Feb 2014 by
TrowaD

Excel formula

 Solved

I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If nu...

2 replies Last reply on 10 Feb 2014 by
meesh97

Can sent email be edited.....

Hi, I am using office 2007 outlook, just want to understand is it possible to edit an sent email item. If an editing is done in the sent mail then ...

1 reply Last reply on 10 Feb 2014 by
TomTom111

Copying simple form data into new databse

Hello, I'd like to create a simple form that I can then copy into a spreadsheet and will update another workbook for data. My form is very straight...

1 reply Last reply on 10 Feb 2014 by
TrowaD

Compare and return the oldest date

I have a shared workbook comprised of a full report sheet and sheets for individual employees that is being used as a weekly report. Employees enter ...

1 reply Last reply on 10 Feb 2014 by
TrowaD

Excel if help

Hello, I am looking for a function I think an IF statement for some accounts. I want to say IF ( The value in column B="Tom") THEN (Add the v...

1 reply Last reply on 10 Feb 2014 by
TrowaD

Comparision of excel sheets

I just want to ask for your help by providing me codes / references to compare the data in two worksheet, which it means to compare the data in sheet ...

5 replies Last reply on 10 Feb 2014 by
TrowaD

Changing cell color dependent on date in a different cell

Please help. I created an spreadsheet in Excel 2010 for new hires form tracking. I now would like to have cells change colors to remind me that certai...

4 replies Last reply on 9 Feb 2014 by
ac3mark

Code to move a row based on fix values and paste it

 Solved

Hello Gurus, This is my 1st question and I m a beginner in macros .I wanted a code to move a row based on a fix values and paste it in the same shee...

2 replies Last reply on 8 Feb 2014 by
sonkar

Forgot password to one of my data bases (ms access 2007)

does anyone know of a free password recovery tool?

2 replies Last reply on 7 Feb 2014 by
ron7sher

Simple macro

 Solved

I am trying to create a Macro to filling in a series of columns starting with the current cell. simply if cell A1 is selected and you hit the ...

2 replies Last reply on 7 Feb 2014 by
warnerjs
Results 4101 - 4150 out of a total of 12,261