Copy/paste formula to variable # of data

Solved/Closed

Beginner Macro User - Nov 13, 2011 at 04:53 PM
B - Nov 20, 2011 at 06:30 PM

Hello,

I'm recording a macro where I have data in Col A (it's variable, it can be 5K rows one month, 6K rows another month). I want to copy a formula in col B based on the data in col A. Hence my problem with it being variable.

Thank you!

Copy/paste formula to variable # of data
Number to words in excel formula - Guide
Tmobile data check - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Credit summation formula - Guide
Excel grade formula - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 14, 2011 at 04:51 AM

not clear. whatever be the length of colun A and you are having a formula in B1(or B2 if B1 is column heding) you can copy B2 down provided you take care of absolute and relative references of cells in the formula

post the formula in B2

B
Nov 20, 2011 at 06:30 PM

Sorry my question wasn't clear but I'm recording a macro and I found this code in this forum and it worked beautifully! Exactly what I was looking for.

Selection.AutoFill Destination:=Range("B7:H" & Range("A" & Rows.Count).End(xlUp).Row)

Similar discussions

Unlock safe folder without losing any data

How can I make my name text invisible in Discord

How To Fix Mint Mobile Data Not Working?

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Similar discussions

Subscribe To Our Newsletter!