VBA Macro Assistance (I am desperate)

[adncmm1980]

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 column
B,C,D. however, unfortunatley as I am an idiot I do not have a clue o
how to amend my code to get it to pick up the rest of my data with m
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 cod
that I wrote, what I probably should done was delete them to avoi
confusion. Please accept my apologies


Kindest Regards

Andre

 

[Tom Ogilvy]

It is hard to tell.

you find one variable here:

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.