Insert Row and Record in Another Sheet Once I entered date

[atulexel79]

Dear All

I have two sheets one = where I am entering day to day data
two = For getting result

Once I entered data in first sheet then I want date wise record in another sheet
in which I will enter date.
After entering date all the record will be inserted in another sheet from first sheet
And main sheet will remain with all records

Please find attached sheet
and Please help for the same

I am not aware with coding so please attache the file with solution so I can
Understand formula and code

Atul

[xladept]

Hi Atul,

Try this:AtulDClick.xlsm - I added a "Template" sheet and the event is triggered by a double click

[atulexel79]

I could not understood what you want to say
1) I saw If I change Value in Income sheet it dosent change in date wise sheet.
2) If I entered any spesific date in your any shet then also date dosent change
3) I am not able to understand how i can use this for my another File or even for this file when I will increase Date sheet
4) Even you said "event is triggered by a double click" that also I didnt understood

Please explain as if I am not familier with coading
Hope you will help me better.

Atul

[xladept]

Hi Atul,

Enter a record in the "Income" Sheet and double-click that row with the new record and you'll get what you want - I think

[atulexel79]

Ok I Understood

Thanks
But it is inserting rows multiple times which should not insert twice
Even If I chnage Date of Existing file then also it dosent chnage Record

Please help

Atul

[xladept]

I wrote it to handle new data only - if you want to change existing data, then the code will need alteration??

[atulexel79]

Can you please make it for me?

And I need option if I change date
Then Data will be changed as per date

Atul

[xladept]

Hi Atul,

Can you give me an example of what you would enter for the "change date" and what you would expect for the outcome?

[xladept]

Hi Atul,

See if this is what you want:AtulDClick.xlsm

[atulexel79]

Thanks Dude

Now it stops multiple entry for same record

What I want about date change is as follow

In my Output sheet Yellow field is for date entry

When I will put Differant Date in same field
at that time data should come according to entered date
Now you have made differant sheet for differant date

Anyway your these efforts are also appreciable
Thanks

Atul

[xladept]

Attachment 336430

I guess that this is more like what you want?

[atulexel79]

I didnt Understood

What changes you made in sheet

I changed date in Output Sheet
But no changes happend in output

[xladept]

Hi Atul,

Did you enable macros and enable content - it works for me?

[atulexel79]

Yes I have already eneabled it
If you elaborate step by step then I think I will understood

Atul

[xladept]

Hi Atul,

You need only to change the date on the output sheet - you don't need to do anything else, but, if it's not a valid date with data on the input sheet then there will be no result. (I type "7/27" in "B2")

*I was having trouble with the website that day - here's the spreadsheet again:AtuWChange.xlsm

[atulexel79]

Bravo

You are Champ Boss
Three Cheers for you

You have done this as the way I needed


Just One thing I would like to know
This was Sample file which I was provided you

I am not aware with Coading
If I will give you whole sheet
Then can you make it for me ?

Anyway you have done great job
Thanks Dear

Atul

[xladept]

Hi Atul,

Thanks for the rep - I can work with the actual file

[atulexel79]

Thanks

I will given main sheet soon Once I finalize what I want exact

Already Star has Given

Thanks again

Atul