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
[TABLE="width: 777"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[/TR]
[TR]
[TD]Month of introduction</SPAN>[/TD]
[TD]Date</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]5</SPAN>[/TD]
[TD="align: right"]6</SPAN>[/TD]
[TD="align: right"]7</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]5</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]6</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL span=8></COLGROUP>[/TABLE]
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
[TABLE="width: 777"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[/TR]
[TR]
[TD]Month of introduction</SPAN>[/TD]
[TD]Date</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]5</SPAN>[/TD]
[TD="align: right"]6</SPAN>[/TD]
[TD="align: right"]7</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]5</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]6</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL span=8></COLGROUP>[/TABLE]