fill down

Hello, I'm trying to copy some rows down, based on cell values, and this approach was recommended. However, I'm getting a compile error -problem with the last ")" For context, StartRow = 16, and NumberToCopy = 826. Therefore, I'm trying to copy row 16 down to row 826. Can anyone see the...

I have a table that looks like this <tbody> Apr-13 455 45 23 4 May-13 5 5 5 5 35 </tbody> I need to fill out the blank cells with the respective year. If I select the entire area and hit ctrl-D, all the cells get the contents of the first one. I however want april and...

I've created the following Macro based on some of the posts on this great forum! It works great, but I'd like to tweak it for another purpose where it would fill the formula down until a cell in column AF had the value "#N/A" or stopped having the value "clean". The #N/A is from a formula result...

Hello, I am having a problem with my macro filling down the data properly. I have a table wit headers set up. My macro selects two cells in the first row, and tries to copy it down into the other rows of the table. Instead what happens, the macro copies down the table headers into the two cells...

Hey Everyone , hopefully someone can help me out with this i have a lot of data in a table format . with a person name in the first cell of the table i would like to fill the person name down to complete the table so in the example below , it would fill peter jones down until cell A9 . How...

Hi Excel Guru's :) I'm hoping one of you can help me with a macro in Excel 2007. I have a row of data as follows on 'sheet1' with the word 'Dog' starting in cell A1. <tbody> A B C 1 Dog Cat Bird 2 1 2 3 </tbody> What I am after is a macro that will on 'sheet2' list the data as shown...

Hi, I'm trying to create a macro where I can automatically fill down the data between empty spaces. Here's what I have to give you an idea: <tbody> GROUP EE# ID# TID# ABC 1234 1001 XXX-XX-1234 ABC ABC ABC ABC ABC 2345 1002 XXX-XX-0002 ABC ABC ABC 3456...

Hi, I am new to writing VBA macros. Please help in rectifying this Record macro into a Write once as i have heard that using too many selections can cause debugs when used with different data. Below is my Code. Sub ActiveWorkbook() Selection.AutoFilter Range("S1").Select...

I'm working with a dataset with a strange formatting. It looks like: Column A Category 1 Item 1 Item 2 Item 3 Category 1 Total Category 2 Item 4 Item 5 Item 6 Category 2 Total Instead of utilizing different columns, all of the above in in one column (with the...

Hello, I have a small problem with adapting the code from the recorded macro. After running the auto-filter, I want to set the TYPE column value to another code but I have problems with getting the program to update the correct column. It's probably something so simple and obvious. :eeek...

Hi, I'm using a macro to insert formulae into a spreadsheet and want to be able to fill them down to the bottom of the block of data. The user inserts 2 columns to the left of the block of data, selects the cell of the first row in the first inserted column and then I'm using the following...

Column A contains a list of usernames, emails, account numbers, etc. I want to extract only the username and the respective email and put them is separate columns (C & D). So I entered the following formulas manually in C & D for the first 4 rows. I'm trying to autofill the cell addresses in...

I've seen so many fill down codes but have had no success in making them work for my situation. Below is a recorded macro. I'm trying to edit the part when it fills down. I need it to select cells C2:H2 down to the last row of the sheet (i guess based on column A, this will always have data to...

Hello, I've looked for a solution to a problem I'm experiencing in a variety of places and just can't quite seem to get the one I'm looking for. I feel like it should be pretty simple. I have a series of nearly identical sheets that each have multiple Tables (ListObjects) - they all have a...

Hi guys, I need a macro that will filldown formula only to visible cells based on the formula in the selected cell. ColA is going to be filtered for chunks of data, and colB needs different formula depending on the results in colA, but the actual formula isn't what I'm stuck on... its the bloody...

Dear All, Using 2003 to create a macro. I have a few columns of values. At the right end I added a column. I have VBA add a column lable and enter a formula in the cell under the label. Now I want code to copy that formula down to all the cells underneath until the last row of data is reached...

Hi guys, Is it possible to fill down merged cells? I want to have the days of the month in a column, but I want each day to be across three rows of merged cells, ie Monday 2nd August Is it possible to 'fill down' or some other short cut, or do I have to do it longhand? Phil.

In cell N9 I am averaging a set of data from another tab in the workbook: =AVERAGE('Daily Actual Data'!F21:F27) In cell N10 I am averaging another set of data from another tab in the workbook: =AVERAGE('Daily Actual Data'!F28:F34) In cell N11:N100 I would like the formula to continue...

For a particular spreadsheet, the fill function replicates the value from the first cell in filled cells rather than recalculating them from from cell formulae. The result of setting cell B1 to =A1 and filling down to B5 is the following: A B 1 1 1 2 2 1 3 3 1 4 4 1 5 5 1 Clicking on cell...

Hello, I am hoping somebody can point me in the right direction... In Excel 2007, I am pasting (using Paste Special, Values to maintain formatting) data into an existing spreadsheet in columns A-J, with formulas in columns K-M, which is all a named range "SWData". The data I'm pasting in is...