Question description:
This user has given permission to use the problem statement for this
blog.
I am building a spreedsheet and need to pull data from one sheet into another when it meets a certain criteria.
If cell contains £6,000 and is within the next 30 days then pull event name through and date.
At the moment I have three columns, one contains the value (e,g £6,000) another contains dates by day for the next 6 months and the final contains the event name.
Solved by Z. B. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/11/2017 - 03:06
HI, It's pleasure to help you today:)
User
13/11/2017 - 03:06
Hi, thanks :)
Excelchat Expert
13/11/2017 - 03:06
Please share the file or data in the preview
User
13/11/2017 - 03:07
https://docs.google.com/spreadsheets/d/1cqfKBq-yG0e5O7oyi8n8Jxeqv4gNbhUigVUbSEu3Brc/edit?usp=sharing
Excelchat Expert
13/11/2017 - 03:07
Ok. The file is protected and there is no access
Excelchat Expert
13/11/2017 - 03:08
Please change the sharing permissions
User
13/11/2017 - 03:08
One second sorry
Excelchat Expert
13/11/2017 - 03:08
Please upload the file here
Excelchat Expert
13/11/2017 - 03:09
Instead of google sheets. Hope you need the solution in Excel instead of Google sheets?
User
13/11/2017 - 03:09
I need it in Google sheets if possible
User
13/11/2017 - 03:09
https://docs.google.com/spreadsheets/d/1hRKnmyu0HaGk-gNeii08Cdr8Ep7xkqg4vxpMcuV9KWg/edit?usp=sharing
User
13/11/2017 - 03:09
You should be able to access that one
Excelchat Expert
13/11/2017 - 03:09
Ok.
Excelchat Expert
13/11/2017 - 03:09
Please let me know in details w.r.t sheets
Excelchat Expert
13/11/2017 - 03:10
I can see Daily Tracking, and other 2 sheets
User
13/11/2017 - 03:12
Yes, so, you can ignore daily tracking. What I need is sheet "Daily Exposure" column D, if the cell has £6,000 in it, I need the main event name (column C) pulling into the inventory tracker section under key dates available
User
13/11/2017 - 03:12
does that make sense?
User
13/11/2017 - 03:13
I would like it to only pull through if it is within the next 30 days (from today)
User
13/11/2017 - 03:13
I will comment highlight the sheet if that makes sense
Excelchat Expert
13/11/2017 - 03:15
Ok
Excelchat Expert
13/11/2017 - 03:15
Do you want to pull this automatically?
User
13/11/2017 - 03:15
Yes please
Excelchat Expert
13/11/2017 - 03:15
ok
User
13/11/2017 - 03:15
If you can make it update every day, 30 days from the current day it is.
Excelchat Expert
13/11/2017 - 03:16
I am working on it.
User
13/11/2017 - 03:16
Thank you :D
User
13/11/2017 - 03:16
amazing!
Excelchat Expert
13/11/2017 - 03:16
We can use filter option to pull them actually
Excelchat Expert
13/11/2017 - 03:16
I will check the options
User
13/11/2017 - 03:17
Okay
Excelchat Expert
13/11/2017 - 03:26
You are looking only for 30 days from today?
Excelchat Expert
13/11/2017 - 03:27
=filter('Daily Exposure Plan'!C1:C1000,'Daily Exposure Plan'!D1:D1000="£6,000+",'Daily Exposure Plan'!A:A>=Today(),'Daily Exposure Plan'!A:A<Today()+30)
User
13/11/2017 - 03:27
Within the next 30 days
User
13/11/2017 - 03:27
So anything from today up to 30 days
Excelchat Expert
13/11/2017 - 03:28
Ok. It was done.
Excelchat Expert
13/11/2017 - 03:28
Please check
User
13/11/2017 - 03:28
Yes that is amazing, is there anyway I can pull the corresponding date through too?
User
13/11/2017 - 03:29
So Italy Vs Sweden is on 11/13/2017 - it would be good, if possible that these dates are pulled through too
Excelchat Expert
13/11/2017 - 03:30
I have applied it for dates as well
User
13/11/2017 - 03:30
Amazing
User
13/11/2017 - 03:30
you're a life saver!!
User
13/11/2017 - 03:30
Thank you so much
Excelchat Expert
13/11/2017 - 03:31
Great to hear that
Excelchat Expert
13/11/2017 - 03:31
Please visit Got it Pro
Excelchat Expert
13/11/2017 - 03:31
Have a great day ahead:)
User
13/11/2017 - 03:31
Thanks! Will do. You too!
Excelchat Expert
13/11/2017 - 03:31
Please end the session and leave 5-stars
User
13/11/2017 - 03:31
Definitely, thanks!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.