If cell in column B(tab1), copy tab2 and paste value from column B(tab1) into new tab

[Ron Burgundy]

Hi guys

Tab1 has values in column B. For each value in column B I want to copy tab 2 and paste the value in cell B3 of the new tab.

Please let me know if you need more detail.


Thanks,

Ron

[MWE]

Ron: Welcome to the forum. A word of advise when posting: always start with the version of Excel you are using and the operating system on your computer.

If I understand your question

1. you have a spreadsheet with two tabs, "1" and "2"
2. tab 1 has data of interest in col B
3. for each non blank cell in col B of Tab 1 you wish to do something; what that is is not clear
4. when you say "copy tab 2", what is to be copied? From you next few words, "and paste the value in cell B3", I assume you have a single cell in tab 2 that you wish to paste into cell B3 of an undefined tab. What is "the new tab"?