Copying cells from one sheet to another then filling down based on previous column

1. Copying cells from one sheet to another then filling down based on previous column

Hi There,

Don't suppose you can help me out.
I'm trying to find code for the following
Example attached
The Yellow Cells (which are the green ones just transposed), need to go to column M to column R in the Sheet 2.
They need to start in Row 2 and finish whatever the last row it.
This sample has 4 rows... some other jobs I have can have from 2 rows to 3000.

I'd prefer if the yellow cells I can get rid of, and some how just take the data from the green cells?
Workbook is attached: CHECKLIST.xlsm

Regards,
Mark

2. Re: Copying cells from one sheet to another then filling down based on previous column

But while copying the cells from Sheet 1 to Sheet 2, how do you determine against which cells the copied cells are to be pasted to?

3. Re: Copying cells from one sheet to another then filling down based on previous column

Hi,

Its determined by the number of rows. In this samples case 4 are required.

Hath

Rugs,
Mark

4. Re: Copying cells from one sheet to another then filling down based on previous column

Hi,

I've uploaded a copy of what i'm trying to achieveCHECKLIST - FINAL.xlsm..... see how there is a row per existing data?

Regards
Mark

5. Re: Copying cells from one sheet to another then filling down based on previous column

Don't suppose anyone has had alook?

6. Re: Copying cells from one sheet to another then filling down based on previous column

So the data in sheet 1 B6:B11 should be copied to all the rows present in sheet2?

Do you want the action to happen on the click of a button or once a particular cell / cells is updated?

7. Re: Copying cells from one sheet to another then filling down based on previous column

Hi arlu

That is correct.

Rugs
Mark

8. Re: Copying cells from one sheet to another then filling down based on previous column

Try this
``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1