Hi all,
I am performing calculations on data in 1000's of workbooks (Files). On top of that I am doing multiple computations (different averages on the same data, say averages using 2, 4, and 8) on data that's in each one. I would like to take that info and place it on another sheet in the same workbook. Can I name the worksheets using a variable name with whatever the average # is that I'm using? I.E. I do a 2 day average for the data, I want to put that onto a worksheet that's named "2 day avg". Is there a way to write a vba line of code that will let me concatenate whatever the average "#" that is used with "day avg."?
Also, does anyone know a VBA line of code that will in effect select a volatile amount of data in a column, copy or cut it and paste it on another worksheet or in another workbook? It's easy to select a cell, hold a mouse button, and drag down to the bottom of the data, but even when I record a macro to see how VBA writes it, I can't figure out how to do it in VBA. In VBA, can this sort of line be written.?
Thanks in advance for everyones help.
Kenman
I am performing calculations on data in 1000's of workbooks (Files). On top of that I am doing multiple computations (different averages on the same data, say averages using 2, 4, and 8) on data that's in each one. I would like to take that info and place it on another sheet in the same workbook. Can I name the worksheets using a variable name with whatever the average # is that I'm using? I.E. I do a 2 day average for the data, I want to put that onto a worksheet that's named "2 day avg". Is there a way to write a vba line of code that will let me concatenate whatever the average "#" that is used with "day avg."?
Also, does anyone know a VBA line of code that will in effect select a volatile amount of data in a column, copy or cut it and paste it on another worksheet or in another workbook? It's easy to select a cell, hold a mouse button, and drag down to the bottom of the data, but even when I record a macro to see how VBA writes it, I can't figure out how to do it in VBA. In VBA, can this sort of line be written.?
Thanks in advance for everyones help.
Kenman