Jan 01 2021 04:26 AM
Copy on one excel sheet, called “Accounts”, a copy of a highlighted file (located on an excel Sheet called “File”), consecutively underneath each copied file, with different data (from an excel Sheet called “Factors”), for each copied file. Maybe copy the file 1000 times with each file underneath the previous file.
Example:
Data for file on a sheet called “Factors”
Table | Percent | Factor |
Table 01 | 13% | 3% |
Table 02 | 21% | 5% |
Table 03 | 18% | 1% |
Table 04 | 19% | 2% |
Table 05 | 7% | 1% |
Table 06 | 19% | 5% |
Etc.
Excel Sheet called “File” with highlighted area
| Item | Item | Percent | Factor | Finial |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Excel Sheet called “Accounts” (blank to begin with) but after processing…
Table 01 | Item | Item | Percent | Factor | Finial |
|
|
| 13% | 3% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 02 | Item | Item | Percent | Factor | Finial |
|
|
| 21% | 5% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Etc.