Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data

2014-10-25 Thread ivavok
Hi pramodb35, Thank you very much for your help! It is almost perfect;) Please have a look at the file attached. I have tried it for more rows for each type and it does not work correctly in that case:( The "type" is then not correctly copied in each row of column "type". I cannot figure out wh

Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data

2014-10-25 Thread Pramod Singh
Hi ivavok , Please find the attached file as per your requirement... On Fri, Oct 24, 2014 at 5:31 PM, ivavok wrote: > Hello, > > I would be grateful for help. I have had some break using VBA and I now need > to get the table attached adjusted in a certain way to be able to work with >

$$Excel-Macros$$ Please help on VBA- adjustments of a table with data

2014-10-24 Thread ivavok
Hello, I would be grateful for help. I have had some break using VBA and I now need to get the table attached adjusted in a certain way to be able to work with it later on: 1/ keep the first row with headings 2/ insert a new column after the first column and name it: Type 3/ always take the cont