Excel Forum
-
VBA macro loop [Closed]
Bare with me here, I just started learning VBA code so it may look a little ruff but what i am trying to do is to use a loop to copy and paste each su...
-
How to compare 2 sheets in Excel? [Closed]
Hello, I have to come 2 sheets sheet 1 Rev 0 Sheet 2 Rev 1 Sheet 3 diference between sheet 1 & Sheet 2
-
compilation [Closed]
Good day to all, I am looking for help and I have asked all the knowledgeable people at work to no avail. As per the uploaded picture, I am lo...
-
How to compare a range of data in Excel? [Solved/Closed]
Dear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...
-
Transferring data from page to page and automatically sorting [Closed]
I'm creating a grocery list in excel and I am struggling with one big part of it. - Page 1 is dedicated to meal planning, page 2 is an ingredient c...
-
How to use VBA to send emails from Excel? [Closed]
Hello, I really need some help! I need to create a macro which will send emails to a specific email address within excel when a cell is updated. ...
-
Adding and subtracting using Vlookups [Closed]
Hello, =IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ") I need to add in another vlookup to the formula but have tried a few...
-
Pictures insertion [Closed]
Hello TrowaD, With this code, pictures are linking to the file and not inserting. i.e. If I send the file to someone in email they cant these picture...
-
How to use VBA to loop copy and paste [Closed]
Hello, I have a formula in raw # 12 (E12: TNF12) and would like to paste this formula in the raw below (raw# 13) and then copy and paste its conte...
-
How to migrate data to another table and use a search box? [Closed]
Questions! I have a database-type table with names, numbers, addresses and what have you. I would like to make a second, single-rowed table that s...
-
Formula in numerical format changes to date format [Closed]
Hello, Actually, there is a problem arose. In an excel sheet where ever I put a formula changed from number to date format. Don't understand the...
-
Excel VBA macro to split rows, then copy and past [Closed]
good day, please i need vba code, that split one row to multiple rows and copy, paste it in another worksheet, and the source worksheet have about 100...
-
Date Format not reflected in sheet [Closed]
Hello, Guys,, help.. How do I convert the date in excel? Now it shows mm/dd/yyyy. I've changed the Format to dd/mm/yyyy but the data did not chang...
-
Copy Paste Special Values Macro [Closed]
Hi, I am not good with Macros so I am looking for help creating a macro that takes data from formulas, copies the formulas down to the next row and t...
-
How to update data of Sheet2 in Sheet1 with Excel? [Closed]
Hello, I have data in SHEET1 A1-5 A2-6 A3-9 I am entering data in SHEET2 A1 B1 C1 D1=SHEET1!A1-C1 I want to update this D1 value...
-
Use conditional formatting to highlighting cells based on Name [Closed]
Hello, Im in the process of redesigning a roster that involves employees from a number of different contractors. I have all employees on a sepe...
-
VBA for copying from data entry sheet to corresponding sheets [Solved/Closed]
Hi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...
-
How to extract data using VBA in Excel? [Closed]
Hello, Need some help to create a VBA for Excel 2016.. Basically i have 2 workbooks. Workbook 1 is Master File. Workbook 2 is the monthly d...
-
Calculate a percentage when the values are text [Closed]
I need to calculate the values of J1-J20 where J21 is a percentage complete. 100% completion is met at J14 and anything over J14 is over 100 percent. ...
-
Very New ... Need some help. [Closed]
Hello, I've created a spreadsheet for my cruise inventory thought it would help keep track as a new travel agent first time really using excel in ...
-
Excel Macro not working, any ideas? [Closed]
Hello, I work at a university and no one here knows anything about Macros. I had a new computer built and lost all my Macros a previous coworker...
-
How to count the number of occurrences in a range [Closed]
I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occ...
-
Formula for Unique ID's following a predefined rule [Closed]
Hi, I am in need of a formula that can deal with the following situation: We have many projects each year. Each new project gets assigned a 4 d...
-
Dates conversion [Closed]
Hello, How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A...
-
Reformat date field to plain text [Closed]
I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would ap...
-
Auto fill [Closed]
Hello, I need some help with excel. For example: I have on Sheet 2, in column A a list of words. So, what i need - if I enter one of the words on s...
-
how to give a students two ranks [Closed]
Dear sir, I have made a result sheet with ranks. I want to give a student two ranks one in his class and other in all sections. For example, if class ...
-
Delete or insert rows in a workbook [Solved/Closed]
Hello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...
-
Auto-create tabs from list and template [Closed]
Hello, I have a workbook with two tabs: 1. Tab name 'Index' If information is input into C4, then I need a tab created 2. Tab name 'Template' ...
-
How to make one summary file with 29 sum up sheets [Closed]
Hi My self Dr. Seema Mehrotra working as an Urban Economist at National Institute of Urban Affairs, New Delhi, India. I am working on a very large...
-
Autopopulate using dates [Closed]
Kind of a complicated one. I'll be appreciative/extremely impressed if someone can help me out. I'm budgeting and trying to autopopulate cells usi...
-
How do I create this conditional formula [Closed]
How do I create this formula? If A2, B2, and C2 has a combination of H, H, HP (it doesn't matter what order it is in), returns a score of 98 in cell ...
-
What formula can be used to share data in 2 sheets [Closed]
Hello, I have two excel sheets A and B having the same columns. there names, dates, figures. not necessarily having the same number of rows, havin...
-
Conditional Formatting [Closed]
I wondered if you could assist please? I currently have a column of dates that change to a bold red if the date is past. However, I require the date...
-
How to update data between 2 sheets using Google Spreadsheet [Closed]
Hello, I have created a form linked to Google Spreadsheet(named Form) to collect customer data like name, email, phone number and concern. I have an...
-
How to use a macro to check data in 2 work sheets [Solved/Closed]
Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...
-
Counting Number For Similar Value [Closed]
I have 2 Excel Sheets where i want to Use data from one Column from one sheet and compare those values in Other Sheet Colum to know how Many types the...
-
Use Macros to copy worksheet and rename using a list of names [Solved/Closed]
Hi all, I'm an excel novice and hoping for help. I need to write a macro to 1. Copy worksheet "Alstromeria" and 2. Rename worksheet to the name...
-
How to generate a STATIC unique identifier for each Excel row [Solved/Closed]
Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...
-
Two IF forumlas inside an IF formula [Solved/Closed]
Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...
-
Formula with varying information need pasted multiple times [Closed]
Hello, I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =...
-
Master Sheet to affect multiple sheets [Closed]
Hello, I am not sure how to explain this... I have a master sheet that has a list of all the names and grades for each row alphabetically. I have ...
-
how to find grade [Closed]
How find grade in excel, old tell me about the formula
-
Autopopulating multiple sheets from one main sheet [Solved/Closed]
Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...
-
How to sum a number from a range of cells, based on value [Solved/Closed]
Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....
-
Excel [Closed]
Hello, i have 5 numerical values in 5 columns but in same row and these 5 values need to be compare(e.g whether the five values lies between the t...
-
Subtracting numbers based on data in another cell [Closed]
I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the inp...
-
Name check [Closed]
Hello, How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?
-
Change the date format in Excel [Closed]
Hello, how I can chnage the format of 12-07-2003 to 2/22/2017 in excel 2010. Give the exact route inder
-
Self-generating sequenced number each time a sheet is opened [Closed]
How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram