thenum1roc
Board Regular
- Joined
- Jun 2, 2002
- Messages
- 77
Hello,
I have a couple of questions. I have all this data for certain products, and I am trying to seperate the products from each other so that I can graph each product versus certain measurements (col C, D, & E). Refer to picture
1) I am trying to seperate some data by what product it is, A, B, C. I have my macro determining where the product changes and the macro is also creating different worksheets for each product. I have been trying to keep track of the change in product by keeping track of the row change with variables. I am doing this so I can go back and copy the specific product information so that I can paste that info on the appropiate sheet. But when I do:
Range(A & CountProductSame, F & CountProductDiff).Select, where CountProductSame and CountProductDiff are integers
it doesn't recognize the syntax. Can I do this and is there a better I can do this?
2) Is there a way to do "undo" in a macro so that I can return to the last cell I was active in, within a specific worksheet? if ou do undo in a macro, it doesn't record wha you prviously did.
3) Is there a way to take Col 2.: For example WW200218 & WW200228 get a difference of 10? I am trying to take the data from the last full eight work weeks as the workweeks are currently formated?
Thank you for your time and hope to hear from you soon.
I have a couple of questions. I have all this data for certain products, and I am trying to seperate the products from each other so that I can graph each product versus certain measurements (col C, D, & E). Refer to picture
1) I am trying to seperate some data by what product it is, A, B, C. I have my macro determining where the product changes and the macro is also creating different worksheets for each product. I have been trying to keep track of the change in product by keeping track of the row change with variables. I am doing this so I can go back and copy the specific product information so that I can paste that info on the appropiate sheet. But when I do:
Range(A & CountProductSame, F & CountProductDiff).Select, where CountProductSame and CountProductDiff are integers
it doesn't recognize the syntax. Can I do this and is there a better I can do this?
2) Is there a way to do "undo" in a macro so that I can return to the last cell I was active in, within a specific worksheet? if ou do undo in a macro, it doesn't record wha you prviously did.
3) Is there a way to take Col 2.: For example WW200218 & WW200228 get a difference of 10? I am trying to take the data from the last full eight work weeks as the workweeks are currently formated?
Thank you for your time and hope to hear from you soon.
