Excel Forum
-
Transfer data from one Excel file to another [Closed]
Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?
-
How to simply this Excel formula [Solved/Closed]
Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",...
-
VBA Compare 2 sheets and output difference to 3rd sheet [Closed]
Hello, I am trying to make a button on VBA that will take compare two excel sheets, and identify new numbers in a certain column and copy and past...
-
Serial numbers [Closed]
Hi, Can someone help me create a series of numbers? I ran out of numbers. Please help me do this numbers. I need maybe 5000 numbers for this. here is ...
-
How to check if a cell contains "%" and calculate accordingly. [Solved/Closed]
I am wondering how to do that? I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do.. Ba...
-
FindAll This custom function returns Find and FindNext results as an array of va [Closed]
Find All This custom function returns Find and FindNext results as an array of values. It will find all the instances of a string (sText As String) a...
-
VBA Stops Running When it Reaches a Blank Cell [Closed]
Hello Everyone, I have an Excel spreadsheet that I am preparing for use. In the spreadsheet, i have a VBA macro set up to transfer out data from t...
-
VBA Copy/Paste fixed range a number of times [Solved/Closed]
Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr ex...
-
Excel - IF function with multiple words [Solved/Closed]
Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the wo...
-
Calcul de prévision des livraisons de colis sur les deux prochaines années [Closed]
Bonsoir, J aimerai faire une projection sur Excel pour les 2 prochaines années,pour ce faire je dispose des données des livraisons de colis pour 2027...
-
Mac: Copy rows to Master sheet based on cell condition [Closed]
I am an insolvency professional. I keep details of processes to be conducted on different companies alongwith their time lines. The different columns ...
-
adjust code show message about brand [Closed]
hi i would helping to adjust my code i have data in my sheet a,b ,c columns a= item , b= brand, c= quantity and userform textbox1,2,3 when...
-
Mac: Copying row of data that contains dates between two specified dates. [Closed]
Hello Friends, I am reasonably good at excel but have never used macros or VBA. I have multiple workbooks one for each company which has similarly...
-
Find a date in a range of dates [Solved/Closed]
Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an excel sp...
-
how to merge bank statement into one column [Closed]
Hello, how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should be i...
-
Excel VBA Sorting Problem [Closed]
Hello, This code is placing all the header names in the last row after sorting in descending order. Can you please help how to keep the position of ...
-
Spell number in Excel [Closed]
Hello, thanks for your coding when i use your coding to convert the number in to Text it will shown as like this for 12 (Rupees Twelve)only , ...
-
Copy data to a master sheet from newly created sheet [Closed]
Hello, I have a master sheet that I want to automatically fill. I have a macro that creates a new sheet for each instance, I now need another to ...
-
Creating Graph that updates [Closed]
Hello, I am keeping track of how many work orders are being created each month. On my "Completed Sheet" in column F it has the due dates. I would ...
-
VBA SUM DATA between 2 sheets [Closed]
hi, expert i have sheet1 contain data from range a4:e and the sheet2 contains data from range a3:g i would sum the data in sheet1 from b4:e and s...
-
Need to extract the data from one page to another page based on the unique numbe [Closed]
Hi i have data like below mentioned format, need to extract and paste it in another sheet, please help me in it. DEAL_NO DEAL_DATE APPLICATION_OFF...
-
VBA Coding [Closed]
I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1 of sh...
-
Arrow keys not working [Closed]
Hello, my arrow keys are not working. up down left right
-
Unable to change date format in Excel [Solved/Closed]
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I doubl...
-
Excel 2013 to extract text in one cell [Closed]
Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to ext...
-
how to transfer data from sheet to sheet 2 [Closed]
Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that needs ...
-
IF statement [Solved/Closed]
Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion date" ...
-
Dynamically Assign a Number in Data Set [Closed]
Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can assign...
-
transfer data from userform to sheet with the same format of table [Closed]
hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in userform ...
-
How to find the latest time per name in a table with names and times [Solved/Closed]
Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have sev...
-
Need to create linked sheets [Closed]
Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is lik...
-
SUMPRODUCT Based on WBS [Closed]
-
INTEREST ON TERM LOAN AND WORKING CAPITAL [Solved/Closed]
Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to solve...
-
get help Macro sheet [Closed]
Hello, My name is vivekanandan i am try to create macro sheet like compare two different excel file and get the output in new excel file but i am ...
-
Spreadsheet help moving data [Closed]
So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being entered....
-
Excel vba to color row based on wbs level [Closed]
Hello I need a macro to change row color based on "Level" column. Thanks Ebti
-
Copy from one cell and paste to another sheet based on length of another column [Closed]
Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy data f...
-
Summarise hours incurred by month based on multiple criteria [Solved/Closed]
Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below formula...
-
Are you still taking questions? [Closed]
Hello, Are you still taking questions?
-
Message to appear when 5 cells uncolored cells contain values. [Solved/Closed]
Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values. The ...
-
Code to move rows into another sheet based on certain values [Solved/Closed]
Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). ...
-
create an ordering list for our consumables [Closed]
Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an orde...
-
False Value removal [Closed]
Hello, How to remove false value if I use below formula =IF($K4="Urban",IF(N4>0,1,0))
-
Checking the values in Sheet1 with multiple entries in Sheet2, Write the output [Closed]
Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values from Sh...
-
Creating a data input sheet with excel [Closed]
Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent t...
-
Count cells containing text per row [Closed]
Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time ...
-
Excel Formula to identify similar text [Closed]
Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word wit...
-
Search using variable [Closed]
Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in the ...
-
Auto-populate a sheet with data from different other sheets [Solved/Closed]
Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all of w...
-
Copy rows to other sheets based on value in column [Solved/Closed]
Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account