Data sheet populating into multiple sheets

S

Shaun

I'm looking to build a spreadsheet with one main page that can be populated
with data and automatically pull that data over to other more specific
sheets.

For example, If I have sales on the main sheet and have check boxes for more
specific sales on the same sheet (i.e. liquor sales, food sales etc..) I want
that number to poulate on the specific sales sheet.

I'm assumming I have to wite an IF/Then Statement to say if an "x" is put
into a cell then copy and past the data in the specified cells within that
row and pull that information over to sheet Y.
 
M

Max

One response to your multi-post in .worksheet.functions
(Pl do not multi-post)
---
One option which might prove a close fit here ..

Try this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top.
Ditto for lines with "CA", "NV", etc in their respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the key col value. Eg we first
formulate one child sheet for "NY", dress it up nicely, then just make copies
of the "NY" sheet, and rename these as: CA, NV, SD, etc.

In your case the key col would be the product type, eg: liquor, food, etc
 
S

Sandy Mann

I don't think that is was a question I think that it was spam. From the
website:

EggHeadCafe was founded in 2000 by Microsoft Visual C# MVP's Peter Bromberg
and Robbe Morris. This site is dedicated to providing you with information
on the latest Microsoft .NET technologies.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk


JoAnn Paules said:
Huh?

Perhaps you should visit the website listed below then post again.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




same

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Click to expand...
Click to expand...
 
M

Max

I don't think that is was a question I think that it was spam ...
Perhaps it won't be too long before spam masters the art of masquerading
itself as valid questions in newsgroups with fictitious but realistic
sounding poster names. Maybe it's already happening, who knows <g>.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Sheet populating to multiple sheets 1
Data Population for multiple sheets 1
Excel IF Then Statement 0
Help with drop down selection and populating related data... 9
Copy Data from One sheet to Different Sheets 1
Copy row data from one sheet to one or more sheets depending on numberof tick boxes selected (in the 3
multiple work sheet data to link in one worksheet 6
Macro to Format Multiple Sheets based on "Master" Format 0

Top