• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hi Chandoo , I am Ramesh from SujathaNagar , I am a MIS Analyst , Need your help

R

rtramesh007

New Member
I download reports daily and save it in a common folder. In that folder i have excel file template with all the dates of the month in a column. I enter the data against each respective date based on the file i download. I want to create a macro or automate which help enter the data automatically once i download and save the report in the common folder. The previous day data should remain there constant and should not change.Infact once new report is downloaded for next day the data should enter automatically against that respective date. Please help.


Thanks n Regards

Ramesh , Sujathanagar , Nr GopalaKrishna Nagar layout , Vizag
 
Hi Istiyak , How do i download the file here , i m trying to see a option here which allows to paste something. Please help


ramesh
 
Hi Ramesh ,


There is nothing specific in this forum for uploading your sample worksheets. You can use any one of the free websites such as skydrive , google docs , rapidshare , hotfile to upload your worksheet , and then post the access link here , so that others can access your worksheet.


Narayan
 
Main file Would look like this

Column A Inbuond Outbound Sales Quality

01-Feb-12 Value

02-Feb-12 Value

03-Feb-12

.

.

.

.

I fill the values in columns B , C etc looking at the file which i download everyday.The download file looks like this

Column A Inbuond Outbound Sales Quality

app1 12 13 8 5

app0 10 12 9 3

app2 5 7 1 4


Total 27 32 18 12


I want the total numbers should be updated in the main file to the respective dates and columns as soon as i download the file. The file name which i download would be like for 1st Feb....1-Feb-12.xls , 2nd Feb....2-Feb-12.xls...


Friends Plz help
 
Hi Ramesh ,


Can you check out the following link ?


https://skydrive.live.com/#!/view.aspx?cid=754467BA13646A3F&resid=754467BA13646A3F%21143


Please do not click on the hyperlink ; copy + paste the entire address in your browser.


Please note that for the formulae to display data , you should have your raw data files "1-Feb-2012.xlsx" ,...


Narayan
 
You must log in or register to reply here.
Back
Top