macros for excel 2003

May 10, 2011 at 09:22:35
Specs: Windows Vista
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.

See More: macros for excel 2003

Report •

May 10, 2011 at 12:50:34
This is sooo close to a relational database. Yes, you can link cells from one sheet (cost of goods) to the finished sheet(s) for each product. A macro is not the thing to do this (overkill), Just link the cells. K.I.S.S.
Of coarse, not seeing your project makes it difficult. Also, appears to be for a (for profit) organization. Basic help is not much of a problem to get you going. Advanced help, not so much as so many certified are out of work.

Report •
Related Solutions

Ask Question