Macro that keeps the existing values and updates the next vacant cell

[Pratap 1987]

Hi,

I have a workbook with 3 Sheets named 'Data', 'Count' and 'Output'.

Sheet1 (Data) - A data from a notepad is copied and pasted to this sheet. And a macro (Named "CountAll") is executed.

Sheet2(Count) - Once the Macro (Named "CountAll") is completed - This sheet reflects the count of Individual items in 'C' Column. And the total count (Master Count) of Column 'C' is reflected in 'D1' Cell.

Sheet 3 (Output) - This sheet contains the individual date (01/03/2011,
01/04/2011 ……… 12/31/2011) of the whole year in Column A. And the Master Count (From D1) cell is updated manually in the B Column (B1, B2 …… B350).

I am looking for a coding that updates the counts automatically in B Column (B1, B2 …… B350) everytime when I ran the first macro (Named "CountAll").

Rules : -

A) First time when I run the First Macro (Named "CountAll") - It should update the value (Master Count) from D1 Cell (Available in Sheet 2 - Count) into the B1 Cell.

B) Second time when I run the First Macro (Named "CountAll") - It should update the value (Master Count) from D1 Cell (Available in Sheet 2 - Count) into the B2 Cell keeping the value in B1 Cell (as the same).

C) The coding should continue update the value from D1 Cell to B Column everytime when I run the macro and should keep the previously available values in b Column.

Please let me know for any additional details.
I would highly appreciate if someone gets me a coding to automate the Manual activity.

Thank you!