Thread: Transferring data from one sheet to another
View Single Post
 
Old 03-21-2017, 11:21 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Please note that next year (2018) you may have to adjust the starting cell for AllNames. Shop1.Income etc.

Note also that I have changed the content of Sheet1!A6:A7, from text strings to real Excel dates (the latter is always to prefer). The formula in cell A2 will always give the date of the first Monday efter April the 6th. In cell A245 you have 31st November 2017. As you know there is no such date, and it will not appear if you copy the formula in A7 down.
Reply With Quote