auto fill

Hi. I use Excel 2010. I want to write some code that will look at the cell in column A. If the cell is not blank, then the column B value will fill in with the current date. Is there a way to just write the code to get the current date to autofill downward in Column B until column A is blank...

I currently don’t have any experience with using the check box function so I am looking for so I'm biting the bullet and asking for some help! I have 3 check boxes in G5 one of which is call "N/A". What I would like to do is: If the "N/A box" is checked then cells C5, D5 and E5 will auto fill...

I have a cell (A1) in worksheetA that I would like to have = (A1) and (E1) from worksheetB concatenated and then I want (A2) in workbookA to do the same with the next cell in column A worksheetB that has text. Is this possible? i can get it to concatenate but i am not sure on how to autofill...

Hi. My problem seems simple but I'm having a lot of difficulty getting my Macro to work properly. I have a sheet with a Column (A) of Dates and a Row (1) of Column Headers. Count of dates and Column headers change every day. I'm placing a lookup formula in B2 and I'd like it to do two...

Microsoft Excel 2010, Windows 7 Hi all, Looking for some help with a formula to auto fill data from one worksheet to another by using a formula: On our first worksheet we have sales data with codes The sales data is per a row and in that row is a code such as (A32) (C32) depending on...

Hello All (again) So, the macro I'm working on is working great, except for the date autofill. The macro has an inputbox that requests the date of report from the user. This is manually entered into a textbox. Instead of filling the same date to the last used row, it goes up in incriments of...

Hi all I found the following VBA script in a forum of inserting row with auto fill formula in protected worksheet, it works perfectly. However, I would need to modify it so to add column as well? Can any expert teach me how to modify the follwoing code so to insert column? I do not know much...

<!-- / icon and title --> <TBODY> I have a master database table in Microsoft Access 2007. I do not want to copy and past information. I have a formatted schedule done in Microsoft Excel 2007. I need to be able to enter in an employee number that is six digits long in the Excel Schedule and have...

<!-- / icon and title --> <TBODY> <!-- message -->I have a master database table in Microsoft Access 2007. I have a formatted schedule done in Microsoft Excel 2007. I need to be able to enter in an employee number that is six digits long in the Excel Schedule and have it automatically fill in...

Hi I'm a rank amateur and I'm trying to work on something for leisure. its a Rifts Initiative chart for my role playing game. What Id like it to do: it takes the dice roll of the initiative (1-32) the divides that by the number of attacks (1-15) to get the exact initiative segment that the...

I need to auto fill from the last found cell across to "IV". I have dates in rows 1,2,3 and formulas to fill from row 6 to 10. The last cell is unknown as data is deleted from "B" to wherever depending on the days in the month, and I then need to auto fill from the last cell across.Essentially...

On a form, I have a 2 combo boxes. One lists EquipmentName, the other Procedure rooms. 2 pieces of equipment are each stationary in its own procedure room. I want to be able to auto fill the procedure room only when either piece of equipment is chosen. For example, if equipment "Fluoro Rm #2"...

Hi everyone, I am using Excel 2007. I don't have any programming experience and I have managed to create a macro that will do autofill once (with numerical increments of one). But now I need a macro that will: Autofill series in increments of one Work in a single column - with unknown number...

:help: As Long as Im asking, Ill go for the 2 for 1 ! <smile> 1) Is there a way to make a cell (I assume it would be a drop down list) do something like a smart fill; auto fill/ auto suggest/ auto complete" function as Im typing in what I want? and ... 2) (Short Version: How can I use the...

The code that I'm using works but only fills in one empty cell at a time and my data range is kinda big and i would have to run the code about a 1K inorder to fill in all the blanks. :confused: Sub fillArowsIfBlank() Dim mytest As Range Set mytest = Range(Range("A69999")...

Hello, I am using MSExcel 2003 and have recorded a macro that I would like to edit but am coming up short on a good solution. The sub routine will insert columns and convert data from other columns using the UPPER function. I have copied out a portion of the macro below and feel that if I...

Have a work schedule--in column a, in cell a 4 have a day of the week listed and in the cell underneath --a5 have the corresponding date 2/22/11-----then have 10 blank cell in col. a then the next corresponding date and day i.e. day of the week and the corresponding consecutive date. Was...

Hi there, I have the following formula in a cell =SUMIFS('A3 Strategic Report_REV002.xlsx'!Actual_Downtime,Type,"=BREA",Site,"=Long",Month,"=1",Year,"=2010") I would like to autofill this formula down to Month 12, currently I have to change month to 2 etc i.e. =SUMIFS('A3 Strategic...

I am putting together a weekend on-call schedule for work. I need each row to show the weekend dates for 2011. For example, Row 1 would say 1/1/2011-1/2/2011, row 2 should say 1/8/2011-1/9/2011, so on and so forth. I cannot get it to auto fill that way, so is there a formula I should use instead?

I have an Excel spreadsheet with Macros/VBA: * runs several SQL queries from an external database * populates worksheet(s) with SQL result(s) * in each worksheet, select data & create a table * add extra columns to most of these tables * add calculated formulas to first row of these extra...