The discussions

How can i start a spreadsheet at windows login.

 Solved

Hello, How can i start a spreadsheet at Windows login. The normal simple way does not work. Thank you, Mondriaan

2 replies Last reply on 18 Feb by
Mondriaan

Adding buttons to an excel spreadsheet.

 Solved

Dear CCM Team, How do you add a button on a particular cell in an excel spreadsheet to turn it on and off. Example: If I want to add a column of nu...

1 reply Last reply on 6 Feb by
RachelGreen

Pop up message in excel (like outlook agenda)

 Solved

Hello, I have a big file in Excel with heaps of information about my customers. One of the coloms is telling me when I need to send them a letter....

3 replies Last reply on 5 Feb by
GeekMako

Monthly production report -automatic transfer of data

 Solved

Dear All, I am looking for a solution to generate monthly production analysis report of an operator for his daily production. Attached sample sheet...

10 replies Last reply on 2 Jan by
gannesh0604

Product key

 Solved

Please where can I get the product key of Microsoft office 2010

1 reply Last reply on 9 Oct 2023 by
HelpiOS

Print 1 document in a5 size - change doc size to a5

 Solved

Hi, How do I get an A5 document for 1 project only - greetings card

1 reply Last reply on 2 Oct 2023 by
HelpiOS

Fill adjacent cell with number from text answer

 Solved

Hello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down ...

20 replies Last reply on 25 Aug 2023 by
vcoolio

Create folder in desktop with vba, if exist, ignore

 Solved

Hello, How to create folder in desktop with vba whenever the excel book is opened, if exist, ignore. Message if create new folder, silent if th...

6 replies Last reply on 12 Aug 2023 by
praveen

Dependent (cascading) drop down list in excel

 Solved

Dear All, Please help me on the below . I have a data validation drop down list with unique values in cell G2. These values are job numbers from C...

15 replies Last reply on 7 Aug 2023 by
gannesh0604

Combine sheet in master spreadsheet with auto update

 Solved

Hello, I have 24 sheets in the same Excel document with identical headers I`d like to combine in the master spreadsheet the way if any data is insert...

6 replies Last reply on 31 Jul 2023 by
vcoolio

Copy data from one excel sheet to another: automatically

 Solved

Dear all, Anybody can help me please. I have MAIN DATABASE ( sheet 1) of column names : Serial No, Service type, Job No, Date, Customer name, desc...

10 replies Last reply on 27 Jul 2023 by
vcoolio

How do i make all rows the default height in excel?

 Solved

Hello, How do I make all rows the default height in Excel?

3 replies Last reply on 13 Jul 2023 by
HelpiOS

Copy and paste to internet creating whitespace problem

 Solved

Hello, I created a body of text in Open Office Writer and tried to post it as a question on the website Less Wrong. A moderator rejected it for, as w...

1 reply Last reply on 8 May 2023 by
HelpiOS

Date of birth number to words

 Solved

Hello, 05/05/1981 How to write data of birth in word

2 replies Last reply on 26 Apr 2023 by
Jane

Multiple sheets to one master sheet update

 Solved

Hello, We are a team of 8 who updates a single excel work sheet, and because of this, there is always information missing or overwritten by others et...

13 replies Last reply on 12 Apr 2023 by
vcoolio

How can i fix hotmail if it keeps freezing or crashing?

 Solved

I am using Hotmail and now my Hotmail keeps freezing or crashing. Please suggest reasons and solutions for it.

2 replies Last reply on 3 Apr 2023 by
blackmafia

How can i format multiple presentations automatically?

 Solved

Hello, I have a lot of presentation and I want to format every ppt to the same font and rate automatically. How can I to do it?

1 reply Last reply on 12 Feb 2023 by
HelpiOS

How to calculate positions (1st,2nd,3rd...) in excel

 Solved

Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i...

6 replies Last reply on 12 Dec 2022 by
TrowaD

How to convert the tamil pdf file to tamil word file

 Solved

plz give the solution

12 replies Last reply on 10 Dec 2022 by
karthik

I can not control the transitions in powerpoint in my file,

 Solved

Hello, the slides of my PowerPoint moves before the first slide finishes, and sometimes it takes ages to move to another slide. I would like the sli...

2 replies Last reply on 9 Nov 2022 by
Pablo453

"enter to add a blank slide" doesn't work anymore

 Solved

Hello, I used to be able to add a blank slide in PowerPoint by simply pressing the "Enter" key. For some reason, I found this function did not work a...

1 reply Last reply on 8 Nov 2022 by
TrowaD

Coloring cells in sheet 2 based on data sheet 1 excel vba

 Solved

Hi!  I would like to ask a question about using VBA for colouring a cell in sheet 2 based on a value of a cell in sheet 1. I want to write a code in ...

4 replies Last reply on 4 Nov 2022 by
Sue-Ellen1994

Udf for attendance register

 Solved

Hello, I have used your UDF as shown below to report a date whenever an entry is made in a row of my excel sheet. Function LastAttendanceDate(mDate...

2 replies Last reply on 3 Nov 2022 by
Slinger42

Formula to find last date of attendance

 Solved

Hello, I have an excel sheet that enters the time taken by each student on each day for the whole month. The student names are in the rows and d...

3 replies Last reply on 3 Nov 2022 by
TrowaD

How sum the column value in excel via vba based on criteria?

 Solved

Hello All, I would like to sum up the column value based on the following criteria (TRUE or FALSE). I have a value in the "E" column and in the "F" c...

2 replies Last reply on 10 Oct 2022 by
TrowaD

Unable to reply to emails

 Solved

Can someone advise me how to conquer this sudden difficulty? Emails arrive, I can read them, but when I click "Reply" nothing happens. Why? Than...

2 replies Last reply on 23 Sep 2022 by
Peter

Office 365 product key

 Solved

Hello, Hello. How to activate Office 365 product key. I couldn't do it :)

1 reply Last reply on 21 Sep 2022 by
HelpiOS

Apply conditional formatting across several cells

 Solved

Hello, I want to change the color of a row if there is text in column A of that row.  I have the following equation: "=AND(ISTEXT($A$2))" ... and I h...

2 replies Last reply on 12 Sep 2022 by
rdavis

How to add rows automatically based on cell value in excel?

 Solved

Hi All, I have a requirement to add the Rows Based On Cell Value In Excel. Below I have attached the snapshot of the requirement details. I have two...

7 replies Last reply on 12 Sep 2022 by
TrowaD

Populate values in textbox based on combobox ,optionbutton

 Solved

Hello, I  have  the  items  in column B  in sheet1,2,3   and  the  prices  in columns F,G  for sheet1,2      and  the  prices  for columns F  for  sh...

6 replies Last reply on 9 Sep 2022 by
Mussa_8911

Running a macro in different cells

 Solved

Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...

4 replies Last reply on 5 Sep 2022 by
Helmy

Generating invoice number automatic without repetition

 Solved

Hello, please I need help , I want VBA CODE  to Generating invoice number  automatic without repetition in my excel any time type in the next cell it...

3 replies Last reply on 25 Aug 2022 by
TrowaD

Macro to automatically update a master sheet from multiple sheets

 Solved

Hello, I have a file with a master sheet and 6 different individual sheets. Each sheet is considered a project. It includes person's information a...

17 replies Last reply on 16 Aug 2022 by
TrowaD

Working with multiple worksheets in a workbook

 Solved

Hello, I am completely new to all of this so please bear with me. I am new to forums and how they work so I apologize in advance if this is a repeat ...

7 replies Last reply on 11 Aug 2022 by
vcoolio

How to lock in specific cells in a formula going down rows

 Solved

Hello, I am having an issue with easily repeating a formula I've made. the formula is =IF(AP2=Sheet2!K3,Sheet2!L3,IF(AP2=Sheet2!K4,Sheet2!L4,IF(...

2 replies Last reply on 27 Jun 2022 by
JoshL

Hello friends. please help ! countif formula ?

 Solved

Hello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12"...

3 replies Last reply on 13 Jun 2022 by
TrowaD

Automatically update one sheet from multiple other sheets

 Solved

Hello, I have a workbook with each office location having its own sheet to keep track of project information all with the same column headings. Co...

7 replies Last reply on 20 May 2022 by
vcoolio

Summing values based on matching column across sheets

 Solved

Hello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...

6 replies Last reply on 26 Apr 2022 by
leapout

How to copy data after at a fixed cell

 Solved

Hello, I have the following data for which it needed to be copied on another sheet after a gap of 7 cells for each entry in Sr No. column. Li...

2 replies Last reply on 13 Apr 2022 by
skprma

Autogenerate alphanumeric id numbers in excel?

 Solved

Hiya! Let me start off by saying I am NOT a tech person so I don't even know if this is possible. I am trying to create an excel sheet where I can ...

3 replies Last reply on 2 Mar 2022 by
vcoolio

Search across all open workbooks for user defined criteria

 Solved

Here is my problem - we store info into files that use an index number (changes with each file created) plus 2 criteria to keep track as we produce ma...

5 replies Last reply on 1 Mar 2022 by
TrowaD

Auto-fill items repeatedly for two sheets based on another

 Solved

Hello, I have two sheets(FIL1,FIL2) should auto fill some items into column A repeatedly . it depends on sheet REP after matching based on colum...

3 replies Last reply on 24 Feb 2022 by
TrowaD

Copying a row based on a integer in a cell

 Solved

Hello, I am needing help making a macro that will allow me to do a number of things, that may or may not be able to be done with one single macro. (...

5 replies Last reply on 24 Feb 2022 by
TrowaD

How split column into multiple columns for multiples sheets

 Solved

Hello, I need macro to split column C for sheets REP1,PROC1 into columns C,D,E based on matching column B with column B into sheet RP ...

6 replies Last reply on 15 Feb 2022 by
Hasson_6770

Match & add missed items between two sheets

 Solved

Hello, I have two sheets contain the same structure of data . the result should show in column B,C into sheet2 based on matching with sheet1 . ...

12 replies Last reply on 8 Feb 2022 by
TrowaD

How to add rows that meet specific conditions

 Solved/Closed

Hi Every week at work we get data about new jobs that have been completed at our company, and I add that data to a raw data tab. In the summary tab...

1 reply Last reply on 28 Jan 2022 by
vcoolio

Changing values in one cell depending on drop down

 Solved

Hello, I created a drop-down list of scores (ie. 10, 20, 30 to 100) in cell A1. In cell B1 I want it to show a specific number value based on which...

3 replies Last reply on 21 Jan 2022 by
vcoolio

Conditional formatting: change fontcolor based on another cell

 Solved

Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...

18 replies Last reply on 3 Jan 2022 by
Ravi

Excel formula with changing rows going in order

 Solved

I am mapping one cell to another spreadsheet and I trying to figure out how to change the row without having to manually change each line. For example...

1 reply Last reply on 3 Jan 2022 by
TrowaD

If function: conditionally multiplying a value

 Solved

Ok so I am trying to create a formula that would use a different calculation based on an answer. So when I get the number 2 in a cell then the data us...

1 reply Last reply on 20 Dec 2021 by
TrowaD
Results 1 - 50 out of a total of 2,602