How to update daily report in a data base format ?

[rajeshkumarjoshi]

Hi ,

I have a 2 sheets in a workbook by the name Entry and DataStore. I am entering the daily data in Entry sheet and then manually updating the data in DataStore sheet. Is there a macro to automate this.

I have uploaded the sample file with the expected output comments to the below link:

Free large file exchange service without size limits


Thanks in advance.

Thanks
Rajesh

 

[mumps]

Hello. The following code will copy the data for you once you complete the last detail in cell I19. I haven't been able to solve your second and third points but this at least will give you a start. Place the code in the code moduel for worksheet "Entry".

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.ScreenUpdating = False
    If Intersect(Target, Range("I19")) Is Nothing Then Exit Sub
    Dim bottomA As Integer
    bottomA = Sheets("DataStore").Range("A" & Rows.Count).End(xlUp).Row
    If Target.Address = ("$I$19") Then
        Range("E4:E16").Copy
        Sheets("DataStore").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues, Transpose:=True
        Sheets("DataStore").Cells(Rows.Count, "A").End(xlUp).NumberFormat = "dd-mmm-yy"
        Range("E19:I19").Copy Sheets("DataStore").Cells(Rows.Count, "N").End(xlUp).Offset(1, 0)
        Application.CutCopyMode = False
    End If
    Application.ScreenUpdating = True
End Sub

 

[rajeshkumarjoshi]

Thanks mumps, point 3 is optional. I am only concern about point 1 & 2.
hoping some one can help with a complete code.

thanks

 

[mumps]

Hi again. I have been working on your other two points and I think I'm making some progress. The problem I was having was caused by your sheet name "Entry". You had a space at the end of the name which, of course, wasn't visible. This was giving me an error. I'll let you know how things progress.

 

[Ingolf]

Cross post How to update daily log in a another sheet?

 

[rajeshkumarjoshi]

Not sure if this is allowed, but certainly I feel to raise the same question in other forum and i got a very quick response.
Thanks to mumps as well as he is trying to help with all my queries.

 

[mumps]

Hi Rajesh. It sounds like you found a solution in your cross post so I guess you don't need my help any longer.

 

[S M C]

rajesh, cross-posting is like booking a cab from different vendors, and hoping in the first one that arrives! Doesn't work well with the driver / the cab company. The thing about Cross-posting is that developers here are mostly volunteers who take out time from their schedule to help the online community. The reason why forums emphasize on posters informing others that the question was cross-posted, is to ensure that time is not wasted by a developer who is unaware that a solution is already given. So please help the developers help you.

 

[rajeshkumarjoshi]

Hi experts, my apology . I m new to forum and not aware of the rules. I appreciate the help provided by mumps.
I will surly keep this in mind in my next post.

thanks.