Forum
-
Copy rows n times in Excel
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...
-
VBA to compare column E from 2 sheets and copy entire row to sheet 3 [Solved]
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...
-
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 &...
-
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 [Solved]
Hello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they...
-
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...
-
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...
-
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
-
Copying data from one Excel sheet to another. [Solved/Closed]
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy...
-
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...
-
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. ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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"...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Excel [Closed]
I am trying to change date format to dd-mm-yyyy, but the format remains unchanged
-
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...
-
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...
-
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...
-
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...
-
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.
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...
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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...
-
change excel format
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
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...
-
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...
-
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
Hello, I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually...
-
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...
-
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...
-
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...
-
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...
-
Pass fail result including absent is fail [Closed]
One student passed in 5 papers out of 6 papers but 1 paper absent in this exam.actually this student is fail.How to calculate the result in excel