Excel Forum
-
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
-
date formate [Closed]
Hello, please help me, i have software date format {15/03/2016 5:26 PM} and i need convert to this format {Mar/14/2016} Configuration...
-
Town/City to lookup county [Closed]
Hello, I have a spreadsheet that what i am trying to accomplish is that when an address is typed into a column it will look up and match the town a...
-
Conditional Cells Merging Macro [Closed]
Hello, I have the google contact in a CSV which shows an address in a separate rows. The key point on this file is the date that it is all of it i...
-
transfer data between sheets in excel [Solved/Closed]
Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...
-
Compare values of two separate sheets and returning value [Solved/Closed]
Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...
-
Using an IF statement to compare dates [Closed]
Hello, I'm trying to compare two dates by referencing two cells. I tried something like this IF(B2>C2, "past due", "on time"). I know to ...
-
How to have my results in different sheets in one workbook? [Closed]
Good day I trust you are well? I was hoping you can assist me with the following and will be most grateful for any help I can get: I have to cr...
-
How to invoke VLookUp function in Excel VBA. [Closed]
Hello, Please, I need a visual basic code that can actually invoke or call a V Lookup function in Excel to query data in two separate worksheets an...
-
Recording Macro To Duplicate Page And Rename To Numeric Value [Solved/Closed]
Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...
-
Need to find a data in a column and copy below cell data or add [Solved/Closed]
Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................
-
Compare 2 worksheets and update one of them [Closed]
I am a beginner Excel user and I hope I can get some help here. I am about to purchase a retail business. I have a copy of the master inventory list. ...
-
Help needed on saving then clearing content except selected rows [Closed]
Hi I am writing a spreadsheet for my ward for TCI list which has admissions, discharges and transfers. I want to be able to save then clear the c...
-
Autopopulating data from one main sheet to multiple sheets [Closed]
Hello, I'm making a workbook for my coworkers to easily know what specific person they need to work with from month to month. I have created a "Mast...
-
Transfer data from multiple sheets to one sheet. [Closed]
Hi all, I'm kind of new to spreadsheets. I have 3 sheets each with the same columns. Column 1 has a type and column 2 has serial numbers, column 3 has...
-
comparing columns in excel - can't remember?? [Closed]
I used to do this function years ago and can't remember how now! I have three columns and each contains a value similar to A001187. I want to compa...
-
Compare workbooks [Closed]
I have a two column workbook. Column 1 is a part number and column 2 is a description. I generate a second workbook with hundreds of numbers and u...
-
count days in excel [Solved/Closed]
Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...
-
Excel Macro [Closed]
I am looking for help in writing a macro to highlight duplicate number in two separate rows. The conditional formatting is really close to what I nee...
-
Excel- How do I auto transfer rows of data to another worksheet [Closed]
Hello all, I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival sco...
-
combine of column [Solved/Closed]
Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.
-
add data on 2 tables at once but in table2 only if text match [Closed]
Hello Excel experts. I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data...
-
Compare values in two columns and return the value from third [Closed]
Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need t...
-
Comparing two excel worksheets [Solved/Closed]
please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...
-
Populate 2 tables at once but one table only if text match [Closed]
Hello, I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data it's entere...
-
userform populate combobox2 based on combobox1 selection [Closed]
Hello, I have a userform with 2 comboboxes both work fine and they both get the items to select from the same column they each populate pulling uniq...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB