Get instant live Excel expert help to learn how to use Choose function in Excel

i don't know if this is the right place to ask for help but maybe you can help me. I've been tasked with finding out where all our tech hardware is and make an inventory sheet using excel 2013. I have a scanner to scan the bar codes so it can add the serial number automatically to my excel shee, but my problem is that everytime i scan a barcode it goes to the next bottom cell instead of the cell to the right. Scanning is tedious because before scanning i have to choose a cell, then scan the bar code which fills the chosen cell but then right after scanning it goes to the next bottom cell instead of the cell to the right where i have to manually imput an asset tag number. any way i can change that in excel or do you know of any inventory sofware that can help me accomplish what i need to do? I just want to scan the bar code and automatically go to the cell to the right and not the bottom. thanks renan

I have a list of names in Column A and a list of telephone numbers in Column B. The are both on the same spreadsheet "NAMES & NUMBERS". On a different spreadsheet, within the same workbook, I would like to have a drop down where I can choose the name in A1 and it will automatically populate A2 with the corresponding telephone number for that particular person. I have searched for 2 hours on the web trying to find out how to do this. Please help!

After i had choose "AB12/AB08 WHITE HIGH VOLTAGE" in the column I, there are only left four row of data. I want to sort the data by date in Column O. (either new to old, or old to new). However, come out with "Operation require the merged cells to be identically size". I had do some research online but there are only suitable for fixed data(no add data anymore.) Since I need to add more data in the lower row, I need to find a easier ways to settle this. Are there any solution? Thanks for your help

I cannot figure this step out and need help please. Step 1: At this point, a smaller list of countries should be visible in the worksheet “Internet user and pop. Table”. Cross reference these countries with the list of tech ready countries in the “Tech Readiness 2016” and highlight in the “Internet user and pop. Table” worksheet the country or countries that are in both lists. You may choose any shade of orange as the highlighting color. Cross reference them using conditional formatting.

I need the correct formula putting in again as it has lost them and name and details no longer appear in the drop down area to choose from.

I need help with this In addition, the dashboard should have two more sections in it. The first section should be a Yearly dashboard view. In it, we want a drop-down list that allows us to choose one of the years in the worksheet. When we choose one of the years, we want to see: (a) the total revenue, (b) the average monthly revenue, (c) the maximum monthly revenue, and (d) the minimum monthly revenue for all historical sales that occurred in the selected year. I already have a ptable made or whatever it is called.

I want to have a column automatically choose from a drop down based on the value of another column

I'm trying to build an invoice, and want to create a drop down menu that allows to me to choose a state/province, which would then auto input the correct sales tax for the bill

I am doing a roster spreadsheet for my staff. I have set up click down lists, I have a choice of a time,ie 10:00 AM, etc which works but the staff also have RDO's, (Rostered Days Off), TAFE Days and Holidays. I want to assign a hours to TAFE Days and Holidays, so with in a cell if I choose TAFE the spreadsheet calculates that 8hours is being calculated, but but (here is my problem) if time are selected then the cell calculates the time instead

I am doing a roster spreadsheet for my staff. I have set up click down lists, I have a choice of a time,ie 10:00 AM, etc, which works but the staff also have RDO's, (Rostered Days Off), TAFE Days and Holidays. I want to assign 8 hours to TAFE Days and HOLIDAYS, so I NEED A FORMULA within a cell if I choose TAFE the spreadsheet calculates that 8 hours, BUT if times are selected then the cell calculates the time instead. Currently the formula calculates 0 hours for RDO (this is correct), I just need 8 hours for RDO and HOLIDAYS - the formula is in H80