|I would be very grateful if someone could help. I have a worksheet ("Fixtures&fittings") which contains information on what fixtures and fittings are needed for cxertain rooms in a house. column E contains the Type for fixture or fitting that is needed eg cushions, wallpaper ect|
I need to create separate worksheets for each of the fixtures involved, containing all the information across the row They are a mixture of text, dates and numbers.
Is it possible to write a macro that will be able to do this? I would be very grateful for any help, as I have never tried to write a macro before. Also once i've written and set up this macro will it the amend if i change any of the data on a sheet on the other sheet, and i i add a new row will it put it onto the correct corresponding sheet the I am using Excel 2003.