Captain Hindsight
New Member
- Joined
- Oct 9, 2013
- Messages
- 46
Hi,
I have a long sequence of numbers running horizontally on one tab of a worksheet.
I want to paste this set of numbers into a grid on a separate tab, if the column ref = the row ref ONLY IF the value in column C > 0.
It should look like the below, so as you can see if column C (to the right of the dates) is equal to 0, nothing is returned.
If it is > 0, then where, for example, jan-16 = jan-16, then the horizontal set of numbers is pasted.
Any suggestions?
Thanks
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=8></COLGROUP>
I have a long sequence of numbers running horizontally on one tab of a worksheet.
I want to paste this set of numbers into a grid on a separate tab, if the column ref = the row ref ONLY IF the value in column C > 0.
It should look like the below, so as you can see if column C (to the right of the dates) is equal to 0, nothing is returned.
If it is > 0, then where, for example, jan-16 = jan-16, then the horizontal set of numbers is pasted.
Any suggestions?
Thanks
Dec-15</SPAN> | Jan-16</SPAN> | Feb-16</SPAN> | Mar-16</SPAN> | Apr-16</SPAN> | May-16</SPAN> | Jun-16</SPAN> | Jul-16</SPAN> | |||
Month of introduction</SPAN> | Date</SPAN> | 1</SPAN> | 2</SPAN> | 3</SPAN> | 4</SPAN> | 5</SPAN> | 6</SPAN> | 7</SPAN> | 8</SPAN> | |
1</SPAN> | Dec-15</SPAN> | 1</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> |
2</SPAN> | Jan-16</SPAN> | 3</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | |
3</SPAN> | Feb-16</SPAN> | 2</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | ||
4</SPAN> | Mar-16</SPAN> | 2</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | |||
5</SPAN> | Apr-16</SPAN> | 4</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | ||||
6</SPAN> | May-16</SPAN> | 3</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | |||||
7</SPAN> | Jun-16</SPAN> | 0</SPAN> | ||||||||
8</SPAN> | Jul-16</SPAN> | 3</SPAN> | 0</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=8></COLGROUP>