The discussions

If/then formula in excel

I am trying to write a formula that will add a certain number of days to a date, based upon the written response in another cell ie: if H5="Admit/5 D...

1 reply Last reply on 13 Dec 2018 by
TrowaD

Copy rows based on a condition

 Solved

Hi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I...

30 replies Last reply on 12 Dec 2018 by
ravichennai86

Excel vba et pdf

 Closed

Bonjour, j'ai un tableau sous excel et je veux le générer en pdf le problème je veux le converti en pdf mais dans un tableau de modèle différent

1 reply Last reply on 11 Dec 2018 by
ac3mark

How to merge data from different excels

 Solved

Hello, My name is samar. I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I had...

1 reply Last reply on 9 Dec 2018 by
Ratnendra Ashok  

Unable to open a file with openoffice.org

Hello Everyone, I have installed OpenOffice.org 3 where I have been trying to open some Math files sent by my client. All open perfectly but one is...

3 replies Last reply on 7 Dec 2018 by
ac3mark

Master sheet and connecting other sheets

I am trying to make a master list of all my donors for charity. The master list will have less information on it then the following sheets. Bellow a...

3 replies Last reply on 7 Dec 2018 by
vcoolio

Recalculation of dates

 Solved

Hello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell A42...

4 replies Last reply on 4 Dec 2018 by
BlairBiss

Sliding conditional formatting

Hi everyone, I am currently stuck in Excel with the conditional formatting. I would like to apply a color to a cell in column A, row 1 based on a for...

1 reply Last reply on 4 Dec 2018 by
TrowaD

If function in excel refrencing data from another cell

I have a column which has names (these change on a daily basis). I have dates in another cell and I want a formula that says a3="IF the date in cell ...

1 reply Last reply on 4 Dec 2018 by
TrowaD

Excel formula for copying data from one sheet to another

Hello, I have 10 columns and 142 rows of name of person and their details, Is it possible when I edit data from the first sheet, it will automaticall...

1 reply Last reply on 4 Dec 2018 by
Ratnendra Ashok  

How to create custom colors in powerpoint

Does anyone know how to create an additional colour pallet in PowerPoint? One of my clients has given me a template to modify and I've noticed that wh...

6 replies Last reply on 3 Dec 2018 by
mariacasale

Send to via access 2016 "wrong password"

 Solved

I have a customer using Access 2016 with a custom database written by someone else. They were using IMAP but are now on 365. Since this move whe...

3 replies Last reply on 28 Nov 2018 by
kieferschild

Office 2007 installation stops

Hello, I downloaded office suite package 2007 and I'm trying to install it but the installation stops and it's writing "it is not affected by an...

1 reply Last reply on 26 Nov 2018 by
xpcman

Mask cells in excel

Hello, I created a calendar / schedule under Excel with one month per sheet. Depending on the month. So for the month of February, for example, ...

1 reply Last reply on 22 Nov 2018 by
TrowaD

Acrord32.exe - no disk

AcroRd32.exe - No Disk "There is no disk in the drive. Please insert a disk into drive F:" Not sure what this means. Can't close message without r...

1 reply Last reply on 21 Nov 2018 by
Anonymous User

Autofill number from column b based upon text in column a

Hello Is there a way to get excel to autofill a number on sheet 1 that comes from the column "B" on sheet 2; if the text in column "A" matches? ...

1 reply Last reply on 20 Nov 2018 by
TrowaD

Microsoft download

 Closed

Hello, I need a link to download Microsoft office 2010. exe

1 reply Last reply on 19 Nov 2018 by
Anonymous User

Find and replace in excel

Hi, This question is related to Excel 365. I have Sheet1 that has two columns. I Just gave a sample of word abbreviations. It has around 800. ...

1 reply Last reply on 15 Nov 2018 by
TrowaD

Conditional formatting columns

Hello, I would like to know if there is a way to conditionally format a column. I want cells in column C to highlight if they are higher than the ...

1 reply Last reply on 15 Nov 2018 by
TrowaD

Customising slides identity (software)

Hello, The company I work for is going through a merger and all of our presentation are going to be merged. I am aware of the edit master slide...

1 reply Last reply on 14 Nov 2018 by
ac3mark

If function with printing tool

I have 3 column " Nu, Item, QTY" I want to print the cell who has a qty with the same Nu sort. nu item qty 1 ...

1 reply Last reply on 13 Nov 2018 by
ac3mark

Explanation of formula used on conditional formatting

 Solved

Hi, Could someone please be able to fully explain how the following formula works with regards to conditional formatting? =AND(start_of_range""...

2 replies Last reply on 13 Nov 2018 by
Harry

Populate separate worksheets with data from main worksheet based on criteria met

 Solved

Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the...

9 replies Last reply on 12 Nov 2018 by
Anonymous User

Incorrect date while saving csv format

Hello, I am trying to save a csv format of an excel sheet. My sheet has dates from 1 Dec'18 to 31 Jan'19. But when I save the csv file and reopens...

1 reply Last reply on 12 Nov 2018 by
ac3mark

Picking data from a table

Hello, I am going to apologise once again in advance as I am terrible at coming up with the right question when it comes to excel formulas hence why I...

1 reply Last reply on 12 Nov 2018 by
TrowaD

Excel if formula - priority setting

Good day I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option indica...

1 reply Last reply on 7 Nov 2018 by
ac3mark

Vba comparing two files via rows and copy difference to third file

Hello everyone! I'm new to VBA and need your help! I need two compare two files (File 1 and File 2). I need to compare rows in File 2 to rows in Fil...

1 reply Last reply on 7 Nov 2018 by
ac3mark

Copy-paste some grid in excel

Hi All I know this topic is quite old by now but. Haven't found the solution yet. I tried to copy-paste some grid in excell when i noticed. It wasn'...

1 reply Last reply on 3 Nov 2018 by
Anonymous User

Paste value on filtered cells

 Solved

Hello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several cell...

2 replies Last reply on 2 Nov 2018 by
ac3mark

Regarding all fields by selecting individual id

Hello, I have a JSON file it contains 100 IDs and all their details, but when I type ID I need to get entire details of that person from JSON file...

3 replies Last reply on 2 Nov 2018 by
ac3mark

Office enterprise 2007 setup cannot find word.en-us\wordlr.cab

Hello, here's is my problem. On setup, it says that setup cannot find Word.en-us\WordLR.cab. Please help. System Configuration: Windows / Chr...

3 replies Last reply on 2 Nov 2018 by
HarryLui

Excel cell color change from another cell date fill up.

For Example, 1 item due date is 10/Nov/18 & showing yellow color. when the next cell will in-house 9/Nov 18 than the previous date color will move fr...

1 reply Last reply on 1 Nov 2018 by
ac3mark

Compare excel sheets using python

Hello, Can you please solve this question.To compare two excel sheets and copy unlike data to a third sheet which is not deduplicated.Can you plea...

1 reply Last reply on 1 Nov 2018 by
ac3mark

A combination of sumprodcut/isnumber with lookup

Hello all, hoping someone can help CELL (A) I have a question where, I have a column of data where there is a missmatch of data. CELL (B) I ha...

1 reply Last reply on 1 Nov 2018 by
ac3mark

Background formatting from two values drawn from formulas

Hi. I've created a table displaying prices from suppliers. On the end two columns I've added a formula to show the header of the colomn which holds t...

1 reply Last reply on 1 Nov 2018 by
TrowaD

Duplicate line and decrease id number

Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row w...

1 reply Last reply on 31 Oct 2018 by
ac3mark

Conditional formatting using dates/data in an adjacent cell

Hello, I am creating a project status sheet where dates entered in an empty column (Column C) that are past the "planned start date" (column B, hol...

1 reply Last reply on 30 Oct 2018 by
TrowaD

Copy and paste one cell into 48 and then repeat

Hello, I've tried to piece together how to do this function and I feel like it's simple but I need help please! Here's the recording for 2 times. I...

1 reply Last reply on 29 Oct 2018 by
TrowaD

Convert numbers to words

Hello, I want to covert a number 276120 as Two Lacs Seventy Six Thousand One Hundred Twenty but Using above code i can convert the number as Two Hun...

1 reply Last reply on 26 Oct 2018 by
Ambucias

Watermarks and section breaks

Hello, I am trying to create a digital letterhead that has the ability to have multiple pages, but the watermark only on page 1. When additional p...

1 reply Last reply on 26 Oct 2018 by
Ambucias

Inserting pictures from folder using macro

Hello, I would appreciate if someone would help me. I never used macro until today and I searched for a solution but I just don't understand. Th...

1 reply Last reply on 24 Oct 2018 by
ac3mark

Comparing two columns using partial match logic

 Solved/Closed

I need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. ...

2 replies Last reply on 22 Oct 2018 by
patallen8845

Automaticly change currency format in cell

Hello, I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually make...

3 replies Last reply on 18 Oct 2018 by
TrowaD

Copy & paste issue

word properly copying, however pasting while word into incomplete being. (not entire text). just some letters receiving. some places no, word into pa...

2 replies Last reply on 17 Oct 2018 by
scarcity

How can i restore images that saved on word file?

 Closed

Hello! Is there any way via which I can restore some images that I have saved on Word 2013? I have already used some manual methods Like Open and R...

2 replies Last reply on 17 Oct 2018 by
phillcollian

Generate simplified data from raw data

Hello guys, i need help to create some magic from excel. I am a marketer for a F&B, and right now i am in the mid of trying to generate some preci...

1 reply Last reply on 16 Oct 2018 by
TrowaD

Price of ms office word

Hello, What is the price of the microsoft word 2013 after the initial 1-month trial?

1 reply Last reply on 12 Oct 2018 by
Ambucias

Copy rows to rows on another worksheet if " ✔ "

 Solved

Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...

19 replies Last reply on 12 Oct 2018 by
vcoolio

Auto populate weekday from a separate date entry

Hello, I am wanting to do two things: 1. In the first column I want to add in the date, in the second column I want it to automatically insert ...

1 reply Last reply on 8 Oct 2018 by
TrowaD

Vba command button

 Solved

Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will...

10 replies Last reply on 2 Oct 2018 by
vcoolio
Results 551 - 600 out of a total of 12,258