fill down cells

Hi! I've been breaking my head trying to figure out and or find an answer on how to use a drop down list (of names) to fill down a column with the results. More detail. Lets say I have multiple sheets, each with a name, an a list of objects they own like this: And on another sheet, I have a...

Hi, I want to reference the cell A6 in cell W6. So I use =A6. I want to reference every 3rd cell so the next cell I want to reference is A9. W7 = A9 W8 = A12 etc How do I fill down W6 to reference every 3rd cell? Thanks, Gerry

I am looking to update this existing code to prompt for a date to fill down column A. I want it to only except a valid date in mm/dd/yy format. Below is code that works at filling down, but accepts dates that are invalid (ie. 10/35/16). Thanks in advance for the help! Sub MySub() Dim...

I'm trying to apply conditional formatting a number of rows using a formula. The formula looks like this: =NOT(ISBLANK(J20)) which applies to cell F20 I now want to fill down this conditional formatting so that =NOT(ISBLANK(J21)) applies to F21 and so on. However, when I try to do that, the...

Hello </SPAN> I would appreciate any help provided </SPAN> I currently have a spreadsheet with a table in that has the refs in column A (D0001=A11 – D0040= A50) I have the below macro that will insert another 10 blank rows in.</SPAN> “Sub Insert_New_Rows()</SPAN> For i = 1 To 10</SPAN>...

I used to download the report from our site, it always gives the report in the below format. <colgroup><col><col><col></colgroup><tbody> A B C Class Subject Maths Mark details Semester I Semester II Semester III 10 30 50 50 25 100 100 20 40 Class Subject...