autofill columns

<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody> DATA DATE PRICE DATA 20120621 118.1000 DATA 20120621 149.7700 DATA 94.8900 DATA 137.5900 DATA 114.5500 DATA...

Hi All I need a macro to repeat the last value in the column A depending on the Number of values present in the Column B. Ex: ColA Colb Dad 56 Mom 78 Son 67 89 78 So the value "SON" should be repeated until the 78 in the column B. Thanks in Advance :)

I'm working on a VBA that will autofill a formula (cell C3) based on the last row in column B, and last column in row 2. The number of rows and columns is dynamic, however the formula will always be in C3. This part works... but it only fills the first row and column: LastCol =...

Hello, I've been developing a front end report based on a MSQuery data feed, populating a Pivot Table. I have calculations in columns off to the end of the Pivot Table that generate custom metrics (from the table). Based on the previous day's data, the pivot table changes in size (number of...

Hello, I am working on a project in Excel that I need some help with. I need to add rows to a spreadsheet so that each unique combination of 3 different criteria are on an individual row. There are other columns of the spreadsheet that also need to be included in the rows that get added. It is...

I have a sheet that is used for data input that is entered vertically for payroll information. I want to be able to link that information to another sheet and then autofill horizontally For example Payroll entry sheet A b John Smith Jane Doe $2,000.00 $3,400.00...

I have a employee picnic and sports contest coming up and I am trying to figure out a scoring system to not only track a winner, but keep track of who was partnered with whom in which event. I have a list of events/descriptions in column B. in each row there is a new event activity, juggling, 3...

I hope there is a quick alteration to this script below. This is generally the script I use whenever I need to autofill a column in a spreadsheet. How do I alter this in a case where the cell I want to autofill changes (dyanamic). Until now, it has always started in the 2nd row but this time it...

I want to autofill a sheet with sets of 3 numbers all the way down however having several issues it is putting decimal points in after it which I think is messing with the pattern. For example: 100 100 100 101 101 101 102 and so on I have tried grabbing several cells to get it to work...

I've searched existing threads but haven't had much luck finding the answer I need. I have a formula in cell B2 that I'm trying to copy across all columns (with data in Row 1) and down all rows (with data in Column A). The number of rows and columns is going to be constantly changing (for...