Copy Data from Cells A Sheet1 to Sheet2 E1 and then Sheet 3 B3

Hi and thank you this is a project I was working on last year and just stopped or gave up.

I am Total Newbie at excel but with help from members last year a managed to put this project together with snippets of code what I was trying to do was create A booking interactive form to make booking in goods allot easier I have gone as far as I can But what I am trying to do is.......

To copy pasted values from sheet1 and paste to sheet2 x amount of times or booked in rows and then also paste that value to sheet3 B3 and print if you have a look at the Excel file and play about with it might give you a better understanding.

I think I explained what it was i was asking for help for but if not message me and I will try to explain a bit further

Thank you.

Hi Dess,

Welcome to the Forum!

I think we could more easily help you if you included some data in your sample

Originally Posted by Dess

what it is I'm trying to do is COPY Sheet1 Column "A" Down X amount Based on Cell Value on Sheet4 "F1" and then Paste to Sheet2 Column "E"

Ok so I have figured out the part quoted above but Im still having an issue with printing out each cell one at a time on Sheet3 "B3" I think this would need to be add to the VBA print code which Im looking into but finding it difficult to figure out.

The code I used for the Quoted section Above was-

Dim rColumn As Range
Dim rCopy As Range
Const TargetColumn As String = "E"

Set rColumn = Sheet1.Columns("A")
Set rCopy = Sheet4.Range("F1")

Dim Sb As Long
Sb = Sheet2.Range(TargetColumn & Rows.Count).End(xlUp).Row
Sb = Sheet2.Range(TargetColumn & Rows.Count).End(xlUp).Row + 1
Cells(Sb, TargetColumn).Resize(rCopy, 1).Value _
= rColumn.Value

which I figured out by myself which I was quite chuffed as Im No excel expert but managed to get there YAY me!

But now I might need help to Increment Sheet3 "B3" by Each Cell from Sheet2 Column "E" On PrintOut

A Updated Excel File Attached Below and pictures Below to illustrate but i have inserted them the wrong way round the pictures start from bottom to top sorry for a poor post in advance

if im understanding your current issue....its the pallet label printing bit??
if so would this be in line with what you want?

Please Login or Register  to view this content.

thanks for the rep
just be advised that

Please Login or Register  to view this content.

works because its a controlled environment
ie you control what goes into column D

alternatively you can use

Please Login or Register  to view this content.

<D36 as this is the last row before your "Footer"