Create new worksheet dependant on data

W

WYMMIY

All

I have a worksheet which has various col, what I would like to do is
to be able to create a new worksheet dependant on data in COL D so for
example i would like to be able to split Apples into one worksheet and
then Pears ( along with the 40 other cols which relate to apples or
pears)

184 apple
207 apple
208 apple
209 apple
184 Pears
207 Pears
208 Pears
209 Pears


At first i thought pivot table but as i have to do this twice a month
i thought VBA/marco - the previous person used to copy and paste and i
think that just a waste of time.!!!

thanks

M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create new worksheet dependant on data 2
VBA/Macro help 4
vba/marco help 0
Repeat values in column A a certain number of times depending on thevalue in column B 7
Create worksheets from data 1
Parsing, separating, inserting. copying 2
Copy new data to worksheet 11
Import data and keep duplicate rows of data 0

Top