Exporting files to specific sheet of different excell file

[Luka_LB]

hi allyour help is needed again I have excel file which makes a report with vba,after report is done I copy reported data to another excell file sheet, if date of operations in report is march 15 I put it in sheet called 0315, if June 5 - in 0605 and so and so.'my question is if it's possible VBA to ask me what date report i'm making and according to it to paste reported data in a different excell file's exact sheet.

 

[Legacy 234512]

1. click on the Sheet1 tab then select View Code
2. paste this code

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim var As String
    If Target.Address = "$A$1" Then var = InputBox("Enter date:")
End Sub

3. this refers to cell A1 - so if you click A1 it will ask for the input/date ( string datatype, so write your own code to handle stream errors )
4. users input is stored in variable called 'var'

 

[hippiehacker]

an elegant form would be a userform with 2 comboboxes for the day and the month then using those values to search through the other workbook if the sheet exist and paste the data.

 

[Luka_LB]

thank you mehowski and hippiehacker
i'll try to use your advices, but with my skills i think i'll need your additional help

i'll post it later.
tnx

 

[Luka_LB]

thank you mehowski and hippiehacker
i'll try to use your advices, but with my skills i think i'll need your additional help

i'll post it later.
tnx