Stock Labels and info control

WERNER SLABBERT

WERNER SLABBERT

Board Regular
Joined
Mar 3, 2009
Messages
104
here goes,

i have a workbook with 2 sheets( at this stage. ) i would like to enter all the stock detail in the first into nice neat rows ( like excel does),
and then have the second sheet formulate the label ( to print for the bins ) with the data from the first sheet in certain order.

but in an effort to save paper i would print it 4 labels wide and 6 high on a standard A4 page...

my problem comes with the offset formula.... please tell me there is an easy-errrrr way to do this????

see sample book at below link.

Thank you in advance...

HTML: 
https://mega.nz/#!NBNgUa6b!8tvHsc33zKKUZ5zUgkv2VZBReybaNC5v8d_w7leUnzM

please help i beg of you all...
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
You must log in or register to reply here.

Similar threads

A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
401
AndyEd
A
M
  • Question
How to copy one row from the specific found cell from one sheet to another
Replies
0
Views
266
mahshadrashidpour
M
A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A
C
  • Question
Dont Print Certain Rows (if they're blank)
Replies
0
Views
344
c.clavin
C
U
  • Question
Information overwriting when transferring
Replies
7
Views
260
UTB
U

Forum statistics

Threads
1,215,059
Messages
6,122,917
Members
449,093
Latest member
dbomb1414

Share this page

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