Hi everyone,
Im trying to solve this puzzle, and because im not that skilled with VBA, i do not know if it is even possible.
What im trying to achieve is to find a way how could i modify below code, in order it can be dynamic and not static, when it comes to final destination to which value is copied to.
For example:
This code is copying H27 in to B352 located on different tab. Thing is, that this process is based on assumption that elements located on "Hardware Data Base" tab are always in the same place. But if someone would remove or add 1 line to this list, then original location of B352 cell will be moved.Please Login or Register to view this content.
So im using MATCH function next to each cell at "Bundle Selections" to show what is the cell number on the other tab, this is some kind of control check. As You can see my "destination" cell to which im copying H27 is static - written in the code, but what im looking for is to find a way to make it dynamic.
Instead of B352 i need to have there something like :
Range("BMATCH(F27;'Hardware Data Base'!D:D;0)").Select so ech time that Match will return new row number, it will automatically include it in to VBA code with column B.
Is that even possible? : /
Bookmarks