VBA for loop required - this will be peanuts for the experts in this forum

[clintazz]

All,

I need a vba code which i probably can do after spending 2 days researching, trial and error but my boss wants a job done ASAP so im reaching out for your help.

I included an attachment which i guess is the best way for me to explain what i'm after.

So essentially the figures in the black box in the workings worksheet are linked to cell starting D4 in the worksheet List.

The agent name in the worksheet 'working' will change according to the agent number in cell D2

The logic that i am after is
- in the worksheet workings Cell D2 is first set as one and the values in the worksheet List from cell range D4 to L4 is copied in cell starting B4
- in the worksheet 'workings' cell D2 is added by one (the agent name changes with the vlooup, the vlaues in the black box will also change based on logic that i will build)
- again the values in the worksheet list from cell range D4 to L4 is copied in the next row below the previous agent data so this would be B8.

The loop would stop based on an initial number that the user inputs. So if i have (say) 100 agents i would key in 100 and the loop would stop at 100.

[oeldere]

Probably I can't help you with your VBA question.

Maybe I don't understand the question, but the sheet "Working" seems to be filled in manualy.

Or is it filled with extern data?

[clintazz]

The data in the black box will be based on logic that i will build

[oeldere]

If it is a manualy input, why not manuly input it in sheet List?

[jindon]

Do you want to update when you change Working!D2?

To Working sheet code module

Please Login or Register  to view this content.

[clintazz]

Yes i would like it to update whenever D2 changes and that needs to be a loop

[jindon]

Did you try the code?

[clintazz]

When i go to view macros i dont see anything there, i need to see the code as i need to tweak it as my model is much more complicated than that

[jindon]

Ahhh, Now I think I understand how you want it.

Please Login or Register  to view this content.