Hello everyone.
I'm trying to automate Excel's autofill feature for attached Spreadsheet (As-is) so I can use a Pivot table to summarize my data. See link for TO-BE Spreadsheet.
I don't even know where to start, so any help would be much appreciated. At the moment, I'm double-clicking the bottom right corner of each cell to get the cells below to autopopulate.
AS-IS
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
TO-BE
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
I'm trying to automate Excel's autofill feature for attached Spreadsheet (As-is) so I can use a Pivot table to summarize my data. See link for TO-BE Spreadsheet.
I don't even know where to start, so any help would be much appreciated. At the moment, I'm double-clicking the bottom right corner of each cell to get the cells below to autopopulate.
AS-IS
PART_ID</SPAN> | LOT_SERIAL_ID</SPAN> | EXPIRATION_DATE</SPAN> | AVAIL_QTY</SPAN> | AVAIL_HOLD_QTY</SPAN> |
005557731104</SPAN> | ||||
20130502</SPAN> | 2013-11-28</SPAN> | 1620</SPAN> | 0</SPAN> | |
005557731176</SPAN> | ||||
20130110</SPAN> | 2013-08-08</SPAN> | 68</SPAN> | 0</SPAN> | |
20130305</SPAN> | 2013-10-01</SPAN> | 216</SPAN> | 0</SPAN> | |
005557731278</SPAN> | ||||
20130613</SPAN> | 2014-01-09</SPAN> | 2880</SPAN> | 0</SPAN> | |
005557740042</SPAN> | ||||
20130116</SPAN> | 2013-11-17</SPAN> | 15</SPAN> | 0</SPAN> | |
20130326</SPAN> | 2014-01-25</SPAN> | 54</SPAN> | 0</SPAN> | |
20130327</SPAN> | 2014-01-26</SPAN> | 180</SPAN> | 0</SPAN> | |
20130526</SPAN> | 2014-03-27</SPAN> | 120</SPAN> | 0</SPAN> | |
005557742061</SPAN> | ||||
20121222</SPAN> | 2013-07-20</SPAN> | 18</SPAN> | 0</SPAN> | |
20130312</SPAN> | 2013-10-08</SPAN> | 270</SPAN> | 0</SPAN> | |
005557742062</SPAN> | ||||
20121218</SPAN> | 2013-07-16</SPAN> | 540</SPAN> | 0</SPAN> | |
005557742063</SPAN> | ||||
20130215</SPAN> | 2013-09-13</SPAN> | 198</SPAN> | 0</SPAN> | |
20130312</SPAN> | 2013-10-08</SPAN> | 180</SPAN> | 0</SPAN> | |
20130327</SPAN> | 2013-10-23</SPAN> | 180</SPAN> | 0</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
TO-BE
PART_ID</SPAN> | LOT_SERIAL_ID</SPAN> | EXPIRATION_DATE</SPAN> | AVAIL_QTY</SPAN> | AVAIL_HOLD_QTY</SPAN> |
005557731104</SPAN> | ||||
005557731104</SPAN> | 20130502</SPAN> | 2013-11-28</SPAN> | 1620</SPAN> | 0</SPAN> |
005557731176</SPAN> | ||||
005557731176</SPAN> | 20130110</SPAN> | 2013-08-08</SPAN> | 68</SPAN> | 0</SPAN> |
005557731176</SPAN> | 20130305</SPAN> | 2013-10-01</SPAN> | 216</SPAN> | 0</SPAN> |
005557731278</SPAN> | ||||
005557731278</SPAN> | 20130613</SPAN> | 2014-01-09</SPAN> | 2880</SPAN> | 0</SPAN> |
005557740042</SPAN> | ||||
005557740042</SPAN> | 20130116</SPAN> | 2013-11-17</SPAN> | 15</SPAN> | 0</SPAN> |
005557740042</SPAN> | 20130326</SPAN> | 2014-01-25</SPAN> | 54</SPAN> | 0</SPAN> |
005557740042</SPAN> | 20130327</SPAN> | 2014-01-26</SPAN> | 180</SPAN> | 0</SPAN> |
005557740042</SPAN> | 20130526</SPAN> | 2014-03-27</SPAN> | 120</SPAN> | 0</SPAN> |
005557742061</SPAN> | ||||
005557742061</SPAN> | 20121222</SPAN> | 2013-07-20</SPAN> | 18</SPAN> | 0</SPAN> |
005557742061</SPAN> | 20130312</SPAN> | 2013-10-08</SPAN> | 270</SPAN> | 0</SPAN> |
005557742062</SPAN> | ||||
005557742062</SPAN> | 20121218</SPAN> | 2013-07-16</SPAN> | 540</SPAN> | 0</SPAN> |
005557742063</SPAN> | ||||
005557742063</SPAN> | 20130215</SPAN> | 2013-09-13</SPAN> | 198</SPAN> | 0</SPAN> |
005557742063</SPAN> | 20130312</SPAN> | 2013-10-08</SPAN> | 180</SPAN> | 0</SPAN> |
005557742063</SPAN> | 20130327</SPAN> | 2013-10-23</SPAN> | 180</SPAN> | 0</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>