Hi;
I reviewed over your posts helping out the gentleman DakotaNJ. I have the
same situation that I have an enormous amount of data I am receiving from
eight sources continually. This means that my data records need to be dynamic
in a sense. I have set up my initial sheet to be just a dynamic receptacle of
info from the other sources. But the other sheets I need to report the data
using the criteria of a certain column as the key.
Example:
I have eight salesmen that fill out reports on the status flow of sales from
the inquiries to open quotations to orders or lost to competition. One column
has that status data in it. The other columns have information on dates,
sales rep., estimator, amounts, notes, customer etc. I would like to set up a
series of sheets with only the data per certain criteria: lets say by
estimator or by status or by sales rep. I would still like the complete row
of information to be included with this sort per sheet.
Matt (my network admin.) and I have been looking at your formula you
proposed for DakotaNJ and have tried to apply it to our work sheets with
little results. We can get one line of data, but it is pointing at the wrong
line of data. Second lines or third lines give a host of errors including
circular errors.
I could enclose the test work book that I am using to give you a first hand
view. I do not see any way to email this to you though.
I have the simple test sheets that I have been describing and there is the
full list by quote sheet that shows what the real information looks like
after it is sorted by Quote number.
Thank you for your help.
John
Sales Manager
RagDyer said:
If I understand what you're looking for, it should be relatively easy and
uncomplicated.
Depending on the configuration of the data on your main sheet, you could use
either a Vlookup() function or an Index & Match combination.
You would fill your "sub" sheets with these functions to pull the data from
the main sheet, where the building ID would be the main criteria determining
which sub sheet would be able to pull the data.
This assumes that one of the fields on the main sheet *does* contain the
individual building ID.
Post back with how your main sheet is set-up, and I'm sure you'll get what
you're looking for.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
DakotaNJ said:
I have a workbook with several tabs. The top tab is the main spreadsheet
were I enter all my gathered data. The other tabs are the same spreadsheet,
the same data, but broken out by specific building.
Right now, I enter the data (alpha and numeric) into the main spreadsheet,
then manually copy/paste it to the respective sub-level spreadsheet.
I can specify the "IF" part of the line item that would identify which sheet
to copy it to, but is it possible to have a "THEN copy and paste [these
cells]" to the other spreadsheets?
Perhaps I am just dreaming here. However, looking through archives I have
found solutions to so many things, and learned so much, I figure what the
heck, I might as well ask!
Thanks for all the great info you folks pass around here. It has helped
make me a "star" employee and allowed me to do some things no one even
thought was possible.