Hello everyone,
I wanted to know if anyone knew how I could use either VBA or some type of query in order to copy a range of cells. Unfortunately I cannot set ranges in my raw data file because they vary from day to day. I need to pull certain groups of rows based on these containing a certain value. In other words is there a way for excel to scan the entire datasheet & automatically find certain rows that contain say the value"9000" and copy this entire row & paste it into a new sheet. Please let me know. Thanks.
Oz
I wanted to know if anyone knew how I could use either VBA or some type of query in order to copy a range of cells. Unfortunately I cannot set ranges in my raw data file because they vary from day to day. I need to pull certain groups of rows based on these containing a certain value. In other words is there a way for excel to scan the entire datasheet & automatically find certain rows that contain say the value"9000" and copy this entire row & paste it into a new sheet. Please let me know. Thanks.
Oz