Hi, I'm a bit new around in VBA and just wondering if is it possible to have a multiple Set historyWks = Worksheets("Database")? I'm also confused on how to tell this in English.
The example of my scenario is I have 9 columns in my input worksheet and 9 different worksheets. Each column must throw the new data per worksheet like column 1 must throw it to database1 and column 2 must send the data to database2.
Sorry for my bad interpretations. Hoping somebody can enlighten me. Many thanks in advance.
Bookmarks