Sort a Master Sheet onto individual sheet

Hello & Welcome to the Forum,

IMO, the way you have the spreadsheet setup now is the way you should keep it, that is with a master sheet.

If you want to look at a particular piece of equipment, why not just apply a filter on the master sheet. This will keep everything in a uniformed database look.

I still think keeping the master sheet intact is the best way to go, then in x amount of years you could run a pivot table and extract the data you need. Any hooo....

Here is an option...

This code is worksheet module code >> right click on the sheet >> view code >> paste on right side of screen

Please Login or Register  to view this content.

In this case you have your master sheet with the code above and two other sheets: Ford F150 and Chevy Silverado

In a column (set up right now for column 1), as soon as you enter either Ford F150 or Chevy Silverado, that entire row will be copied to the sheet bearing its name.

Caution: What if you should change something on the master sheet in a row that has already been copied. The changes will not automatically transfer. If you entered Ford F150 or Chevy Silverado again on that line you updated it would transfer, but now you would have the new line plus the old line. This code looks for the last row and pastes in the next blank row.

If this still does not meet your needs then a workbook with what you have and what you want would help get the right answer for your situation.

Originally Posted by bittu2010

Hi Guys ,

I need a excel sheet where if I click on a single cell value ( Cell A1) in a range then its value should show in a msg box ... please help me

bittu2010,

Please take a minute a read the forum rules about not posting in somebody else's thread. Please start your own.

Hi sns250
How many equipment Id's are you tracking? Only 25 (or so)?

Hi sns250
As I see it we have a couple things going on here. I'd agree with jeffrrybrown's approach

IMO, the way you have the spreadsheet setup now is the way you should keep it, that is with a master sheet.
If you want to look at a particular piece of equipment, why not just apply a filter on the master sheet. This will keep everything in a uniformed database look

Except for this

on those sheets I have some other information on that piece of equipment, such as date purchased, place it was bought, price and some other things

So, whatever we do, it'll take some up front work on your part...such as creating this worksheet

on those sheets I have some other information on that piece of equipment, such as date purchased, place it was bought, price and some other things

In my opinion, how/where these are created depends on how many of these pieces of equipment that will exist. I don't know what the threshold is but let's say it's 25-30...then keep all in one workbook. Assuming it's beyond that...perhaps we should create a new workbook for each piece of equipment.

Just thinking out loud here...

Hi sns250
Why don't you post a workbook that includes your Master and three or four pieces of equipment. The workbook structure should be the same as your actual workbook. I'll see what I can come up with.