The discussions

How to number counting

How to cell number count?

Last reply on 22 Feb 2018 by
ac3mark

Convert number to words in excel

Hello, how to convert numbers to words in excel like 113 as one one three.

Last reply on 22 Feb 2018 by
TrowaD

Excel lookup 2 cells to match in 2 rows.

 Solved

Hello, I am using Excel to makes archives of PC issues we have in our compagny I have Info that i have to write in two cells that are standard...

Last reply on 22 Feb 2018 by
mm

Row conditional formating in excel

 Solved

Hi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text....

Last reply on 22 Feb 2018 by
Mazzaropi

Vba question

Hi Trowa (experienced VBA help community), Sorry if my earlier posted question was not clear. Here is the situation: Sheet" Initial": A (Fir...

Last reply on 21 Feb 2018 by
ac3mark

Pick up dates from column f which are greater than

Hello, I need help with a vba code logical statement I have a worksheet1 where c19 is start date and d19 is end date. There is another sheet who...

Last reply on 20 Feb 2018 by
ac3mark

Corrupted excel file

 Closed

All of my excel documents are stored on working pc. Something happened with one of it, I don't know the reason, but some days ago I opened it as usual...

Last reply on 20 Feb 2018 by
Herald76

Microsoft product key

 Closed

Where to find the product key for microsoft 2010?

Last reply on 20 Feb 2018 by
Ambucias

Subtracting amounts from a fixed amount

Hello, I need a equation for subtracting amounts that i entered from a fixed amount. Here is my screen shots. I enter 10000 in row 1 column A ...

Last reply on 17 Feb 2018 by
Mazzaropi

Autopopulating new sheet based on an ans in 1 cell

Hi, Hoping you can help. I need a solution whereby if I select a certain value from a drop down list it will autopopulate that row of data in a sep...

Last reply on 16 Feb 2018 by
Mazzaropi

Tally shortcut doesn’t open

Hello, My tally shortcut is not opening , i reinstall it but now my old data is missing how i get my old data OR old tally System Configuration...

Last reply on 15 Feb 2018 by
ac3mark

How to automatically input a word into one cell

Hello, I’m having a hard time trying to figure out how to automatically input a certain word into one cell if a different cell is less than anothe...

Last reply on 15 Feb 2018 by
ac3mark

Copy and paste data upon click

I have a set of data on A2 to A10. When I hit cell A2 which contain the word "January", the data will be copied into B2. If I hit cell A3 which co...

Last reply on 15 Feb 2018 by
ac3mark

Resizing of column & rows in macro

Respected CCM team members, Greetings!! I am trying to insert images from a folder into excel by matching file names specified in a column, ever...

Last reply on 15 Feb 2018 by
TrowaD

Highlight help

 Solved

Hello, I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am needi...

Last reply on 14 Feb 2018 by
Mazzaropi

Macro to compare the 3 columns "sec code

Hi All, I would really appreciate your help in providing me with a macro to save me some time on the following. 1- Everyday i receive 2 reports ...

Last reply on 13 Feb 2018 by
ac3mark

How to save a copy of an excel sheet using macros?

Hello, excel guru's, I am struggling with a problem which should be easy (i think), but with my lack of knowledge of VBA i am stuck. I have an...

Last reply on 13 Feb 2018 by
ac3mark

Counting sites visits within a year

 Solved

Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits ...

Last reply on 13 Feb 2018 by
Mazzaropi

Compare data in two columns

Hello, Q 4 U - pls and thank you CCC=characters/letters NNN=numerics Trying to compare these two columns and identify partial matches betwe...

Last reply on 12 Feb 2018 by
ac3mark

Color fill and conditional formatting

Hi, I'm running Excel 2013 on a Windows 7 Ultimate box, and I have a spreadsheet containing 14 columns and 253 rows. I've made one column, where I ...

Last reply on 12 Feb 2018 by
ac3mark

Need different data each time from different sheet

So I'm making an invoice form in which i need to insert data from another excel, which is a list that includes names/e-mails/amount paid/etc. Is the...

Last reply on 12 Feb 2018 by
xpcman

Need a search function

i have BPS in cell A1 and the pay Cell A2 on sheet 1 and on sheet two i have a data in this range g3:aj23 now my question is for example my A1 ce...

Last reply on 10 Feb 2018 by
Mazzaropi

How to find the product key for ms office 2010?

salam , i want to know the product key for ms office 2010 I just dowloaded from this site .. please help me

Last reply on 8 Feb 2018 by
raj

Microsoft icons changed to white generic icons

Hello, my all ms office (ms word,ppt etc)icons are gone with white generic icons everything is working fine but icons are missing ,icons do sh...

Last reply on 8 Feb 2018 by
ac3mark

How to apply conditional formatting

 Solved

I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and unhighligh...

Last reply on 8 Feb 2018 by
smith145

Copy cell data to next row for multiple cells

Hello, Need help copying cell data to next row for multiple cells. e.g. Source data - A1 Cat A2 (blank cell) A3 Dog A4 (blank cell) A5 Hen...

Last reply on 7 Feb 2018 by
bmr12

Conditional formatting (highlighting)

Hi, I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and un...

Last reply on 7 Feb 2018 by
ac3mark

Copy multiple rows and transpose to one row

Hi! I am trying to copy multiple rows of a spreadsheet and transpose them into one column of another spreadsheet. I know how to do this one row at ...

Last reply on 7 Feb 2018 by
ac3mark

Copying rows to another sheet

I'm looking to copy certain cells in a row to a new sheet if another cell meets certain criteria. If column O has "Yes" i need to copy cells A-F o...

Last reply on 7 Feb 2018 by
ac3mark

How to copy data to a different worksheet?

 Solved

Hello, I would like to copy data from a specific cell of a worksheet and paste into a specific cell in a different worksheet Eg from cell b2 of a l...

Last reply on 7 Feb 2018 by
vcoolio

How to install microsoft office 2010

i have require total micro office for window10 i was recently updated window 10 so they can removed th micro soft office file is remove so please he...

Last reply on 7 Feb 2018 by
Ambucias

How to send automatic email from sharedrive

Hello, I have to send a tracker automaically to my lead at eod everyday from sharedrive. Can anyone pls help me in this??

Last reply on 6 Feb 2018 by
ac3mark

Conditional formatting - dates

 Solved

Hello, On a spreadsheet, the cells in column N contain a date. I need any date that is 6 weeks ago or longer to be highlighted. How do I do ...

Last reply on 6 Feb 2018 by
BethanMary4

Rearrange multiple columns in four columns, vba

 Solved

Hello guys, An excel rookie needs the help of more experienced users of Excel and VBA. I have a data set that looks the following way: There ...

Last reply on 5 Feb 2018 by
ac3mark

Copy data to multiple excel sheets after creating

Hello, I have a standard template excel file - excel.xls. I have a list of servers in a text file - names.txt. I want to create multiple files of ...

Last reply on 5 Feb 2018 by
ac3mark

Sorting 2 columns of names with the same 2 columns& limited rows

Hello, I am looking for some help with an Excel Spreadsheet. I have an Excel Spreadsheet with room for only 2 columns and 5 rows. I am tryi...

Last reply on 5 Feb 2018 by
ac3mark

Trying to autopopulate multiple spreadsheets

I have a workbook with contact and personal information of an organisation. I would like to have this information auto populate to separate sheets in ...

Last reply on 5 Feb 2018 by
TrowaD

Matchpoint score

 Solved

hello I hope that someone can help me. I have an excel sheet in which I record scores of teams and I would like a formula to calculate the points acc...

Last reply on 5 Feb 2018 by
Mazzaropi

Can't reinstall office 2010

 Solved

Can't reinstall Office 2010. Always get a notice that an error has happened and it will not install !

Last reply on 4 Feb 2018 by
Ambucias

Copy data into new rows (row 2, 3, 4, et cetera)

To Whom It May Concern: I'm trying to get data that's already made into a different part of the same sheet. I want to make sure it's recorded in o...

Last reply on 2 Feb 2018 by
ac3mark

How to change text formating in a cell?

Hallo!! I am working on a dictionary and I want to change the formating of the text of column B by setting prerequisites. Example: "Απαλλοτρίωσ...

Last reply on 2 Feb 2018 by
BrianGreen

Adobe reader and outlook crash

hello, whenever I open a pdf file, the attached error comes. how can I fix this?

Last reply on 2 Feb 2018 by
xpcman

Formula to return cell value in excel

Hello, System Configuration: Windows / Chrome 51.0.2704.106 I am trying to configure a formula that returns the value of a cell if is not b...

Last reply on 2 Feb 2018 by
BrianGreen

How do i get access to a pdf converter

How do i get access to a free pdf to excel converter on this website?

Last reply on 2 Feb 2018 by
xpcman

Yahoo id and password hacked

 Solved/Closed

Hello, My Yahoo ID and password has been hacked by someone, coz of that I could I m unable 2 log in. Plz help me out and dont send a mail to t...

Last reply on 2 Feb 2018 by
sahil

Populate data

I need to auto-populate data from a master worksheet into multiple worksheets, while having the ability to add/delete rows in the master worksheet. Th...

Last reply on 31 Jan 2018 by
ac3mark

How to match contents in 2 separate cells?

I have data in 2 separate cells. I need a formula that will pick out the first 3 characters from each cell and show if a match (true/false). Any hel...

Last reply on 30 Jan 2018 by
TrowaD

Copying data from an excel 2010 table to a string or word file

Can anyone help me please with the following problem: Search in Col A of an Excel Worksheet table for expression 'Employee' (exact cell location in Co...

Last reply on 29 Jan 2018 by
ac3mark

Files that were in docs have changed to e

Hello, Please help me I am so confused now,my file that was in docs had changed to E for internet and I don’t know how to get it back. Please h...

Last reply on 28 Jan 2018 by
Ambucias

Compare values in two columns and return the value from third

Hello, I have a table containing three columns. Column A shows the status of a product, "To Review", "Under Review", "Review Completed" Column...

Last reply on 26 Jan 2018 by
jtliapp
Results 851 - 900 out of a total of 12,264