Need to automatically extract 10~12columns of values onto a fixed template for consecutive printing on another sheet.

Henrysung1995

New Member
Joined
Feb 18, 2021
Messages
1
Office Version
  1. 2007
Platform
  1. Windows
Heya :S
I'm trying to use excel to automatically fill in my Journal vouchers for transaction recording.
What I would like to figure out is how I can type in a list of values on one sheet (let's call it 'Journal Input'), roughly 10~12 columns in total and contains both words and numbers, and have it automatically transferred to my voucher template for printing.
Because the physical size of my journal voucher is already set, values from columns on 'Journal Input' would have to be on specific cells.

The first column would be a serial number for each voucher of the same year and month, ex. 2102-001, 2102-002, 2102-003.....and so on

Please help! thanks
Check out the image for what the journal voucher format looks like

-Henry
 

Attachments

  • Screenshot 2021-02-18 150623.jpg
    Screenshot 2021-02-18 150623.jpg
    37.2 KB · Views: 7

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,129,278
Messages
5,635,254
Members
416,849
Latest member
truerock

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
Top