Excel Forum
-
convert number to word in excel Closed
Hello, I want to write number but dont want to spell the the same in word please suggest the formula to convert the same. Ex:-6000 Six Thousand...
-
Copy a cell value from most recent workbook from a folder Closed
Hello, Dear .. i try to make a excel file for my shop here when i open my work book it should automatically update the cell value from a recen...
-
Dates written in different ways Solved/Closed
Hello, I have a spreadsheet with dates written in different ways. August 2010 is written both August-10 and August 2010. How can I change this so ...
-
Excel Macro Help Closed
I'm trying to figure out the VBA code or Macro to find the specific text of "AM2," in one column D and if it is there then replace it with the info fr...
-
Help Excel transfer/copy specific data from one sheet to another Closed
I have this problem. I have this name and address on sheet 1, then i want to transfer or copy it from another sheet with differrent cell format. What ...
-
Count all cells containing a particular text Solved/Closed
I am using Microsoft Office 2016, and I am trying to make an autimated numerical count of all cells which contains a certain phrase for a table. An e...
-
Auto Populating Spreadsheets Closed
Hello, I have a workbook; I want to place a $ amount for a certain type of light fixture and have it populate the amount in a certain column for onl...
-
Payment Transfer Closed
Hello, I have a spreadsheet with the following columns on a sheet called PAYMENTS D=name E=date F=Payment G=ref# I also have addit...
-
if formula question Closed
Hello, i am trying to write a fomula so that if the text in one column 1 is a,b, or c, than the text in Column 2 is a,b, or c Configuration: Wi...
-
Column A has data return Column C Closed
Hello, If Column A or Column B has a date in it then I need the info from Column C to appear in another column Column A Column B Column...
-
need only comapny name from email add Closed
n excel sheet, i want only company name separately from email address column. Ex. from" mike@edwardstelecom.com " i want the company name i.e edwardst...
-
Removing "FALSE" from an IF statement with a VLOOKUP Solved/Closed
Hello, I would like to remove the "FALSE" result I get when using my IF formula. The formula is a VLOOKUP that is looking at 2 different cells. ...
-
Calculating monthly attendance to percentage Closed
i have a total of 8665 employees monthly attendance and i need to calculate that into percentage for the a month say for the month of March (31 days) ...
-
What is vba code to find if an active cell has a button over it? Closed
Hello, In a column, i have a Macro Button for first row. I have programmed the Macro such that on pressing the Button, a data against the Empl...
-
Comparing Excel Closed
I had a large excel file with multiple pages I was working on and computer shut down and created same file auto saved. I subsequently worked on one o...
-
How to bring searched columns copy and paste another sheet Closed
Hello, I have set of data in sheet one. I have to search particular string in first row, if its found I need to copy that particular column and past...
-
Ask a question Message list Topic thread Forum list Report Macr Closed
I tried the code and I getting a runtime error 9 on the following line Subscript out of range. lMaxRows_t = Workbooks(sBook_t).Sheets(sSheet_t).Cells...
-
Insert same rows several times Closed
Hello, I'm not familiar with macro's but I'm happy that the record option exists and that's what I copy/paste here under. But I suppose there is...
-
transfer data Solved/Closed
Hello, Is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that wor...
-
Pop up reminder message in excel Closed
Hi Guys, I'm just wondering if you would be able to assist me with this one, I have been trying to work this out myself but this is causing me a g...
-
I want to average Multiple Cells on Multiple pages. Closed
Hello, I have an excel document and I need to average 10 different sheets. Each sheet has 374 cells that need to be averaged. So, Sheet one shoul...
-
move data Closed
hi, is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that work book?...
-
Convert Letter to a Number Closed
how do I convert a letter to a number, E needs to 4, M needs to be 3, P needs to be 1. I will be putting the letter in one cell and need it to conver...
-
How to calculate no of days between dates Closed
Hello, How to calculate no of days between one constant date not written in excel sheet i.e. 31-03-2016 and other dates which is written in excel ...
-
Hiding rows when validation list is changed Solved/Closed
Hello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...
-
Validation dropdown list to hide Rows Closed
Hello, I have the following VB to hide number of rows by choosing validation drop down list. it worked great. but everytime I choose the drop down...
-
Userform to export data to another sheet Solved/Closed
Hello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...
-
Change colours of various text Closed
Hello, I have a spread sheet with numerous rows named 1, numerous 2, then 3 etc. I want to change the text colour each time the text changes in ea...
-
counting and stop counting days in a cell Solved/Closed
Hello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...
-
Match columns and assign a value from 3rd column Closed
I have a list of ticket buyers from a recent event, including their zip code. I have a separate spreadsheet with every California zip code and it's...
-
Excel userform question Closed
Hello, I have spreadsheet with a button on it that opens a userform. This userform will populate data to the same sheet the button is on. How do I...
-
vlookup formula help please Solved/Closed
=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...
-
VBA Excel 2013 Pleae Help Closed
Hello, My question is and if this can be done. Say I have a date entered 3/15/2016 and have information in my excel file. Then I have to enter a...
-
How do i get the sales tax to pop up??? Closed
Hello, how do I make it so I cant type in a city and have it so the sales tax automatically inserts itself in? Thank you Configuration: Windows...
-
How do i get the tax rate to pop up by itself??? Closed
So I am trying to make an invoice for the company I work for. my question is: How do I make it so I type a city in the city cell and then automatica...
-
Conditional formatting one cell based on another excel 2016 Closed
Hello, I want to conditionally format one cell in a row based on another cell in the row. i.e. If cell F1 has a value greater than 2009 I want cel...
-
Need a formula to sum a column with #Value error Solved/Closed
I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.
-
Userform to export data to another sheet Closed
Hello everybody, I have a userform named MembersInformationEntry; it as the following details: Label1 named 'member Name' with a corresponding t...
-
auto copy/paste data if criteria (same value in 2 cells) is met Solved/Closed
Hello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...
-
Creating a macro that will create a new sheet and copy data from Closed
Hello, I want my macro to 1) create a new sheet and 2) copy data from another sheet onto the new sheet. For some reason it (my macro) will create...
-
HOW TO COMPARE NAMES FOR EXACT, NO MATCH, CLOSE MATCH IN EXCEL Closed
I have 3 millions database of names in excel, I want to compare each rows for match, close match, no match, first name juxtapose for other names, & ab...
-
Painting by Numbers Challenge Closed
Hello, I want a large matrix (100's of cells) to contain numbers, say from 1 to 20 and conditional formatting to colour fill the cell and font wi...
-
I want to compare multiple areas in city Closed
Hello, I want to compare multiple areas in addresses for ex Industrial Development Area, Balanagar,Hyderabad Apollo Hospital Complex,Jubilee ...
-
Duplicating data from one line on sheet 1 to sheet 2 Solved/Closed
Hello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...
-
Conditional Cell Marge Macro Closed
Hello Great Community, One of my friends recommended your community and looking forward for someone can give a help hand for my issue. I have t...
-
Button to populate another sheet Closed
I have spreadsheet with a button on it that opens a userform. This userform will populate data to the same sheet the button is on. How do I get this...
-
Retrieve data based on Categories in Drop Down list Closed
Hello, I have a sheet full of entries that have at least five columns full of different data. One of these columns is a drop down list of categori...
-
display a range of cells if a condition (text) is met Closed
well, i am regular for excel. now i need a help, if a cell value, is a particular text, then i want to display a range of cells at a particular loc...
-
colour changing in rows determined by text in 2 different cells Solved/Closed
Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...
-
converting numbers to text Closed
hi I need to convert numbers / date of birth in excel pl suggest / advice thanks
