vlookup cant be used

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I need a way to transfer data. I have one sheet that contains all
information. All of this data needs to be transferred to a template ready
for print. I have contemplated using a vlookup to quicken the method,
although the data sheet will be moving too and from computers, and so the
vlookup will not work.
Is there any code that might possibly help me, i.e. a code that looks for
the datasheet and does some sort of vlookup after it has located the file?
Or should this problem be tackled using macros, although i imagine that this
will have the same effect.
 
How "ready for print"? Are you just placing that data somewhere to print,
or using that data to calculate something to print?

I may have another solution for you.

Keith
 
Both, that is i am placing the data somewhere and using that data to
calculate something, then print it to paper. The scenario is that i have a
workbook full of names and numbers, and a template that needs to have one
thing entered into it (i.e. some or name) and it will pop up with the
information in the workbook, the information in the workbook that is
required for that person.
The columns are as follows: name, surname, average work hours, pay rate per
hour, and overtime pay rate.
So when in the template, all i need to be able to do is enter the name of
one person, and it will come up with their surname, average work hours, pay
rate pre hour and overtime pay rate. Then i enter the number of hours they
worked in total, i have worked out a neat little formula that calculates how
much they need to be payed from this. Although one problem. I am required to
use a validation cell in the template, to be able to select the person from
a list. I know how to create a validation cell although i don't know how to
get the information from the other workbook. i was thinking a paste-link
macro of some sort. But i am unaware of any other more efficient ways of
doing this. I have limited knowledge of excel, i know macros and a little
about creating user forms. Hopefully someone has a solution to my
problem....
thanks
mike
 
How about importing data from that worksheet into your calculating one.
Then you have access to it for lookups and validations.
 
Back
Top