Forum Discussion
AUTO COPY AND PASTE
Check the column F in attached sheet, find the formula in cell F4 downwards,, I hope that you are looking for this.
In cell F3, you need to enter number smaller/prior than H3, like is 1 then 0. This will copy automatically in H4:H54, this may vary depends on the set of numbers to want to get.
Remember cell H4:H54 has formula ,, need to be handled carefully.
I'm using this vba to print
Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As RangeSet KeyCells = Range("F3")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing ThenActiveSheet.PrintOut
End If
End Sub- This VBA code will print the current sheet/part of it what so every when cell F3 has no value,, then could you please write me,,, how you get value in F3,, from Keyboard or through formula,, if using formula then using which cell to copy in F3 !
I dont have a formula i need a vba that will detect if the cell is empty or if there is something there and if there is something there it would copy to f3
- I'm confused,, since ActiveSheet.PrintOut prints the Active sheet, I mean the entire sheet, are you sure that you want this only or something else !!
i have set print area so it would only print part that i need
Hi
No that's not it
i need it that when I copy data in starting from H2 it would automatically copy and paste the cell to F3
ind the data i past in there is random numbers
and it could be 5 lines of data like from H2 to H7 or it could be 100 lines off data like from H2 to H102
i need excel to detect if and copy the cells only if they have data in them
and i need it to be done one cell at the time
so i can use my print vba to print the label every time f3 have bin updated