Creating a Card Flipper using VBA

Cquake

Board Regular
Joined
Dec 12, 2017
Messages
60
Office Version
  1. 2016
Platform
  1. Windows
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
 
Last edited:

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,224,551
Messages
6,179,470
Members
452,915
Latest member
hannnahheileen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top