help with macro please !!!

  • Thread starter Thread starter Anthony Warburton
  • Start date Start date
A

Anthony Warburton

I can't seem to get an answer for what seems a simple
task - can anybody help and reply in PLAIN ENGLISH so that
I can understand (or paste some VB script here)
call me thick if you wish!

I have a worksheet with the following example:-

Row Column A Column D Column G
2 01/01/2004 Mr Jones £300.00
5 06/04/2003 Mrs Smith £256.78

With the aid of a macro, I want to be able to copy the
selected data (as above) and paste it into another
worksheet, exactly as shown . I want the macro to be able
to perform this task over and over whilst keeping all the
information in the 2nd workshheet as a record.

Can any body offer any help????
 
Hi Anthony

the problem i see with what you want to do is that the copy range (from your
example below) is a non-contiguous range so its not a simple matter of
recording a copy macro .. is it always rows 2 & 5 & column A, D or G or does
this vary? if it varies how do you determine what the range to copy is?
how do you want it pasted - in row 1 & 2, then 3 & 4, then 5 & 6 or in row 1
& 4, then 5 & 8 etc?

Cheers
julieD


I can't seem to get an answer for what seems a simple
task - can anybody help and reply in PLAIN ENGLISH so that
I can understand (or paste some VB script here)
call me thick if you wish!

I have a worksheet with the following example:-

Row Column A Column D Column G
2 01/01/2004 Mr Jones £300.00
5 06/04/2003 Mrs Smith £256.78

With the aid of a macro, I want to be able to copy the
selected data (as above) and paste it into another
worksheet, exactly as shown . I want the macro to be able
to perform this task over and over whilst keeping all the
information in the 2nd workshheet as a record.

Can any body offer any help????
 
Hi Julie

thanks for your answer to my Excel Macro problem
I wish to ALWAYS copy from the same cells ie A4, D5, G68 ,
and H9, and these bits of data will be pasted into another
worksheet (eg "Deposits")into the same column headings
ie "Date", "Name", and "Amount" but each time I use the
macro I want it to paste the new data collected from the
first sheet onto the next available line in the "Deposits"
worksheet, thus keeping all the previous data collected.

Does that make sense, I'll give a little example if you
want to ctc me via my e-mail address, then I'll send you a
test excel sheet
Anyway, many thanks for your help/time I do appreciate any
help given as =
this is really puzzling me

Many thanks

Anthony
 
Back
Top