Sample to Establish Trust (Currency GBP £5)

  • Hi,


    I am looking for someone to help me with VBA, for a price of course.
    Initially I will keep my requests simple and my payment low to establish trust in both direction
    Later the payment offered will reflect the complexity
    I also would like text to explain the VBA embedded in the code so that i can develop my own knowledge
    Question will be mostly relevant to Finance data manipulation and reporting



    Initial question (£5) to kick off and establish trust.


    Background



    • Sheet CCREP is the sheet where the report will be generated, SheetCCList Range (A1:A9) is the sheet where I am storing the range of Cost Centres to be used
    • As Cell 8 is updated on the CCREP sheet it drives a dynamic cost centre report
    • The idea is to create code that runs the Cost centre report for all cost centre and then copies each report to a separate tab.


    Issue I have



    • I have written code using a loop to pick up each cc value, but it only produces one copied sheet
    • What i require is as follows:



    -Explanation of why my code will not work
    -Corrected to my original VBA with explanation



    Code is below:


    Sub Module()


    Call SelectCC
    Call Copysheet



    End Sub




    Sub SelectCC()


    Dim Col As Integer

    For Row = 1 To 9

    Set i = Sheets("CCList").Cells(Row, 1)
    Sheets("CCREP").Range("A8").Value = i


    Next Row



    End Sub



    'Creates a copy of the journal
    Sub Copysheet()
    Dim MyDate As String
    Dim CC As Range


    'Used to create a unique reference
    MyDate = Format(Now, "mm-ss")



    Set CC = Sheets("CCLIST").Range("A8")


    Sheets("CCREP").Copy After:=Sheets("CCREP")
    Sheets("CCREP (2)").Name = CC & " | " & MyDate



    With Sheets(CC & " | " & MyDate)

    .Unprotect
    .Cells.Copy
    .Cells.PasteSpecial xlValues


    End With

    Range("A8").Select
    SendKeys "{ESC}", True
    Sheets("CCREP").Activate


    End Sub


    Summary


    As said this is to establish trust prior to engaging in more detailed applications.
    Key for me is understanding so I grow my knowledge as well as reaching a solution


    lookingfor someone credible to deliver simple and eligant solutions


    Cheers


    Matt (UK)

  • Re: Sample to Establish Trust (Currency GBP £5)


    Hello Matt


    I can take this up for you. Did you pay 10% to Ozgrid please?


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Sample to Establish Trust (Currency GBP £5)


    Will do in a second. I went for a run in between posting and reading this.
    Will confirm when 10% has been transfered.
    Matt

  • Re: Sample to Establish Trust (Currency GBP £5)


    Hi Matt,


    Thanks, I will start working on it.


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Sample to Establish Trust (Currency GBP £5)


    Can you please add an Excel file with your current work, such that I can amend the code and test it on my side ?

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Sample to Establish Trust (Currency GBP £5)


    Thanks, here it is.


    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Sample to Establish Trust (Currency GBP £5)


    Payment received, thanks !

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!