Home

Move data automatically based on date

%3CLINGO-SUB%20id%3D%22lingo-sub-458615%22%20slang%3D%22en-US%22%3EMove%20data%20automatically%20based%20on%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-458615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20all%2C%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20a%20spreadsheet%20i%20am%20putting%20together%2C%20my%20intention%20is%20that%20data%20is%20inserted%20into%20a%20new%20row%20on%20%22incident%20log%22%20and%20then%20it%20auto%20populates%20the%20relevant%20sheet.%20So%20if%20a%20new%20row%20is%20added%20in%20April%20for%20example%2C%20it%20recognises%20that%20and%20adds%20it%20to%20the%20April%20log%20in%20the%20relevant%20year%3B%20adding%20a%20new%20line%20each%20time.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20am%20doing%20it%20this%20way%20as%20i%20am%20trying%20to%20auto%20pull%20data%20out%20of%20that%20log.%20But%20i%20want%20to%20do%20that%20on%20a%20month%20by%20month%20basis%2C%20so%20how%20my%20incidents%20in%20April%20for%20example%2C%20were%20cuts..%20or%20falls%20from%20height%20etc...%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIf%20i%20can%20get%20the%20incident%20log%20to%20automatically%20spit%20out%20data%20to%20the%20right%20spreadsheet%20i%20can%20pull%20it%20all%20together%20and%20have%20graphs%20etc%3B%20basically%20i%20need%20very%20very%20little%20input%20from%20the%20end%20user%20as%20he%20isn't%20good%20on%20excel%20at%20all.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ESample%20spreadsheet%20attached%2C%20tried%20to%20include%20a%20more%20complete%20copy%20but%20the%20upload%20space%20is%20small%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20would%20appreciate%20any%20help%20that%20could%20be%20offered%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-458615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MrCrypto
Occasional Visitor

Hi all, 

I have a spreadsheet i am putting together, my intention is that data is inserted into a new row on "incident log" and then it auto populates the relevant sheet. So if a new row is added in April for example, it recognises that and adds it to the April log in the relevant year; adding a new line each time. 

I am doing it this way as i am trying to auto pull data out of that log. But i want to do that on a month by month basis, so how my incidents in April for example, were cuts.. or falls from height etc... 

If i can get the incident log to automatically spit out data to the right spreadsheet i can pull it all together and have graphs etc; basically i need very very little input from the end user as he isn't good on excel at all. 

Sample spreadsheet attached, tried to include a more complete copy but the upload space is small

I would appreciate any help that could be offered

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies