Automatically Transfer Info from one worksheet to another
in [Functions]
|
Prev: Problems entering data in exel spreadsheet
Next: Transfering data from a .pdf file to word and then to excel
From: coriander1209 on 19 Feb 2010 16:05 I have and excel file that has multiple worksheets in it. One of them is a cost and price generator to be able to write up an estimate for a customer and the rest of the worksheets contain all of my materials and prices. Right now I am having to go into each price list and put in how many of each item I want and then copy and paste special onto the first page. Is there a way for this to be automatically done when I enter a quantity? Thanks in advance
From: Gord Dibben on 19 Feb 2010 16:59
Not much for details so cannot tailor anything. VLOOKUP? INDEX,MATCH? Have a look at help Gord Dibben MS Excel MVP On Fri, 19 Feb 2010 13:05:01 -0800, coriander1209 <coriander1209(a)discussions.microsoft.com> wrote: >I have and excel file that has multiple worksheets in it. One of them is a >cost and price generator to be able to write up an estimate for a customer >and the rest of the worksheets contain all of my materials and prices. Right >now I am having to go into each price list and put in how many of each item I >want and then copy and paste special onto the first page. Is there a way for >this to be automatically done when I enter a quantity? >Thanks in advance |