Need help on repeating values in columns based on the table people count

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Edited as per Rules

Will this work for you.

If you edit value (columns 2 or 3 now but criteria can change if more columns you'll use) in sheet2 (same column) you will get result.

Hi Zbor,

This is brilliant. But how to extend the same for multiple weeks/column in sheet2. What criteria should I change.

I have data for next 75 weeks, which I need to update.

Can you help?

Thanks

Jus change IF part where it check for columns.
Instead of checking

Please Login or Register  to view this content.

You can check

Please Login or Register  to view this content.

Adjust for columns that you use.

Changed the IF part and it's worked perfect for me. Thanks a ton @zbor

Glad I could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

Hello,

Marking this thread as unsolved since I have a question.

Right now, the script is working good. Thanks again. But It works only when I copy each and every column numbers and paste here in to this sheet to generate the data. If I copy multiple columns numbers at one go, paste here, still it's populating only one column.

For example,

week1 week 2
Job1 3 1
Job2 2 2
Job2a 1 3

I need to copy week 1 column numbers ( 3,2,1) separately and copy paste into this sheet to generate week 1 jobs, and week 2 so on. I would like to copy week1,week2, till week75 numbers at one go and generate like below at one go.

week 1 week 2'
Job1 Job1
Job1 Job2
Job1 Job2
Job2 Job2a
Job2 Job2a

Is there any way to copy multiple column numbers to generate multiple columns.

Thanks