paste on same work sheet

[srini_tbcl]

Dear friends,

Pl find enclosed a sample spread sheet.

Pl help me to have a VBA code to create slips on same worksheet (one after another). Presently i am using Vlookup.

Regards

Srinivas

[Richard Buttrey]

Why?

If you are wanting to create and print lots of different slips, or even if you don't and just want to look at a particular slip, treat the slip as a template sheet and have a macro that runs down the data sheet and populates the template for each row. Either by populating B1 with the number from each row in column A or write the row details direct to each cell in B2 & B4:E4

See attached as an example. Just double click in the data table

[RudiS]

Try this...

[Olly]

try:

Please Login or Register  to view this content.

[RudiS]

Olly,

Great trick with using SpecialCells(xlCellTypeConstants) for the borders.
I wish I thought of that!

[Olly]

Olly,

Great trick with using SpecialCells(xlCellTypeConstants) for the borders.
I wish I thought of that!

I saw your workbook after I posted my code. They're nearly identical! Great minds think alike...

Thanks, re. borders. They can be laborious to apply, so I like trying to find shortcuts!

[RudiS]

I will certainly remember it from hence forth. I'll call it the Olly Borders Trick.
I think your engrafted into stone in my mind now! LOL

[srini_tbcl]

Dear Friends

Many thanks...

Regards

Srinivas