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
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"?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.