locked
Creating a seperate monthly report from multiple different workbooks with VBA Macro RRS feed

  • Question

  • Hello everybody,

    I have many data in sheet2 there are many dates(f2:f30000)

    how to make reports by month (f2:f30000) from sheet2 to new sheets?

    Please can you help me to get a perfect code for this purpose? I am very new to this macro coding and need support from you.

    and How to create VBA code to auto increment number on A2:A30000 when data has been added without manual typing into form number ?

    this is my file :

    https://onedrive.live.com/redir?resid=81A4FF7ECD34BA8E!107&authkey=!AMDMP_uLHlOh9jA&ithint=file%2czip

    Thank You


    Tuesday, May 26, 2015 7:37 AM

All replies

  • I have many data in sheet2 there are many dates(f2:f30000)

    how to make reports by month (f2:f30000) from sheet2 to new sheets?

    There is no sheet "sheet2" in your file, I guess you mean sheet "Database". But in that sheet column F did not contain any date.

    Please correct your question, or your file.

    Andreas.

    Tuesday, May 26, 2015 8:33 AM
  • Please see this link.

    http://www.rondebruin.nl/win/s3/win006.htm


    Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

    Tuesday, May 26, 2015 7:30 PM
  • I guess "sheet2" is "In", for month data is in column-F in sheet "In" and column-A is blank for auto-number.

    Hi Amek.inf,
    Would you correct your excel file and inform us the further detail of your spec(what to do in your excel file)?
    • Edited by Ashidacchi Wednesday, May 27, 2015 2:39 AM
    Tuesday, May 26, 2015 11:34 PM
  • Sorry All,

    I have correct my question and my file....

    I have data in sheet3(In) there are many dates(f2:f30000)

    how to make reports by month (f2:f30000) from sheet3(In) to new sheets?

    Please can you help me to get a perfect code for this purpose? I am very new to this macro coding and need support from you.

    and How to create VBA code to auto increment number on A2:A30000 when data has been added without manual typing into form number ?

    this is my file :

    https://onedrive.live.com/redir?resid=81A4FF7ECD34BA8E%21115

    Thank You

    Wednesday, May 27, 2015 8:58 AM
  • Hi Amek.inf,

    Your question:
       "how to make reports by month (f2:f30000) from sheet3(In) to new sheets?"
    My question about it:
       I'm sorry I can not understand the meaning of "reports by month".
       Would you show us an image(or sheet) of "report by month"?

    "auto increment number on A2:A30000 when data has been added without manual typing into form number"
       I suppose this may be possible without code.
       Does Worksheet Function(Formula) can do it (using "IF") ? 
     I'm also poor at VBA, and I doubt that VBA can not catch an event of data entered on A2:A30000.
       (by clicking a button, auto numbering on column-A can be done: that is easy)  

    Wednesday, May 27, 2015 10:01 AM
  • Hi,
    Here's a sample of auto number (A2:An) by clicking a button
    # (A2:An) : "n" means that Column-B(n) has data(not blank).

    https://onedrive.live.com/redir?resid=9f7f1739e625ce1c!14758&authkey=!ANFg22v0ZPKvw_A&ithint=file%2cxlsm

    # Please save it on local drive and open it, or edit by Microsoft  Excel(not by Excel Online). 

    sorry my poor English.

    • Edited by Ashidacchi Wednesday, May 27, 2015 10:34 AM
    Wednesday, May 27, 2015 10:24 AM