Hi guys,
I've been having a problem how to do record a macro that will get me the following result.
Right now, I want to be copying values from A8:P8 to A?:P? (question marks means that values will be changing depending on the file inserted). In the file attached this area is yellow for this particular case.
Every google analytics extract is the same, apart from the number of rows that differ. I would like to be copying the area everytime from A8:P8 until the area with page view ends (in every file the page views end with a blank cell that I highlighted as red).
I'd like to copy that area from Sheet1 and be pasting it in Sheet2 in cell A2 as "insert copied cells" -> shift cells down.
Help much appreciated!
vemix
Bookmarks