Check cell Value in range and copy specific cells to another sheet

[jmethejedi]

Hi

I am getting stuck in some illogical thinking in my logic.

I am hoping someone can review the attached document and provide some feedback on how to make the following work:

If cell in range = true
Copy selected Cells from sheet A to selected cells on sheet B

My code was working but unfortunately the logic of the code was wrong.

I was successfully checking the range and when true it would copy the first row as originally set in the first part of the code. Then when the cell was true the next time my code was incrementing by one so it would copy the next row not the one that was actually true.

I admit that I butchered some code from previous forms.

All is attached in the spreadsheet - Please refer to Module2

[apo]

Hi..

Try changing the code you have in the Sub DocIndex() to this..

Please Login or Register  to view this content.

[jmethejedi]

Hi Apo

Thanks for that. Works great except it is not picking up the MA.Cells(LastRow2, 4) for the document number.

Are you able to shed any light on that?

[jmethejedi]

Hi There

I do have another issue.

I would like to create a count. Where the item CT = 001 I actually want to be able to increment the number on the document number if the Acronym has already been used.

Example.

Item Type = Quality and is first one = 12345-Q-001
Item Type = Quality and is second one = 12345-Q-002

How could I achieve that?

[apo]

Hi..

For this part..

Works great except it is not picking up the MA.Cells(LastRow2, 4) for the document number.

Change this..

Please Login or Register  to view this content.

to this..

Please Login or Register  to view this content.

As for this part...

I would like to create a count. Where the item CT = 001 I actually want to be able to increment the number on the document number if the Acronym has already been used.

I think you would have to create a Count for each Acronym... and set CT to the count value + 1 of the specific Acronym..

I will have to think on it.. hopefully someone else gives you a solution to that sooner..

[jmethejedi]

Thank you for the help you have provided thus far. Everything is working great - now to work out this count....