hi all,

Im developing a macro, where in it should pick up Column called Apple from sheet called Raw data F and paste it in sheet called master and and again from sheet Raw data F it should pick up column called apple Juice and paste it in adjacent column to apple in sheet called Master.

Similarly next move to Sheet called Raw data G and pick up column called orange and paste it just below where apple contents end and pick up orange juice column from sheet Raw data G and paste it again in master sheet just below where the previous contents would have ended for apple juice.

Ideally all apple and orange should be in one column in master sheet and both juices should be in one column, this is because I would like to do pivot table on both these for analysis.

Please help on macro