Hi,
I have a simple Excel sheet (attached) that I use for generating Google AdWords ads for book related website. On "Sheet2" i enter three parameters. Title, author and a URL. On the "Nye Annoncer" sheet that data formatted for importing on AdWords.
However, I am not an Excel genius. For each line on "Sheet2" there are four lines in the "Nye Annoncer" sheet - and I don't know how to automatically add these. I have added 15(x4). However I would like to do a 1000+ new ads, so it would be a lot simpler if the "Nye Annoncer" sheet automatically adapted/updated no matter how many lines where entered on "Sheet2".
Confused? Download the attached file and hopefully it makes more sense. I think this is quite simple to set up if you know Excel and maybe macros well.
Best,
Anders
I can create a macro for you to do this job, such jobs are my daily practice.
In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
But first you should specify the source or rules of generating of columns A (is it constant?), columns C:G, J (is it constant?).
Regards!
Have a Good day. I thanks to freelancer team for providing this type job. I have experience about doing job on excel since last three years. I am interested to do this type of job.