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
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"?
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.