Recorded Macro works in same cells every time

Hello All,
I using recorded macro in my workbook. Recorded macro works in same cell every time.
I want to use macro on different cells when I use macro.

For example:
If I copy data from "Sheet1" and paste as transpose (convert data from row to column) in worksheet "2016", and in Worksheet "2016", I would like to format pasted table rows (in worksheet 2016) with cell borders(A60 to A68) <<- See attached video link
Every time I run recorded macro, its only works in A60 to A68 cells and override on existing data. If I paste data in work sheet "2016" and run macro worksheet "2016" in cell A75 to A83, its should not move from there.


Video File and Sample file are attached with details. Please help me out if possible.

Many thanks in advance.

Thank You.

Explain in detail and in a concise manner what needs to be done. Include cell names, ranges, sheet names etc.
I quickly looked at the code and in 7 lines you have 4 times "select" which is totally unnecessary but that is another topic.
To give you a start:
"If I copy data". From which range in what sheet?
"paste as transpose". In which sheet and where? Which column? First empty cell in that column? A particular cell?
"format cell". This is just a single cell. Is that the cell where you start the paste transposed in?
I have not checked but what is "All Border"?
"delete top two rows". I assume in the sheet where you paste your data. Like Rows 1 and 2?
In your code in one of the macros you have "Range("A60").Select" and then a paste line. That's where it will paste but according to your request, that's not what you want.

If this macro is what you have in mind, you can extend it for the rest.

Please Login or Register  to view this content.

Congratulations with the Maple Leafs making the next round.

And this MIGHT satisfy all your needs.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Have you tried the macros from Post #3 and Post #4?
AFAIK, they do what you require.

Thanks for letting us know and good luck with your Toronto Maple Leafs.