is this possible in excel 2007

[Chuck]

I did the layout for our store invoice in excel and I have it set up where
someone just puts in a quantity, a base cost and an item description and
then it calculates total for that item then total for all items in the
column, sales tax and overall invoice total... all extremely basic excel
stuff.

But now one of our vendors has supplied an excel document with a listing of
their products, each row has an item number, description, color and cost for
a new line of product we are going to make available as a custom order. Is
there a way to have a new document with our invoice on sheet 1, the vendor
information on sheet 2 and then on sheet 2 add another column with check
boxes to the vendor's info so that when one is checked it adds the info into
the invoice on sheet 1... then all the person would have to do on sheet 1 is
add quantity information to calculate price and generate an invoice?

If it is, what exactly do I need to Google to learn how to set it up? I've
tried looking around but I don't really know the exact terminology to search
for...

 

[Cimjet]

HI Chuck
Your request could be done with a macro.
Could you upload a sample file to a File sharing web site like Skydrive.com or
http://wikisend.com/ then post a link to your file on this forum.
Cimjet

 

[Chuck]

HI Chuck
Your request could be done with a macro.
Could you upload a sample file to a File sharing web site like
Skydrive.com or http://wikisend.com/ then post a link to your file on this
forum.
Cimjet

Hi Cimjet

Thanks for the offer but I just had a friend point out a slightly different
way for me to approach the problem that would let me do it all by formula
instead of a macro (which I know very little about coding). Granted I'd love
to get a better understanding of how to create macros but I'm under a bit of
a time crunch to get this up and running.

Now if I could just figure out conditional formatting I'd be set!

 

[Cimjet]

Hi Cimjet



Thanks for the offer but I just had a friend point out a slightly different

way for me to approach the problem that would let me do it all by formula

instead of a macro (which I know very little about coding). Granted I'd love

to get a better understanding of how to create macros but I'm under a bit of

a time crunch to get this up and running.



Now if I could just figure out conditional formatting I'd be set!

You're welcome
Good luck
P.S. You know where to come for help.