Excel Forum
-
Excel error [Closed]
Hello, I am working with MS Excel 2010. While inputting data in a four-sheet file, older data of one sheet keeps being replaced by newly added dat...
-
VBA code for excel [Closed]
Dear Expert, Hope you will be in good health! This is Santosh from India (Gurgaon). I need your help to get images saved in the excel sheet o...
-
Need help with counting value formula [Solved/Closed]
Hello, I am brand new. I am trying to figure out a score based counting formula. I have columns with Name, Status, Rank and Value I want the v...
-
Extract data from one sheet to another [Solved/Closed]
Hello, I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1...
-
Multi-Sheet budget [Closed]
Hello, I'm trying to build an budget in Excel. I want a master sheet that lists all expenses/income with separate sheets for each line item in the...
-
copy and paste check box last row [Closed]
Hello, I am trying to use check boxes in order to copy and paste values over to another worksheet automatically. This means multiple items nee...
-
i wants to copy single row data from multiple file to new sheet [Closed]
Hello, i wants to copy single row from each xls file stored in a folder to sheet where i am coding on that sheet as a column. e.g. File1 contains...
-
move data [Closed]
Hi I have list of 50 or so names with corresponding columns on one worksheet and i want to automatically all move the rows with the same name to ind...
-
Cant open a file. [Closed]
Hello, I have some problems not with excel, but with a .xlsx file , I tryed to copy ,but system writes , that file has wrong end ,and copied file do...
-
Copy a row from one worksheet to another, based on criteria [Solved/Closed]
Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas alread...
-
Cell updated when if condition is changed (macro) [Closed]
Hello, Can anyone help me with a simple thing I cannot get done ? Using a macro, I want the value (integer) of a cell to be changed depending o...
-
Macro to send an email when a cell value changes to an email [Closed]
Hello, I use Office 2013 for everything. I am trying to write a macro that will send an email from outlook to an email address in a given cell ...
-
convert date of birth into words [Closed]
if I write 11.07.1982 in A2 ,how to get the appearance like this Eleventh July Nineteen Eighty Two Thanks
-
data transfer from all sheets to 1 [Closed]
Hello, please help me.. i am trying to make a production report & for that i have to copy data from numerous sheets to 1 sheet & then calculate. s...
-
is it possible to use 5'-2 1/2" in a formula instead of decimals [Closed]
Hello, please a need some help. is it possible to use 5'-2 1/2" in a formula instead of decimals or converting it into inches with a decimal? Any ad...
-
date sort [Closed]
Hello, I have an Excel spreadsheet with training expiration dates. How do I sort/select for "dates on or before [another date]"? I know it can be ...
-
Replacements [Closed]
Hello, Is there a way to replace certain text with other certain text? for example... if I enter this column contains apple - red orange - ora...
-
Automatic Email Sending Macro [Closed]
Pls, I need a VBA macro that can send a mail to a specified email address. when a command button is clicked in the Excel environment, a mail message i...
-
Write text in adjacent cells if one cell value is ___? [Solved/Closed]
Hello, My knowledge of excel is very basic, but I am interested to know if I can find an easier way to enter information. I'm a tea manufacture...
-
Excel Macro for a very customized group by function [Closed]
Hello, I would like to generate a report like the attached with this mail. The requirement is - In the Sample Data, Source tab contains data for pro...
-
How to convert Date of Birth to word in Excel [Closed]
Dear sir, I have placed my date of birth 25/04/1977 in one cell in excel and I need the result as "Twenty fifth April Nineteen Seventy Seven "as in...
-
VBA Formula; Automatically update multiple workbooks from MASTER [Closed]
Hello, I am trying to help a friend with his restaurants. There is a MASTER list with all the food/drink items. There are 7 locations. Each...
-
Duplicate row [Closed]
Hello, How would the formula look like for the following: Sheet 1 has 100 rows Sheet 1 has 6 columns Row 1 has headings Formula would go o...
-
compare the values of two worksheets [Closed]
Hello, I want to compare the values of two worksheets say sheet1 and sheet2 (col1) and want to add all the values col2 of both sheets in anoth...
-
unable to move arrow keys in excel [Closed]
Hello, am unable to move arrow keys in excel, please help me
-
Cell Format based on conditional formatting [Closed]
Hello, Can anyone help me figure out if excel 2010 allows for cell formatting based on text? I have two columns, and in Col A, I have text that re...
-
Date and If function [Closed]
Hello, Thank you for your time! I want excel to determine the date on multiple conditions. If the given date in A1 is 29-Nov-1980 and one of t...
-
Convert A Single Row to Column, with an undefined number of rows [Closed]
Hello, Hopefully somebody can help, I have a number of files where I need to convert the single row too columns, however the issue I have is the n...
-
Add "x" years to date when it has certain words [Closed]
Hello, I need help trying to add 5 or 10 years to a date if another column has this "word" or that "word"... Hopefully I explained myself corre...
-
Help! Need to copy only some columns in rows that have X condtn [Solved/Closed]
OK, Full disclosure, I am a Novice Excel user at best.....I have a Google Sheet Workbook that contains Google Form Responses (the Sheet name that thes...
-
Searching out Phrases in What-If Scenarios [Closed]
Hello, I am having a hard time figuring out this What-If formula. I have my employees make notes in Cell A. So A1 might read "The customer came in...
-
Use of '@' in formulae [Solved/Closed]
Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Reta...
-
Is this possible (IF with dates) [Closed]
Hello, I need some help with what to input into Excel for a function I'd like to see. What I'm looking at doing is: Lookup all dates on "s...
-
IF function using dates [Closed]
Hello, I'm trying to write a function that will use an divisions data and turn it into manageable data. They record in their spreadsheet an en...
-
need to extract data from a cell in a macro enabled sheet [Closed]
Hello, I created an invoice for my business with a macro to run so that every time I click on a certain cell it will save that sheet into a new work...
-
conditional Formating question [Solved/Closed]
Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has ...
-
IF formula with dates [Solved/Closed]
Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and en...
-
Copy rows from one worksheet to another based on criteria [Closed]
Hello, I have an excel document for our clients based on the type of service they have. I would like to be able to copy and paste the entire row f...
-
Excel formula question. [Closed]
I have these cells info. CBSA ; RCMP EC ; FO ; HCAN ; NATRES ; ND CRA ; PSC ; PWGSC ND ; PWGSC ACOA ; CFIA ; CRA ; CSC ; FO ; HRSDC ; PWGSC ...
-
Copy row from one sheet to other based on 2 conditions [Closed]
Hello, Any assistance would be very much appreciated I'm just getting into macros and coding. I'm trying to copy a list from sheet 4 and input the...
-
Search 4 worksheets, copy rows to 5th [Closed]
Hello, I am using Excel 2010. I am new to the forum and have a very basic knowledge of VBA. I am trying write a macro that takes info provided...
-
Moving data [Closed]
Hello, this is driving me mad and im sure its simple. i have 2 sheets in 1 workbook. if column F on sheet 1 contains the word "YES" i need it to ...
-
How do you make a VBA function in removing a specific value in a [Closed]
How do you make a VBA function in removing a specific value in a cell. Example: remove "#, " and ", #" #, 1, 2, 3 1, 2, #, 3 1, 2, 3, # Res...
-
EXCEL, If column terms match text In range b equal to or less th [Closed]
Ive been racking my brain, the attached photo illustrates roughly what Im trying to do, top and bottom images illustrates a collection if 12k pictures...
-
Comparing Two Excel File. [Closed]
Hello, I have to compare two Excel files for data consistency. Both the file have equal number of column with equal records on it. My job is to find ...
-
Complex Macro Set-up Question [Closed]
Hello, I need to set up a macro that takes data from 6 different excel files and deposits parts of them in a new file, in different order. Efecti...
-
Copy answers from 1 sheet to another based on condition - VB [Closed]
I want to copy description mentioned in particular cell only when the adjacent cell (i.e. adjacent column cell) says 'YES' . I want to copy this descr...
-
Auto. transfer rows of data to a new sheet based on 1 variable [Closed]
Hello, I'm currently working with some data that needs to be broken for better viewing purposes and presenting to non-data minded people. It's goi...
-
Creating master spreadsheet for mailing information [Solved/Closed]
Hi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I wa...
-
Macro only for Alphabetic Sheets [Solved/Closed]
Hello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks & Regards...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen