Excel Forum
-
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...
-
Duplicate line and decrease Id number Closed
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 Closed
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 Closed
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...
-
Python code Closed
Hello, The script above to compare two excel sheets and copy like data to a third sheet works great. What would be the opposite formula? Two compa...
-
change excel format Closed
Hello, how do i change the excel format of 02.07.2018 in to 02-july-2018 there is no option in Custom format because the separation is in ( ....
-
Inserting pictures from folder using macro Closed
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...
-
Macro to check value in various cells Closed
In column B. I need to check cells in random order. If there is value then display msg box. For eg If cell B3 value = ABS then msg box "Please us...
-
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. ...
-
Automaticly change currency format in cell Closed
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...
-
Trying to create a ticket log spreadsheet Closed
Hello, I am trying to create a ticket logging system for my team at work and have created a sheet with 4columns each with drop down lists for sele...
-
Generate simplified data from RAW data Closed
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...
