Hi all
My second challenge...
I have a workbbok that contains a master sheet (Import fra Mamut). This is a result of a CSV-import on regular intervals and contains the following information:
- Column A = Vendor Number
- Column B = Vendor Name
- Column C = Vendor Item No
- Column D = Item No
- Column E = Item Name
The number of rows will change as I add or remove items from my database.
What I would like is to loop thru Column A and create a new worksheet with a name that matches the vendor no, i.e. value in column A is "50002" which would create a sheet called "RS Components".
However, if the sheet already exist it should obviosly not create a new one. It would be nice if the sheets where sorted alphabetically.
Once the sheet is created it should copy all rows with value "50002" in column A to the newly created sheet, or update if it's already existing.
I'm going to use this for calculating prices and stuff, and therefore I can't delete everything on the sheet (if it exist). Or, if possible, also create a routine that copies the formula to the newly added number of rows.
Range A:E will need to be updated from the master sheet to the newly created or updated sheets (column B is not really neccesary to be honest. I will start at column G with my calculations, 5-6 for each row.
Attached is a sample workbook that might show what I'm looking for.
Any help much appriciated.
Best regards
Lars-Inge
Bookmarks