Copy from one Spreadsheet to existing spreadsheet

V

viewmaster

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy rows from one spreadsheet to another 0
Copy addition formula of non-consecutive horizontal cells 2
Merging from an Excel file with graphics 1
Extracting a cell value 2
Format column widths from one table to a separate table on same page 1
Create if partial match then copy and paste data from one cell to another 1
If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet 1
Somewhat complex code to copy data from one sheet to another 9

Top