Moving one excel column to new excel column

[Closed]
Report
Posts
1
Registration date
Wednesday April 11, 2012
Status
Member
Last seen
April 11, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am a newbie in excel macro stuff. Would appreciate if someone plz help me to get a routine task automated. Let me explain what actually i am looking here-

I have one excel sheet (Excel1.xls) which contain some macro stuff and when run, generate the output of current free space of some server's drive. For example- there are five column in my excel sheet, Server (column A), Share (column B), free (column C), total (column D) and Used (column E). So every day when I run, this excel sheet output for column C and E may vary .. I'd like to have a new excel sheet (say NewExcel.xls) with same content as Excel1.xls just by adding a new column say "On DATE xx-xx-xx Used Space" (column F) which copy the current data of column E-Used from existing excel (Excel1.xls) to NewExcel.xls column.. By this way, I will be having a historical data of month/year in single excel sheet (NewExcel.xls)


Excel1.xls-

Server Share free(MB) total(MB) Used
server1 e$ 204,927 418529 213,602
server2 f$ 87,266 418529 331,263

Desired output of NewExcel.xls-

Server Share free(MB) total(MB) Used On 11-04-2012 Used Space
server1 e$ 204,927 418529 213,602 213,100
server2 f$ 87,266 418529 331,263 301,263

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Should not the historical data be some thing like this


Date | Server |Share | free(MB) |total(MB) Used