I would appreciate help with something I am trying to create
I have a workbook with multiple sheets that break up a list of items into categories.
Each sheet is set up with
column A part number
column B qty
column C description
column D Price
coumn E BxD
some of the items in column be are setup with a =+ or an IF() formula ( I am not sure if this will mater)
I want to set up a system where lets say I put a qty in column B on line 4 on sheet 1, qty of 5 on line 10 on sheet 2 etc
it will copy these automatically to the Master parts list
So on the master parts list I will get a print out of the entire line
of columns a-e and not cause any issues from page to page?
Is this possible to do?
I am using ms office 2007 and I am not a power user.
Thanks for any feedback in advance