Excel 2007

[tyronelife]

Hi there,

I need some help with regards to inserting rows with formulas across sheets....

I have 5 sheets, the 1st one Client List is my main sheet...Then GXC, Domestic, Imports, Exports...

I fill in all new clients on Client List and depending on info i add onto the client decides which sheet the info will go onto..But now i need to add some new clients in so hence i need to insert rows..But now when i insert a row onto the main sheet it does not add it onto the other sheets..? How can i do this?

 

[SkipVought]

Hi,

You have to physically add the data to the other sheets, unless you have a procedure (macro) that does this.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[tyronelife]

Man that sux!

Is there a way to add a macro so it adds in a line where you want it and not where you originally recorded the macro?

Whats this whole thing that you can do in VBE with the start line of SUB etc etc..? Not so sure about VBE but was hunting around and saw a few things on that!

Cheers for the reply!

T

 

[SkipVought]

adds in a line where you

Where do you want to add a line, and exactly what data goes on each sheet, based on the data added to the original sheet?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

It sounds to me like you want to use the Client List sheet to store all clients, and have the next three sheets each report back a subset of the Client List based on different critera.

So basically the Client List sheet is your 'table' and the other three sheets are each reports that you can get by querying the table.

How you go about querying the table will depend on the layout in the Client List and what layout you want for the other sheets.

Please provide a couple of rows of sample data showing what the data looks like in Client List. Be sure to include all columns.

----
Hint: if you wrap the table in [ignore][tt][/tt][/ignore] tgml tags, the data will post lined up in columns like you see when writing the post.

[tab]Example:
Posting this:[tt]
Thing1 Thing2 Thing3
123 456 789[/tt]

will look like this when posted:
Thing1 Thing2 Thing3
123 456 789

But posting this:[tt][!][ignore][tt][/ignore][/!]
Thing1 Thing2 Thing3
123 456 789[!][ignore][/tt][/ignore][/!][/tt]

will look like this when posted:[tt]
Thing1 Thing2 Thing3
123 456 789[/tt]

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.