Thanks again for your reply.
Forgive me, I'm painting with a very broad brush which relies on pseudo programming shorthand.
There are several worksheet (wks) in workbook (wbk) Search. Daily, In, & Track
are just a few.
Daily Dx '+In!Bx' Daily is a wks. Dx is an abbreviated A1 reference style where the columns are labeled using the Alphabets and the rows are labeled using numbers, i.e., D is column 'D' and x=5-168 or D5-D168.
Each cell in aforementioned range, i.e., D5-D168, contains '+In!Bx' The '+' creates a link between cells in the same worksheet or workbook. In this case, it links to
wks 'In' and a range of cells where B is column 'B' and x=5-168 or B5-B168. These cells contains values which are linked into Daily column D.
"Are you saying that you have a series of Nested If's in Daily K5:K168 and that based on the results of those Nested If's you want visual basic code, (VBA), to copy data from Column B of Sheets(In) to either Column C or Column F of Sheets(Daily)?" Yes! A copy of the data from Column B of Sheets(In) via the link now resides in Daily Column D.
The code is stable has been in use for years, but requires a lot of time when done manually. The only feature that might appear to be a redundancy is the stop the
data makes at wks 'In' prior to being distributed to the supporting wks. 'In' is where
all the data is inspected, filtered, & verified. Seach is rather a modular, object oriented system. Each sheet has it's own function.
"Doesn't that raise the possibility of the result of the Nested If changing and thereby requiring the code to be run again?" Yes, the code is run on each batch of data
received throughout the day & Daily sorts it each & every time. That why an automated, i.e., visual basic subroutine, would result in a material efficiency
improvement. Your previous code, again thank you, has provided a material
reduction in errors. With your help on this problem, another material improvement
should be realized.
This is my first time seeking & receiving help, & I'm VERY grateful for your kindness
and patience. Thank you, DerbyDad03!