A
Alan T
I'm looking to run a macro from workbook SWT (sheet CLT) which will cu
and paste data from a range of cells (A2,C2,E2,F2,G2,I2,K2..
A3,C3,E3,F3,G3,I3,K3... A4,C4,E4,F4,G4,I4,K4.... until end of data
from workbook SWT (Sheet CS) to rows A to G in Workbook SWTS (Shee
Stats). I have vlookup formulas (eg =IF(B2="","",VLOOKUP($B2,'Data
Field'!$A$7:$B$12,2))) in place in columns A,C,E,F,G,I,K on sheet CS
and I'm looking to keep the these formulas in place (unless someone ca
think of better alternatives). When I paste the data on sheet Stats i
must paste onto the first available free row (must not overwrit
existing rows of data). Once the data is pasted onto workbook SWTS, I'
looking for the workbook to automatically save and then clos
(returning the user to workbook SWT (CLT)).
The other way I can think to try would be to have a macro running o
workbook SWTS which would open workbook SWT, cut the cells from shee
CS and paste them onto workbook SWTS (sheet Stats). The problem I hav
with doing it this way is that I will be running 6 versions of workboo
SWT (all suffixed with users initials eg SWTAT) and I need the dat
from each workbook to be recorded onto workbook SWTS).
Does anyone have any pointers on how I can accomplish what I am lookin
for.
The sheet will be used predominately on Excel 2000, however it may als
be used on a worksatation with Excel 97.
Thank
and paste data from a range of cells (A2,C2,E2,F2,G2,I2,K2..
A3,C3,E3,F3,G3,I3,K3... A4,C4,E4,F4,G4,I4,K4.... until end of data
from workbook SWT (Sheet CS) to rows A to G in Workbook SWTS (Shee
Stats). I have vlookup formulas (eg =IF(B2="","",VLOOKUP($B2,'Data
Field'!$A$7:$B$12,2))) in place in columns A,C,E,F,G,I,K on sheet CS
and I'm looking to keep the these formulas in place (unless someone ca
think of better alternatives). When I paste the data on sheet Stats i
must paste onto the first available free row (must not overwrit
existing rows of data). Once the data is pasted onto workbook SWTS, I'
looking for the workbook to automatically save and then clos
(returning the user to workbook SWT (CLT)).
The other way I can think to try would be to have a macro running o
workbook SWTS which would open workbook SWT, cut the cells from shee
CS and paste them onto workbook SWTS (sheet Stats). The problem I hav
with doing it this way is that I will be running 6 versions of workboo
SWT (all suffixed with users initials eg SWTAT) and I need the dat
from each workbook to be recorded onto workbook SWTS).
Does anyone have any pointers on how I can accomplish what I am lookin
for.
The sheet will be used predominately on Excel 2000, however it may als
be used on a worksatation with Excel 97.
Thank