copy rows to new sheet and plot graph

Hi,

I have a data set in excel that i want to sort and copy accross to new tabs. I have created an VBA file than searches the columns for a specified value and copy's over the corresponding row. The program then deletes an rows with an empty cell. The VBA program then plots the resulting sorted data. I want to improve my graph quality by using a between function that only plots values between a certain range. Does anyone know how I would get VBA to do this? I assume it would be an IF function. I also want to put a button on the main sheet that if I press will come up with a message asking to enter the number that I want to copy accros to the new sheets and the button then makes a new tab.

At the moment I have code that copy's and deletes blank rows. I made it from adding in other sections of code I found on this forum and it works quite well. Any help would be much appreaciated!

Please Login or Register  to view this content.

before the moderators tell you - just a quick suggestion (okay, actually a forum rule)....you need to put code tags around your code...check the FAQ's on how to do this....technically I'm not supposed to help until you do this....thanks....