It is hard to tell.

you find one variable he

straccount = objws.Cells(foundrow, 1).Value

on the sheet objws, but then you refer specifically to a sheet
Worksheets("Template")

for your other variables. I don't know if objws and Worksheets("Template")
are one and the same. If not, then I certainly don't know how I would find
the correct row on Template just by reading you code.

--
Regards,
Tom Ogilvy

"adncmm1980" wrote in message
...

Dear Guys (and anyone reading this post)

Thank you to the both of you for replying to my message :)

Tom Ogilvy
I can see now that I am only referencing row 2 in my code for columns
B,C,D. however, unfortunatley as I am an idiot I do not have a clue of
how to amend my code to get it to pick up the rest of my data with my
loop. I would be very grateful of any assistance you can offer.

N10

I have commented those lines out as they where part of the orginal code
that I wrote, what I probably should done was delete them to avoid
confusion. Please accept my apologies


Kindest Regards

Andrew


--
adncmm1980
------------------------------------------------------------------------
adncmm1980's Profile:
http://www.excelforum.com/member.php...o&userid=14965
View this thread: http://www.excelforum.com/showthread...hreadid=265919