Auto Add new rows on master sheet as needed

[rjnewsome]

I have a workbook containing two sheets. 1 is my master and is formatted to my liking, the second contains raw data that is pulled from a .csv file.

The data I need populated is from the raw data .csv beginning on row 17. As this data grows I would like it to automatically grow my master sheet begining on row 4.
If possible I'd like the final row to be a total sum of column C. I would also like a daily total in column C for all Dates that match in column A.


Small example would be:

Column A Column B Column C
Date Time Rainfall

Row4 1/22/2013 13:51 0.15 in
1/22/2013 13:52 0.20 in

Daily Total 0.35 in

1/23/2013 08:10 0.01 in
1/23/2013 08:11 0.02 in

Daily Total 0.03 in

Total Rainfall 0.38 in

The date and Time stamp along with the rainfall would be located in the raw data sheet beginning in Row 17.
The master sheet would begin populating on Row 4. Not sure if the calculations would be VBA, Macro, or manually formulated?

Thanks for any and all assistance.

Rob

[rjnewsome]

Here is a manually manipulated version of what I am looking for. The .csv file will be downloaded from a piece of equipment once a week and will be appended to each time. Any number below 100 represents x * 0.01 in. 100 = 1.00 in.

Thanks for any and all assistance.

Rob

[rjnewsome]

I have the insert part down now. Just to get the retain formatting part to work, and the math part.

Here is my code I used:

Please Login or Register  to view this content.

[rjnewsome]

Hello everyone!

I may possibly be going about this the wrong way. But thus far I have it now where it will automatically import the data from my RawData.csv file, It will copy the logical data from the import to the master sheet and will convert the raw data to be displayed as the correct measurement.

Now the data is sorted Chronologically by date, and I need it to total Column C when the Date in Column A is alike. Since it is in chronological order, it can insert the total for that date in the row above the new date. It will need to continue to total by date until the end of data in that range.

Finally I would love a total for the entire reporting period.

Here is the code I have thus far:

Please Login or Register  to view this content.

Thank in advance for any assistance.

~Rob

[abousetta]

Hi Rob,

I have been working on this for the past couple of days when I had time but didn't want to post till I got it working. Have a look at the attachment. It will import the data from the data sheet and calculate the results per day and then the total.

Hope this helps.

abousetta

[rjnewsome]

Hi Rob,

I have been working on this for the past couple of days when I had time but didn't want to post till I got it working. Have a look at the attachment. It will import the data from the data sheet and calculate the results per day and then the total.

Hope this helps.

abousetta

abousetta,

Thank you! Your work was absolutely brilliant! Just what I was looking for.

I can now merge your code and my code together for seamless integration.

Again thanks,

~Rob

[abousetta]

Thanks for the feedback. I was glad to be able to help.

Good luck.

abousetta