I am needing some help in creating a VBA code in excel to do the following.
1. The physical card where the data goes is in sheet "MAIN"
2. The data that would need to go there is in sheet "FACS"
3. In "FACS" there are 41 columns of data and 250 rows with card numbers assigned in Cell A2:A251. All the data for that card number are in the columns corrosponding to the card number.
4. The FACS cards need to be randomized where it will go through the entire deck before automatically reshuffling or done by a manual reschuffle.
5. The data would then be transferred to the appropiate location in the sheet named "Main". ( The location where that data should go is shown in the sheet named "location"
The sheet names "location" shows where I need the data from sheet "FACS" to appear in sheet "MAIN"
I have attached the excel document for better understanding. Thanks for any help that can be given as it is greatly appreciated. The card numbers that currently have no data in it will be completed soon.
Excel Workbook here
1. The physical card where the data goes is in sheet "MAIN"
2. The data that would need to go there is in sheet "FACS"
3. In "FACS" there are 41 columns of data and 250 rows with card numbers assigned in Cell A2:A251. All the data for that card number are in the columns corrosponding to the card number.
4. The FACS cards need to be randomized where it will go through the entire deck before automatically reshuffling or done by a manual reschuffle.
5. The data would then be transferred to the appropiate location in the sheet named "Main". ( The location where that data should go is shown in the sheet named "location"
The sheet names "location" shows where I need the data from sheet "FACS" to appear in sheet "MAIN"
I have attached the excel document for better understanding. Thanks for any help that can be given as it is greatly appreciated. The card numbers that currently have no data in it will be completed soon.
Excel Workbook here
Last edited:
