auto fill cells

We have an idea that should reduce keying errors when a user enters a bill of lading in our ticketing system. I've developed a simple Excel sheet with a list of all available rail cars. The can use a "Select All" button to select all cars then uncheck the ones that aren't being used for this...

Quick question (I think) I have a sheet that is auto sorting my content that is working well (shown below). My issue is, I no longer manually fill column 6. The content is now auto filled from another sheet. I want to do two things. How can I set this to make sure it only shows for one sheet...

Hello, I'm new to VBA. my issue is this: If c7=c6 then d7,e7,f7, as well as p7:u7 (notice they are not consecutive) should auto fill with the values in their respective columns from the row above (row 6). I have a code, but if I include "If IsEmpty(ActiveCell.Offset(i, i).Value) = False...

In my Excel sheet there are ABCDE columns D column is filled in with data. & I am filling down BCE columns by selecting & Pressing CTRL+D. I want a VBA macro to do this, the sheet is of 1000 rows. data looks like this I want the data to be like this

I have consignment codes in the first column and the first row is the place of origin. Iam required to put either 1 or 0 in a cell in a row, if i put 1 in any cell the other cells should be filled with 0 For example if consignment no SEA8779 is from the state 1 then the cell value will be 1 and...

I'm not sure how to word the question accurately so I have included some Pictures to aid me. Using Excel 2010 I am trying to copy data from one sheet, the "Form" to a database called "Master" but the data needs to go into a Row that corresponds with employee's pay numbers. This is the Form...

I am not Excel Savvy at all and have spent the better part of the weekend trying to learn/figure this out but have hit a wall. Work has tasked me with creating a spreadsheet that holds the records of 1000 or so employees and their regular tests. To achieve this I have created a manual entry...

Excel 2007 Windows XP Happy Monday! I would appreciate help in creating a macro to format my report from looking like this: <tbody> Employee Name Activity Name Nathan Manager: Ron 7/22/12 Phone Break Phone Lunch Actvity1 Break Actvity1 Break Activity3...

Hello, I have a worksheet where a user selects from a drop down box a 4 digit number in column F. I need a macro that will correspond the 4 digit number and autofill column J with a name of a server that the 4 digit number corresponds to. I have attached an example of it with this post. The...

Ok, maybe I'm asking for too much here but i'm always amazed by how much excel can do and also by how much mrexcel forum can help.:) I am looking for something similar to auto fill option on web pages. For example if i have three columns named city, state, and country, currently when i enter a...

I am trying to use the autofill function to to fill an entire page down for me, but the '$' that I have in the cell seems to only duplicate that reference. the formula is: ='Inv Cost & Ideal Usage'!$K$19. without the $'s it works fine. Is there a way around this? Thanks, - Andrew

I am trying to create a dropdown list that when an item is selected in the dropdown, the cells to the right autofill with data related to that selected item. For example. If I click on a dropdown and choose "Wednesday" in Cell A, then in Cell B, C, and D, autofill with "work", "gym", and...

Dear All If I type "L" into cell F2 I have used conditional formatting to change the colour to red, I also want to change the fill colour of cells "G2 to M2" to red. I have tried using copy and paste using paste special, I have tried to use conditional formatting on cells "G2 to M2", I have...