Transfering data between tabs using code.

[greenteafiend]

I am looking to transfer data from one tab to another without having to manually transfer the data. Ideally the code I use will select the data according to the job number in column A, and must not affect the current code that is present in the spreadsheet. The reason I need to find some code is that I don’t want to transfer the blank data entries that can be seen in TAB 1, I only want the data entries that contain numerical values.


THE CURRENT CODE

=IF(COUNTIF($A$2:$A2,$A2)=1,INDEX($D2:$D$9948,MATCH(E$1,$C2:$C$9948,0)),"")


Once the data is transferred to Tab2 I would like to be able to delete the columns “cost type” and “value” without affecting the performance of the current code



TAB1
\1


TAB2
\1

I hope this has been explained well enough! Any help would be much appreciated!

Thanks

[royUK]

The example is a formula! What do you want, a formula or code?

Also, why are you transferring data, it would be more efficient to use a PivotTable or similar Excel function.