Hello everyone. Found this site and one old thread caught my eye. I'm trying to do something similar to what this person was doing except I am trying to figure out how to make it post the Value from the columns and not just the cell data itself. In a nut shell I am trying to automate a log of everything generated but I am missing something I am sure. I'm running Office365.
The formulas I am using will be as follows.
I use this one for generating the serial numbers based on criteria in the boxes I have linked.
And I use this one to link two cells together for a datamatrix barcode that gets printed on a label. It helps to link the part number and serial number together while placing a space between. It's this DataMatrix cell values that I need to store and not the formula.
This is the old thread I found. It was quite informative and helped me with some other things that I was messing around with at home. Attached is the format that I am working with more or less. I have two Workbooks I am trying to do this particular capture of values with. One has 9 sheets that I need to link and the other has 8. Is what I am doing even possible and I am over complicating it or is there a more simplistic way for me to achieve what I am try to accomplish.ExampleValueCapture.xlsx