auto

Hi I need formula with if command in column E based on data from A to D, Secondary no Discount <tbody> Segment Transmission Value Discount % Result Primary AUTO 1000 20% 200 Primary<strike></strike> MANUAL 1000 10% 100 Secondary AUTO 1000 0% 0 Secondary<strike></strike> MANUAL...

Hey. Iam wondering if its possible to to code or do something with inputbox. The thing i need. my costumer is going to put in a value of 7 numbers/letters, and then press Yes. Is it possible to do the "yes" button automatic when 7 numbers/letters is filled in? Ex: inputbox is appearing...

Hello All, I have a spreadsheet with some code for auto-population of cells, this requires the spreadsheet to be saved as "macro enabled". The problem I have is that the code cannot run in "Shared" mode. So I would like to add in some further code to automatically save then close the...

I have moved past the issue of time to decimal, as that was handled quite efficiently here. I am now on to a new "I need help" thing. I would like to have a yes or no question box pop up upon opening the worksheet (or workbook or speadsheet, not quite sure of that terminology yet) which changes...

Hi there, I am trying to concatenate different columns from 2 sheets, which are in different order one to each other. This would be the columns i need from the Auto sheet, and their counter from Manual sheet: <tbody> Auto Manual Column Column Q AB S T T U U AN V V W AQ X AT...

Hello Friends Can anyone tell me if it is possible, and how to enter multiple logic in the custom auto filter ? For example, for a data set, I would like to filter between 7 AND 8, 8 AND 9 , 9 AND 10...and so on. Cheers Rush

I have created a database for job lines in a plumbers that I work, for tracking new jobs. The database is completed using a data entry form to provide a new job number to a job. I have also set up a blank job line that gets printed out to give to the engineer that is going to this job. I have...

For example Row1 Row2 . . . Row10 I set a formula adding the value of these 10 rows. Is it possible that if I do some sorting, lets say only 1,3,5,7 rows, is there an auto sum formula that will adjust automatically only summing those 4 rows? Thanks a lot.

Good afternoon, Could someone please help me with a problem I am having? I am trying to reference a cell in Sheet1 by using ='Sheet2'!A2 for example and carry it down to ='Sheet2'!A30, but when I insert a row between that range and type in information it doesn't auto update. Further...

I am a superintendent for a construction company and I have a workbook that I am currently working on and I am fairly new to excel. It is for daily reports in which I have to add 4 pictures everyday for 6 days a week. I found that if I use a chart it will auto re-size pictures for me cutting...

Hi folks, I want to do a pivot table based on credit card transaction data that is categorized - obviously the raw transaction data won't make for a very good pivot table since it's not categorized... When downloading a credit card stmt in csv I get transaction data something like below (blank...

Afternoon All, iv searched quite a bit but cant find a work around for the formula i am trying to create and am hoping some one could point me in the right direction. i am currently using the the following formula: =SUMIFS(Sheet1!D:D,Sheet1!G:G,"billy",Sheet1!E:E,"Smart") this works great...

The pic1 show original, and the marco will auto fill down as show in pic2 (yellow)

Hi all, So I have an Excel Worksheet with a data validation drop down. I am trying to have data pasted based on said drop down. The data validation drop down is constantly changing. Based on the table provided, I need Sheet 2 to populate based on a data validation drop down provided in cell...

I am a hopeless Excel User and need help with sorting Columns H,P,X,AF and AN. Each Row the data begins on Row 9 and goes to Row 26 Only. Basically, if i change the Dropdown to say "Yes" I want that Data to sort at the top of the list. Sorry if this makes no sense :)

<tbody> A B C D E F G H I No Description Date Purchased Cost Prior Depreciation Life Current Depreciation Type 1 Truck 09/3/2014 28182 16438 5 ? Auto </tbody> I am using the following formula, which is giving me error. Can someone trace the mistake? Cell I2 has date...

I created a template that will take data and count the data based on a number of criteria. For example, in cell A1 I have State entered, in cell B1 I have class code, C1 City, D1 deductible, E1 Zip Code, F1 cost new, G1 year and in H1 I have a formula that would count the criteria based on the...

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually...

Hi, Hopefully someone can please assist. I need to have a spread sheet visible to multiple users at the same time. The Master Copy is the only one that needs to be edited. The other users are purely a Read-Only. Is there a way for the Read-Only to Auto Update, with out the user exiting out and...