Excel Forum
-
Insert Lines & sequential numbers based on quantity [Closed]
I have an order form with multiple macros including a macro to "Total" each order to show only the items and the quantity of each item that is ordered...
-
change mm/dd/yyyy in dd/mm/yyyy [Closed]
Hello, i have 250+ entries in excel sheet in format mm/dd/yy i want to change all in 1 time in dd/mm/yy format how can I do it. advise me ...
-
Format two-level axis in stacked column chart using vba [Closed]
Hello all, I have a stacked column chart with two-level axis. Please refer the image I want to make the first level axis (a,b,c) font size...
-
Copy conditional formatting- different version [Closed]
Hello, I'm a novice, but have been getting by. The intent is to modify the text of a cell when ordering material, if we have that material already ...
-
Macro of reminder When Time in Particular cells orrurs [Closed]
Hi, Can someone please help on this. I have daily excel to be mainteined in which client assigns me tasks and i need to approach them back withing...
-
Macro for Copy data and paste in all following blank cell [Closed]
Hello, I am working on a data sheet with several columns. I need a macro that copies a value and keeps pasting it in the following rows till a ...
-
Macro Run time error 1004 [Closed]
Hello, I want to write a macro to do the following: Automate an action so that when you select a content from a drop down list, it triggers content...
-
compare 1 date to several dates [Closed]
Hello Excel Experts. Please bare with me as I am trying to use Excel and can't seem to figure out how to proceed and am hopeful yall will be able to...
-
Automatically transfer data [Closed]
Hello, I am trying to automatically transfer data when entered on sheet 1 to sheet 2. Can you please explain how to do this?
-
Graphing gym membership over time [Closed]
Hello, I have a spreadsheet with data on when certain people joined a gym, looking something like this: October 2011 May 2012 December 2012 Oc...
-
1 to many compare [Closed]
I am using Excel 2013. Have a multiple Projects (>1000), each project has a start date. Each project can have several Tasks (1 to many). Each Task ...
-
How to use Macro to generate different reports [Closed]
Hello, I come across a question recently. I am hoping someone could help me. I work for a property management company with over thirty properties...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB