Exactly what I was looking for Thanks, Steve
On Apr 7, 5:55 am, Dave Bonallack wrote:
> Hi Steve,
> Try this code. It assumes data is in Columns A and B, as stated, and that the
> data starts in Row 2.
>
> Sub Steve()
> Application.ScreenUpdating = False
> A = 2
> B = 2
> C
Hi Steve,
Try this code. It assumes data is in Columns A and B, as stated, and that the
data starts in Row 2.
Sub Steve()
Application.ScreenUpdating = False
A = 2
B = 2
C = 2
For i = 1 To 100
Do Until Cells(A + 1, 1) <> ""
Cells(B, 2) = WorksheetFunction.t
hello Steve ,
try this
= concatenate( Box with, Cover and,4 slotted sides)
u can there by combined all the above rows into one
alternatively
=concatenate(rowc2,rowc3, rowc4)
will give the required result
thankx n regards
Rajat Jain
kolkata
rajatv...@gmail.com
On Tue, Apr 7, 2009 at
Steve,
You can do it with a simple formula if you want:
If you have data in cell A2 and B2 you want to join, the following formula
will work:
=A2&" "&B2
Then you can copy and paste special (Values)
Norman
On Mon, Apr 6, 2009 at 4:55 PM, Steve wrote:
>
> Hi,
>
> I could really use some help
Is it something you have to do often? or is it one time?
It could be done with a formula, but if it has to be done often, then it would
be better with a macro.
pretty easy with a macro...
Paul
From: Steve
To: MS EXCEL AND VBA MACROS
Sent: Monday, April 6,