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

[MrsMrfy]

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]

MrsMrfy schreef:

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

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]

MrsMrfy schreef:









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- Hide quoted text -

- 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.