What I am trying to do is create one master spreadsheet. This is the only place where data is entered. I then have 3 other worksheets. (Master, PCIS, Purchase Order, BPA)
I have 5 columns (Date, Price, Service, Purchase Order, BPA).
If Price < $3000 and Contract = "blank" and BPA = "blank"
then copy the whole row to the PCIS worksheet.
I hope this makes sense.
So when they enter each row it can auto populate the other worksheets based on what it entered.
Thanks in advance for your help.
From a data integrity and efficiency standpoint, it doesn't make sense to have the same data on more than one spreadsheet. It would make far more sense to only have one spreadsheet and include a field that you can filter on to get only the records you need. I suggest adding a column into your Master sheet that holds either "PCIS", "Purchase Order", or "BPA". Then when you want to see all items that would have been on the BPA sheet, just filter that new column to only show rows with BPA.
However, if you really want to copy the rows to a new sheet, this code will do it:
I set up a variable to control which row on the Master sheet is checked - you can change it to check a different row.
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks