copying cell values from an active row using the offset function

I am trying to compile a list from multiple sheets based on a pass/fail user form. When I fail something, I want to add the rows to a new sheet.

Here is an example of the method I am trying to use

Please Login or Register  to view this content.

I know the first part is working properly, however it is not importing the original cell information. I am getting the second part off of what I searched online but it doesn't seam to work.

Thank you for your reply.

There really isn't much more code to show that is relevant to what I am asking unfortunately but maybe I can explain it better...

basically I click on a row and have a userform pop up. if I click on a fail button within my userform, I want to take the active row and column "B" and place that information on the next open row column "B on the sheet I have referenced "Deficiencies". Then do the same with column "C", "D" etc...

I use active sheet and active row commands due to I am using the same code in multiple sheets and rows. All compiling a list in the same "deficiencies" sheet.

I am taking some information from the userform and placing it back into the active sheet and active row using similar code to the above method and it works. just trying to extract it and place it in another sheet.

it works if I take out activesheet.

Top code works. Bottom code does not.

Please Login or Register  to view this content.