|
|
|
|
#1
03-21-2017, 11:21 PM
|
|||
|
|||
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. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to transferring Word data to an Excel sheet
|
statue.919 | Word VBA | 16 | 06-18-2020 05:14 PM |
|
transferring data
|
tofimoon4 | Excel | 3 | 10-03-2016 11:57 PM |
| Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
| transferring data from ACT to Outlook?! | Rudi | Outlook | 0 | 12-05-2012 12:56 PM |
| Transferring data From One Office Suite To Another | Crlymop | Office | 0 | 02-24-2009 02:53 PM |
Windows 10 
Office 2016
Hybrid Mode