PDA

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



Ron Burgundy
03-08-2016, 08:54 AM
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
03-13-2016, 11:48 AM
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


you have a spreadsheet with two tabs, "1" and "2"
tab 1 has data of interest in col B
for each non blank cell in col B of Tab 1 you wish to do something; what that is is not clear
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"?