Hey guys I'm trying to figure out how to write a macro that will take the information of a column and distribute it throughout multiple worksheets. I'm trying to get the data in cell I6 of my summary sheet into cell B51 of the following sheet, and then I7 of the summary sheet into B51 of the sheet following that and so on. I honestly don't know where to start as I am almost completely new to VBA (most of my programming background is in HTML) so any help would be great! I've already got a variable that defines all of the worksheet names called 'shtName' if that helps at all.