Excel Forum
-
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...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account