The discussions

Date entered wrongly

Hello, I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024'..how do I correct all such entries, if ...

1 reply Last reply on 11 Aug 2017 by
ac3mark

How to highlight a row when i enter a date in column i

Hello, I am trying to highlight a row when I enter a date in column I. How is this achieved?

1 reply Last reply on 11 Aug 2017 by
ac3mark

Copy specific number of rows and insert n time after 3 rows

Hello, Please help I want to Select & copy 35 rows data and after 3 rows I want to insert the copied rows n number of times. I need the Row widt...

1 reply Last reply on 11 Aug 2017 by
ac3mark

Highlight only one column which has greater value

 Solved

Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...

3 replies Last reply on 11 Aug 2017 by
Mazzaropi

Office 2007 files will not open

 Solved

Hi.. I am Dipu Michael from India. I am using the software office2007 in windows7.For the checking purpose I installed 0ffice 2003 in my system. Afte...

1 reply Last reply on 10 Aug 2017 by
xpcman

Date conversion in excel

Hello, how to convert birth date in word in MIcrosoft excel

1 reply Last reply on 9 Aug 2017 by
xpcman

Consolidate data from multiple sheets to one sheet.

Hello, I have a workbook containing customer data (name, contact #s, addresses, etc.). The workbook is broken down into sheets according to which ...

3 replies Last reply on 9 Aug 2017 by
vcoolio

Microsoft publisher 2010 ask product key,

 Closed

I downloaded microsoft Publiser 2010 but now they ask product key, where can I find

5 replies Last reply on 9 Aug 2017 by
pan

Auto update hyperlink on the other sheet

Hello guys =) Please help... I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the I...

3 replies Last reply on 8 Aug 2017 by
eunice3301

Replace 2007 office word

Hello, I have received an e-mail that my Office 2007 is being retired and I will need a new key. My computer is a Microsoft 10 system. Do you have a...

2 replies Last reply on 6 Aug 2017 by
xpcman

Excel if statement with multiple text values in a column

Hello, I am using excel 2017. I am trying to use this if statement to give me a value of 1 or 0. =IF((CQ2="Computer");1;0) The problem i...

1 reply Last reply on 5 Aug 2017 by
Mazzaropi

Excel 2016 filters do not work

Hello, My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filt...

1 reply Last reply on 4 Aug 2017 by
ac3mark

Vba code to range of days

Hello, Please help guys... I have a code below: Sub Auto_Open() Dim r As Long For r = 2 To 53 If Range("I" & r).Value = Range("I...

4 replies Last reply on 3 Aug 2017 by
ac3mark

Enter current time in a cell by clicking it

 Solved/Closed

Hello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to fil...

27 replies Last reply on 2 Aug 2017 by
avega

Powerpoint stop working

i have downloaded Microsoft office 2010 but unfortunately, power point is not working please help me

1 reply Last reply on 2 Aug 2017 by
Ambucias

Conditional formatting

Hello, If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good"...

3 replies Last reply on 1 Aug 2017 by
Mazzaropi

Vba worksheet data transfer

hello, I haven't done anything with code for years and I am so lost in this, I have a table on sheet 1 which goes from A-J and 1-8221 and conta...

5 replies Last reply on 1 Aug 2017 by
Unhappydoughnut

Run all vba at once after opening excel file

Hello, Please help me. I want to run the macros at once after opening the excel file. I have different codes in each sheet. Please i need yo...

2 replies Last reply on 1 Aug 2017 by
eunice3301

Looking up 2 columns and displaying 3rd column on new sheet

I am trying to figure out how to display the color onto a second worksheet. If column a=1 AND column b=1, then I want the value of C2 displayed on...

1 reply Last reply on 31 Jul 2017 by
ac3mark

Office 2013

Hello, i need office 2013 System Configuration: Windows / Chrome 60.0.3112.78

1 reply Last reply on 31 Jul 2017 by
Ambucias

Run a macro only for specific cells

Hello, can you please help me with one problem I am currently having with Excel Macro? I want to be able to run a macro only for specific cells .....

2 replies Last reply on 31 Jul 2017 by
PeriGr

How to repair xlsx excel 2010 microsoft file?

 Closed

Hello, How to repair xlsx Excel 2010 Microsoft file? I see a file with non-zero size but cannot open it. System Configuration: Windows / Chrome...

2 replies Last reply on 31 Jul 2017 by
Priyanka

Installing office 2010

 Closed

Hello, Downloaded Office 2010 for home and student but having problems installing. Please advise how to resolve the downloading problem. Tha...

1 reply Last reply on 30 Jul 2017 by
xpcman

Enter data into a master sheet to update subsequent sheets.

I'd like to be able to enter data into a master spreadsheet which will update other spreadsheets to prevent me from having to enter the same data seve...

1 reply Last reply on 30 Jul 2017 by
vcoolio

How to recover my important file of ms word

Hello, i was created one MS word document file in document folder, my windows was corrupted then i format disc c & install new win 7 but now...

1 reply Last reply on 29 Jul 2017 by
Ambucias

Search and code

Hello, so I have this problem in excel where I need to compare the words that are in a certain cell and compare them to the separated word if it finds...

4 replies Last reply on 28 Jul 2017 by
stankirsolkar

Macro code help - copy row based on criteria paste on one sheet

Hello, I have a spreadsheet that is tracking sales number from multiple sales people. Each person has their own tab & all the columns are the same...

1 reply Last reply on 28 Jul 2017 by
ac3mark

Auto populating data

Hello, i have to daily update supplier name, part name , part number to my daily list . i want it to auto populate this to all my master-sheet , i ...

1 reply Last reply on 28 Jul 2017 by
ac3mark

Formulas

I know the basic but I am trying to formulate cells that will automatically that when you enter a figure in the cell it will multiply that said number...

3 replies Last reply on 28 Jul 2017 by
ac3mark

Automatically insert rows in associated spread sheets

Hello, I have created an accounting workbook of 15 sheets to produce accounts and associated information for a group of around 85 people. The names...

2 replies Last reply on 28 Jul 2017 by
ManxEd

Formatting a cell containing text

I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within th...

1 reply Last reply on 28 Jul 2017 by
stankirsolkar

True or false value based on 3 difference cells' criteria

 Solved

Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...

1 reply Last reply on 26 Jul 2017 by
ac3mark

Copying rows with data from multiple sheets to one master sheet

Hi guys, I'm trying to figure out how to copy rows from multiple sheets with values in column Q to a master sheet. I have seen a set of codes a...

1 reply Last reply on 26 Jul 2017 by
vcoolio

Saving input into 2nd worksheet while keeping the 1st empty

Hi there, Spoiler alert: Excel dummy I hope you can help me with this. I need to have a worksheet that would be used on daily basis and can be ...

1 reply Last reply on 25 Jul 2017 by
TrowaD

Compare and separate data

Hi, I am obviously new to the forum here, but I came across a question kind of inline with my own on here and wanted to see if I could get some hel...

3 replies Last reply on 25 Jul 2017 by
TrowaD

Acrobat reader gets the error

Hello! The problem is that: I downloaded a PDF fixe document, when read with Acrobat Reader gets the error: "an error Occurred while opening this docu...

6 replies Last reply on 25 Jul 2017 by
withers

Inventory master list help

Hello, So I have a workbook with an inventory master list that i would like to pull inventory numbers from all of the other sheets in my workbook....

1 reply Last reply on 24 Jul 2017 by
ac3mark

Record scenario iteration results macro

Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...

1 reply Last reply on 24 Jul 2017 by
ac3mark

Converting data in one column spanning three to four rows

dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...

5 replies Last reply on 21 Jul 2017 by
BrianGreen

Product key

 Closed

hi, how can I get my product key for Microsoft office 10 free?

1 reply Last reply on 21 Jul 2017 by
xpcman

Macro for coloring cells according to the value of the cell

Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...

1 reply Last reply on 20 Jul 2017 by
ac3mark

Macro for coloring cells according to the value of the cell!

Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...

1 reply Last reply on 20 Jul 2017 by
ac3mark

Repeating a simple macro loop up to 1,500 times

 Solved

Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...

5 replies Last reply on 20 Jul 2017 by
TrowaD

Excel external data connection not working properly

 Solved

Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...

1 reply Last reply on 19 Jul 2017 by
kvil

Html to pdf convertor licence cost?

Hello, SWP: HTML TO PDF Convertor (Full packedge) what is the cost for an enterprise one/unlimited user license for a year? thank you Mor Sagr...

1 reply Last reply on 18 Jul 2017 by
ac3mark

Conditional row copy/consolidate

Hello, I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolle...

3 replies Last reply on 18 Jul 2017 by
ac3mark

How to create a macro to copy and paste

How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in colu...

3 replies Last reply on 18 Jul 2017 by
ac3mark

Macro for coloring cells depending on values and presenting them

Hello guys!! I have an excel file with 2 columns of percentages. The first column has theoretical values of an experiment and the second column has...

1 reply Last reply on 18 Jul 2017 by
TrowaD

Ms office 2010 installing problem

kindly solve my problem with ms office 2010

1 reply Last reply on 15 Jul 2017 by
xpcman

I need to create a formula if with dates and 2 variables

Im trying to create the following formula in excel If theres number greater than 0 in a column and if the date in the other column is before one mon...

1 reply Last reply on 15 Jul 2017 by
Mazzaropi
Results 1151 - 1200 out of a total of 12,258