Copy from one Spreadsheet to existing spreadsheet
 

Hi All!

I was having a bit of trouble working out a solution to my problem.
I'll explain what i was hoping to do. I have a spreadsheet
(template.xls) that i want to copy data into from a Excel Web Query
File (which is generated). In the Web Query File the rows and columns
are generated as follows:

A B C ....
1 Name ID Date
2
3
4
5

What i was hoping to do is have the user enter the name (in say an
InputBox) and then have the information for that name in the row get
copied and pasted to the template.xls. The thing is that there will be
multiple rows with the same name, all of which need to be copied to the
template.xls.

The problem also is that the columns in the web query file do not match
exactly to the template. This is how they match up:
Web Query File Template.xls
column D - I goes into column B - G
column J - L goes into column H - J
column M - R goes into column P - U
column S - W goes into column V - Z


I'm pretty new to vba and i wasnt sure how to get this sort of
functionality. Any help would be greatly appreciated. Thanks in
advance!

- Viewmaster


--
viewmaster
------------------------------------------------------------------------
viewmaster's Profile: http://www.excelforum.com/member.php...o&userid=32094
View this thread: http://www.excelforum.com/showthread...hreadid=527921