Maintain range when inserting columns

I have a macro recorded that inserts into column E in the attached report, and then retrieves data from another worksheet in the workbook. In column D I am trying to keep a 6 month average which includes the latest inserted data, however every time I insert a column the relationship with column D is moved out by one. e.g. range E8:J8 becomes F8:K8.

I am also stuck with setting up a macro to import a new model into the report. I have set up a worksheet called new model with the manufacturer, model and fail descriptions, however all macros I have recorded fail when trying to insert the manufacturer and model into mulitple cells. I have given up on this, so if you are able to help me out with this as well that would be super helpful.

thanks

If you can't attach the file it is probably due to size, try zipping it first

file is only 700kb

LOL, you guys in the Big Smoke think that's trivial? Consider us poor Xtra customers on rural lines

Originally Posted by dperry

managed to work something out myself

Could you please briefly outline what the solution is, for the benefit of people who may have a similar issue and read this.

cheers

well, it's probably not the smartest way of doing it, but I basically copied the data and pasted it one column to the right and then inserted required data into the first column, this stopped the average funtion from moving across with the original data. Code is:

Please Login or Register  to view this content.

if you have any better ideas...

Please take a few minutes to re-read the forum rules, and then edit your post to add code tags.

Thanks.

I'll undo the infraction, you fix the code tags.