Re: copy data to another sheet
From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 08/16/04
- Next message: Patch: "Re: copy data to another sheet"
- Previous message: Simon Lloyd: "Re: How to stop having to re-assign macros every time you open a workbook???"
- In reply to: Patch: "Re: copy data to another sheet"
- Next in thread: Patch: "Re: copy data to another sheet"
- Reply: Patch: "Re: copy data to another sheet"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 15 Aug 2004 22:17:20 -0400
There was something offensive in trying to help you improve the quality of
your posts and make answering your questions easier?
--
Regards,
Tom Ogilvy
"Patch" <anonymous@discussions.microsoft.com> wrote in message
news:6a6b01c48333$375c8ec0$a601280a@phx.gbl...
> If you thought it was so "cute" then why did you bother to
> reply?
>
> Thanks anyhow!
>
> >-----Original Message-----
> >Using cute notation like MT to say empty just makes it
> less likely your post
> >will be answered. You interest is best served by
> clearly, simply and
> >completely stating your problem.
> >
> >Here is one possible interpretation:
> >
> >Sub Tester9()
> >Dim rng As Range, rng1 As Range
> >Set rng1 = Worksheets("Summary") _
> > .Cells(Rows.Count, 1).End(xlUp)
> >Set rng = Range("A10,A11,E22,F22,G22,H22,K60,L60,M60")
> >
> >i = 0
> >For Each cell In rng
> > cell.Copy Destination:=rng1.Offset(0, i)
> > i = i + 1
> >Next
> >MsgBox "Pasted at " & cell.Address
> >End Sub
> >
> >--
> >Regards,
> >Tom Ogilvy
> >
> >"Patch" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:677a01c4832b$8010e600$a501280a@phx.gbl...
> >> Hi -
> >>
> >> My VBA knowledge is very limited. I pretty much depend
> on
> >> the macro recorder to do my dirty work and I know that
> >> it's very inefficient. Here's what I want to do -
> >>
> >> I have a template sheet that gets filled in with data,
> >> both numbers and text. I want to copy certain bits of
> this
> >> data and paste it into a different workbook which I use
> as
> >> a summary.
> >>
> >> The data I want to copy/paste is scattered throughout
> the
> >> template and is for the most part in non-contigious
> blocks.
> >> I can handle the copy operation but the problem comes
> when
> >> I need to define the destination. I want the data to be
> >> pasted in the next MT row of the summary sheet in a
> >> different workbook. If it wasn't for the last row bit I
> >> could just use a formula cell to cell link like
> =Template!
> >> A10.
> >>
> >> Say for example I want to copy from the template sheet
> >> cells - A10,A11,E22,F22,G22,H22,K60,L60,M60 and have
> that
> >> pasted into the summary workbook on the next MT row,
> which
> >> might be row 12, in the range A12:I12.
> >>
> >> I also would like a msg box that pops up and confirms
> that
> >> the copy/paste was successful.
> >>
> >> I can handle creating a button and assigning the macro
> to
> >> it.
> >>
> >> Any help will be greatly appreciated.
> >>
> >> Patch
> >
> >
> >.
> >
- Next message: Patch: "Re: copy data to another sheet"
- Previous message: Simon Lloyd: "Re: How to stop having to re-assign macros every time you open a workbook???"
- In reply to: Patch: "Re: copy data to another sheet"
- Next in thread: Patch: "Re: copy data to another sheet"
- Reply: Patch: "Re: copy data to another sheet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
