Re: $$Excel-Macros$$ Looking for codes to copy and paste same
> items into different sheets
>
>
>
> Try this for copying selected values in different sheets
>
> Sub test()
> Set Rng = Selection
>
> For Each cls In Rng
> For Each wks In ThisWorkbook.Sheets
> If wks
Vasant,
What are these codes doing?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Vasant
Sent: Monday, June 20, 2011 12:37 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Looking for codes to copy and paste same items
into different
Try this for copying selected values in different sheets
Sub test()
Set Rng = Selection
For Each cls In Rng
For Each wks In ThisWorkbook.Sheets
If wks.Name <> "Shop A" Then
wks.Range("A" & Trim(Str(wks.Range("A65536").End(xlUp).R ow +
1))) = cls
End If
Next
Next
End Sub
On Mon, Jun 20, 2011 at
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of John Mutesi
Sent: 20 June 2011 01:13 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Looking for codes to copy and paste same items
into different sheets
Dear friends,
See attachment
Dear friends,
See attachment for this problem.
I want a code which ask you to select the product name (coffee, tea, sugar etc)
in Shop A. Once selected, the product names should be copied and pasted into
shops (shop B to shop E) below the heading. I thought of having a copy which
uses an arra
