Trying to auto sort rows from one tab to another

parcher58

New Member
Joined
Apr 29, 2013
Messages
6
I receive monthly reports that contain aprox. 200 rows of gas sample analysis data and I post it on tab "Mar_Samples-2013". I have another tab called "Historicals" which I update monthly with those analysis. My historical tab is constant however my sample data can be spotty and I'm needing to create a simple way to copy and paste the sample data into a tab which will automatically post the correct rows of the sample data with their matching historical rows.

Example: Tab "Historical A2" is meter ID 7000, but on my sample analysis report, meter ID 7000 may come in on my Tab "Mar_Samples-2013" A10...

Is there a way that my sample tab can read the meter ID and automatically post it in the correct row in my historical tab???

My apologies if I didn't explain this clearly...

Any help will be deeply appreciated!
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,462
Members
414,069
Latest member
StudExcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top