compare, match, and copy to next blank row

[nobby2193]

Hi all learned ones

I need to compare sheet1 (my Calls) with sheet 2(stores), when there is a match ( Idealy by store number AND name), copy the combined contents of the compared rows ( sheet one and sheet 2) to the next availablle free row on sheet 3 and so on ( this can be say rows a to g from sheet1 to sheet 3 row a to g AND sheet 2 row a to b to sheet 3 row h to k)
This appears to be such a simple task but I cannot get past using ( and failing) with vlookup etc.
I guess its a macro then which is beyond my knowledge
Thanks in advance

 

[hiker95]

nobby2193,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[nobby2193]

Hi Hiker95
Im using office 2010 and get error messages when I try to run any of the programs listed on your reply ( the help says they do not support this version )

I cant seem able to upload a zipped file to you through the message board, do i not have adequate permissions ?

I do however, have a pogoplug which alows me to send a link to your email address ( you provide any password (which I never have access to)) this gives a dedicated folder on my external hard drive for you to download my sample file and upload any other inforamation you want to
Is this any help ?
Thanks and sorry for all the extra work

 

[hiker95]

nobby2193,

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net, and provide us with a link to your workbook.

 

[nobby2193]

Hi Hiker
Thanks for trying to help but I dont want to set up the box thing and I have failed trying to get screenshots to you ( my error)
Youve spent enough time trying to help and for that i thank you
Probably best if I withdraw the request as I am not experienced enough to even get started

Best regards