The discussions
Macro in excel
Closedbonjour je bloque sur ma macro depuis plusieurs jours et j'aurais besoins d'aide j'ai un listing de 13 colonnes qui peut aller jusqu’à 50 lignes m...
Copy rows n times in excel
SolvedHello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...
Copy data from first sheet to other in excel
I have a workbook for tracking service customers. I would like for some of the data entered in the first sheet (first name, last name, date & email ad...
Excel conditional formula
Hello, I need to fixed date (not change by everyday) when A1 CONTAIN certain text like (IR) B1=Fixed date
Vba to compare column e from 2 sheets and copy entire row to sheet 3
SolvedHello, I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to then co...
Excel function question
Hello, Which spreadsheet function in Excel will display 6 as the output in the following formula? =(36)
Excel formula to track accrued vacation
SolvedHello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they earn P...
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...
Copy rows based on a condition
SolvedHi 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...
Excel vba et pdf
ClosedBonjour, 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
How to merge data from different excels
SolvedHello, 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...
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...
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...
Recalculation of dates
SolvedHello, 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...
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...
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 ...
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...
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...
Send to via access 2016 "wrong password"
SolvedI 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...
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...
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, ...
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...
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? ...
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. ...
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 ...
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...
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 ...
Explanation of formula used on conditional formatting
SolvedHi, Could someone please be able to fully explain how the following formula works with regards to conditional formatting? =AND(start_of_range""...
Populate separate worksheets with data from main worksheet based on criteria met
SolvedHello, 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...
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...
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...
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...
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...
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'...
Paste value on filtered cells
SolvedHello, 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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Comparing two columns using partial match logic
Solved/ClosedI 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. ...
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...
