Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2008

Tip: Looking for answers? Try searching our database.

How can I fill 2nd worksheet (in different order) with data from 1st     worksheet?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MrsMrfy - 14 Feb 2008 20:07 GMT
Please help.

I have a large amount of data where the 1st worksheet serves as the
basis for the second.  I want to have the second sheet filled
automatically, based on information in the first.  This is my set
up.

        This Sheet is Called Payroll Data
    A    B    C    D    ............    H    I
    Name    Job Description    Status    Reg         RegFB    OT-FB
5    Adams, John    Butcher    FT    $ 36.23         0.4321    0.0974
6    Mason, George    Baker    PT    $ 18.56         0.4367    0.0974
7    Richter, Thomas    CndlestkMkr    T    $ 22.11         0.4021    0.0732
8    Wilson, James    President    FT    $ 66.99         0.5355    0.0974

        This sheet is called FAL - Analysis
    A    B    C    D    .............    AK    AL    AM
9            S            Reg    RegFB    OTFB
10    Name    Adams, John    FT    Reg       $ 10.38     0.2486    0.0973
11    Job Title    Butcher        OT        $      15.57     0.1368    0.0765
12    Name    Mason, George    PT    Reg        $      16.50     0.3339    0.1003
13    Job Title    Baker        OT        $      24.75     0.1366    0.1131
Sybmathics - 14 Feb 2008 20:23 GMT
MrsMrfy schreef:
> Please help.
>
[quoted text clipped - 18 lines]
> 12    Name    Mason, George    PT    Reg        $      16.50     0.3339    0.1003
> 13    Job Title    Baker        OT        $      24.75     0.1366    0.1131

Believe me, this is never what you want to be working with in the future.

1. you will run out of available rows
2. you will run out of available columns

The way you try to set up and gather information will lead to
corruption, with the result that you don't know where to look for repairs.

Don't try to solve this in Excel, you need a relational database like
Access can provide.

Get a training as soon as possible.

greets

Sybolt
MrsMrfy - 14 Feb 2008 21:02 GMT
On Feb 14, 2:23 pm, Sybmathics <startingafterthissybol...@xs4all.nl>
wrote:
> MrsMrfy schreef:
>
[quoted text clipped - 39 lines]
>
> - Show quoted text -

Thanks.  The sample data looks so complicated in this posting but I
thought that it could be solved using arrays.  I just did not know how
to get the arrays to fill in the data on the second sheet.  Maybe this
is beyond Excel capability?  PS  this was accidentally posted.  I'm
new at this.  Sorry.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.