copy excel spread sheet lines to another

Microsoft Office excel 2007 step by step
November 13, 2010 at 16:23:23
Specs: Windows XP
HI,

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



See More: copy excel spread sheet lines to another

Report •

#1
November 15, 2010 at 17:43:33
re: "some of the items in column be are setup with a =+ or an IF() formula ( I am not sure if this will mater) "

Assuming you mean Column B, not "column be", then I think it will matter because of your next line:

"lets say I put a qty in column B"

If you put a quantity in a cell that currently contains a formula, you are going to overwrite that formula.

As far as the rest of your question, we can't see your workbook from where we're sitting, so we have no idea what your "Master parts list" looks like. Therefore we can't offer any specific advice.

You are going to have to supply some more details before we can offer any help.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question