x*****o
发帖数: 361 | 1 I need to extract one or two fields(numbers) from a daily Excel report and
then put those selected numbers in another Excel spreadsheet to form several
columns of time series.
I am right now copying and pasting everyday. I heard I can automate this
process using VBA. Never used this before. Anyone may lend me a hand? Just a
VBA sample will be fine.
Thanks a bunch!
Sorry no Chinese input in office. | p********a
发帖数: 5352 | 2 Maybe you don't even need VBA. A few Excel functions will work.
=MID('C:VBA\proj1\[100 West Winds.xls] Year1'!D13,1,2)
MID is just like substr function in SAS, 1 is start point, 2 is number of
characters |
|
