I've had no luck with a previous post taking data from multiple worksheets.
Sooooo I'm hoping there's another way.
I need to (in a current macro) copy a selected cell and paste it into another WORKBOOK ( I know how to make a macros for normal copy/paste in current workbook) but here is the catch!
I have, everyweek, a macro that saves the workbook AS "WK plus a cell value", wipes the selected ranges and saves again ready for next week.
I need to copy the selected cell E.G B5 in a book called WEEK SUMMARY.
In this book there are 52 spaces for a total amount each week, but i need the macro to save into a relevant cell (week) automatically using the cell value in A1 So if A1=2 then it will paste under WK2(in B2) if its 3 then under WK3(in B3) and so on each week.
Const PATH As String = "\\calfp03\folder1\folder2\book1\sheet1 range (A?)....then the value of whatever is in the current workbook of A1"
Then when its week 2 that cell value in original book will be 2 and it will save it into A2, Week 3 will be 3 and so on
So its... copy from one cell, and paste in another workbook with what ever cell number value dictates in the current sheet of A1 ....at the start of this code before it saves.