Copy and Paste Macro Assistance

[Lilybeane]

So...

I have need of assistance. I have a 5x5 table of data that I paste each morning into a worksheet. The top row is headers of location numbers, and I have a sheet for each of those locations that keeps the data in order by week. Each week, I paste each location's data onto their sheet. I would like to know how to code a macro that will take each location's data and paste it into the next row. I have a count cell (B24) on each sheet that tells me how many columns there are to the next empty column, and each worksheet is named the same thing as the header row on the table of data. Is this even possible?

Any help would be greatly appreciated.

 

[ranman256]

you can record a macro then click the things you need done, then save macro. Tweek the parts you need, but Yours is probably...

Range("A1").select
Selection.End(xlToRight).Select
activecell.offset(0,1).select   'THIS IS THE NEXT FREE COLUMN.