Excel Forum
-
Formatting a cell for multiple functions in Excel Closed
Hello, I would like to have my dates be highlighted red when expired and yellow highlighting the dates when 30 days prior to being expired. I alrea...
-
Split data into several rows of same data Closed
Hello, I would like to split a row of data into several rows of same data in MS Excel. I will try to explain the situation. I need a macro that...
-
Send Automatic emails using Macros Closed
If column F in any worksheet in entire workbook is changed to "Pending" send an email. Below is my macro so far. Sub Request() Dim OutApp As Ob...
-
Copy more than one cell in Excel if a condition is met Closed
Hi, I need to copy more than one cell if a condition is met. It’s about student degree. If the degree between specific range, then I need to copy m...
-
Pulling data from multiple sheets to master sheet Closed
Hello, I am working on a project and I could definitely use some help. I have an excel file with four sheets: Master Sheet, Project A, Project...
-
VBA code to open non excel programs Solved/Closed
Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM
-
Excel 2007 file Excel found unreadable content in <filename.xslx Closed
Good day, I have a computer set of Excel files, all in working order, but today one of the files when opening gave an error: "Excel found unreadable ...
-
Problem with copy in one sheet Solved/Closed
Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...
-
I have a problem regarding how to automatically update data in other Sheets. Closed
Hello, I m looking to have few different sheets that automatically updated based on information that is added or changed in master sheet. One shee...
-
Automatically move an entire row of expired item from one sheet to another sheet Closed
Hi, I have a problem with the code below. I am a store officer in the firm I am currently with, and monitory of expiring date of a product is par...
-
Copy worksheet from one workbook to another workbook in MS Office Excel Closed
Hello, In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.
-
I need VBA that creates a new sheet for every data entered in column D Solved/Closed
Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...
-
Budgeting forumla in Excel Solved/Closed
Hi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...
-
Macro in Excel Closed
bonjour 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 Solved/Closed
Hello, 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 Closed
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 Closed
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 Solved/Closed
Hello, 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 Closed
Hello, Which spreadsheet function in Excel will display 6 as the output in the following formula? =(36)
-
Excel formula to track accrued vacation Solved/Closed
Hello, 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 Closed
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 Solved/Closed
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...
-
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
-
How to merge data from different Excels Solved/Closed
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...
-
Master sheet and connecting other sheets Closed
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 Solved/Closed
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...
-
Sliding conditional formatting Closed
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 Closed
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 Closed
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...
-
Mask cells in Excel Closed
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, ...
-
Autofill number from Column B based upon text in Column A Closed
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? ...
-
Auto fill dates Closed
I am trying to figure out that if i make a change (like fill in a amount) in colum A1 (for example) that in colum E1 today's date will automatic appea...
-
Find and replace in Excel Closed
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. ...
-
If function with printing tool Closed
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 ...
-
Populate separate worksheets with data from main worksheet based on criteria met Solved/Closed
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...
-
Incorrect date while saving csv format Closed
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 Closed
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 Closed
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 Closed
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...
-
HELP with IF function Closed
Hello, So I have a problem with my file. I need to use IF function, but I don't understand. The main thing is that I need to calculate the days tha...
-
Excel Closed
I am trying to change date format to dd-mm-yyyy, but the format remains unchanged
-
Copy-paste some grid in excel Closed
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'...
-
Conditional formatting Closed
I want to make a formula in excel that if a cell in one column is not filled in within 7 days from the day in a cell in another column but in the same...
-
Paste value on filtered cells Solved/Closed
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...
-
Regarding all fields by selecting individual ID Closed
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...
-
Formula I should use Solved/Closed
I am so confused on what formula should i be using for my work...? Which should be ending up like this...
-
Excel Cell Color change from another cell date fill up. Closed
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 Closed
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 Closed
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 Closed
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...