The discussions

Power query editor data source settings multiple users

-In power query editor, how can I make the file path dynamic? Multiple users need to be able to run the power query. But each file path will be differ...

Reply

Simple date subtraction excel

 Solved

-It seems soo simple, yet I haven't been able to find the solution. I need to display a date that is five years in the past from today. -I tried a co...

2 replies Last reply to 08:24 by
Eagleeyes011

Add date function to this code

 Solved

Hello all, I am looking to add a date function to cell J (or whatever column/cell I need it to be) after this code performs its actions.  Currently ...

13 replies Last reply on 21 May by
vcoolio

Where can i get the license for doctranslate software

Where can I get the license for doc translate software?  Thank you.

Reply

New version v-tools available?

 Solved

v2016_183 was great, however is there a version for Access2021-64bits available?

2 replies Last reply on 29 Apr by
HelpiOS

Download odbc drivers 64-bit for access

 Solved

Hi, I need to download 64-bit ODBC drivers for Access Thanks

1 reply Last reply on 19 Apr by
HelpiOS

How can i et product key for ms office 2019

Hello, Where can I find the product key for MS OFFICE 2019? Thankyou. Edith

Reply

Office 2010 product key?

 Solved

What's office product key? 

2 replies Last reply on 12 Apr by
HelpiOS

Double condition formula based on drop down selection

Hi All, I have an excel file with sheet names : Primary Data sheet, Ground floor, First Floor and readings. I need this file to capture printer usage...

1 reply Last reply on 16 Mar by
BoBot  

Tamil word to pdf converter

 Solved

how to convert tamil word document to pdf document

2 replies Last reply on 19 Feb by
jolasmith23

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

Automatically send emails from excel based on cell date

Hi All, Please help me anybody. I am suffering with sending email from excel automatically ..Please see attached screen shot for your reference :   ...

3 replies Last reply on 24 Jan by
Jiyahana

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

Copy data from one excel sheet to another: automatically

Dear All, Anybody help me to transfer the data from main database sheet to other sheets based on sheet name condition. i.e., The data from B6 to Q6 f...

Reply

Spacebar adding lines

spacebar adding lines under dots.  Dots equal spaces,, but lines don't go away when removing the character symbol in the ribbon.  Can't get rid of the...

Reply

If cell z2 contains a date, show 'yes' otherwise show no

Hello, I am trying to get my sheet to show a Yes Field when a date is entered. But a no field at any other input, weather thats 'n/a' or blank or any...

1 reply Last reply on 21 Dec 2023 by
BoBot  

Ms office 2010 activation key

How to use micro soft office 2023

Reply

Change phone number on email account

The phone number used for security on our email is not in srvi ce any more. How can we  change it?

Reply

How can i get prodoct key for office 2010

kindly help me to activate microsoft office 2010

Reply

Powerpoint problem

Hello, I can not save anything onto my powerpoints ,  I get the same window telling me either that it is a read only ( which I have changed each tim...

1 reply Last reply on 3 Nov 2023 by
HelpiOS

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

Change color of cell automatically

I am working on excel . want to change color of cell  automatically  as per color of another cell. Color of another cell changes automatic as per form...

Reply

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

Best pdf to png options?

Hello, We are looking for a pdf to png converter and have found the following tools online and we are wondering if anyone has used these and if so wh...

1 reply Last reply on 31 Jul 2023 by
HelpiOS

Excel formula: ​ two financial year ends for one client

Hello, Thank you so much for putting time aside in helping me with the following formula. In Column O on the Main sheet, I do a VLOOKUP from the mas...

Reply

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

Formula assistance in excel

Hello, I hope this message finds you well. I'm reaching out for some assistance with a Microsoft Excel formula-related question that I recently came ...

Reply

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

I have an external hdd that's a 500gb

My external has information that I dont want to lose  It keeps on saying "windows can't access the disk" or "A device which doesn't exist was specifi...

2 replies Last reply on 2 Jul 2023 by
ravida_1351

How do i change the backgroud of a cell or a whole section?

Hello, I have a question. How do I change the backgroud of a cell or a whole section? I want to differentiate one set of data from anoter set based...

1 reply Last reply on 15 May 2023 by
Aron_7608

How do i set the height of rows in excel all at once ?

Hello, How do I set the height of rows in Excel all at once instead of doing them one click at a time by clicking and dragging and dropping the indic...

1 reply Last reply on 15 May 2023 by
Aron_7608

Excel macro to duplicate info based on value in another cell

I am creating a work book that has a range of cells (C6:E34) that are considered one "Location", and another cell (D5) to input the number of location...

1 reply Last reply on 15 May 2023 by
Aron_7608

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 not to show false in the following example.

Hello, I wish the formula to return a blank cell if there a blank cells in the formula. =IF(C27="BUY",((D30-D27)*10000),IF(C27="SELL",((D27-D30)*1000...

1 reply Last reply on 12 Mar 2023 by
Herminaandrews

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

Drop down

Hello, I have a workbook with one main sheet and lots of rows to be filled. There is one column with a drop down with 3 selection. How can I copy ...

3 replies Last reply on 10 Feb 2023 by
vcoolio

Export video - no audio file

Hello, I want to generate a video from a pps with music/media file and it only takes it without that (media) file. It is a wave file and its size is ...

1 reply Last reply on 6 Feb 2023 by
HelpiOS

Create multiple workbooks with template at once

Hello, I'm being tasked with copying a single workbook with a special layout in it and copying it about 90 times with the file name corresponding to a...

4 replies Last reply on 16 Jan 2023 by
Dak903

Adding last week position to a weekly record survey

Hello, I am compiling weekly record charts of the most popular records. How do I add the last week position to each song on each new record list in E...

1 reply Last reply on 16 Jan 2023 by
TrowaD

How to pull data from column based on multiple criteria?

Hi Expert, I'd like to combine a column value in Mainsheet, where the column values are pulled from Sheets 1 and 2 of the same Excel file using VBA c...

3 replies Last reply on 16 Jan 2023 by
TrowaD

Copy a data from one sheet to another

I have a Master list (Sheet 1) that contains house numbers and personnel assigned to them. I want to copy the entire row with the data assigned to eac...

3 replies Last reply on 27 Dec 2022 by
TrowaD
Results 1 - 50 out of a total of 12,264