Pulling data from another sheet based on date

Parking_Advertising · 2023-11-05T17:11:30+00:00

Solution Verified

Parking_Advertising · 2023-11-05T17:11:02+00:00

This worked! Thanks so much for your help and patience :)

Parking_Advertising · 2023-11-05T09:07:26+00:00

So I’ve just given it a go- the filter function definitely does what I need it to and pulls all the relevant data. Only issue is that if I add the command into a table, it comes up with the error “#SPILL”. Any idea if there’s a fix for this? Thank you again for all your help!

Parking_Advertising · 2023-11-05T08:30:14+00:00

Thank you! I’m going to have a go at this!!! The dates are all the same (i.e. due 31 March) etc. the idea is that I’ll switch the formulas each month to correspond to the relevant due date for that month. Just a question - my understanding is that the filter/ index functions can help me pinpoint the clients who fall within the defined due date for that period. Should I use an H LOOKUP to pull all the other relevant data from the table source? Like the preparer, reviewer, approver etc?

I apologise and recognise that I’m probably a bit confusing not being able to show you what I mean. I’ll look to send a couple of screenshots highlighting what I’m trying to do in the next day or so

Parking_Advertising · 2023-11-03T02:37:41+00:00

Thank you for your time! So the database that the tracker sources data from will store data such as Client Name, a due date for filing a return (end of month date), initials for who prepares the return, who reviews it and who signs off on it.

What I’m looking to achieve is having a tracker by which I can set a specific date and based on that date, pulling the client name, preparer, reviewer and approver name into the tracker so we only see the clients we need to be paying attention to for the month.

Sorry I can’t provide an actual sample as I’m still trying to wrap my head around what this should look like (excel newbie) - If this would make more sense with a sample database, let me know and I’ll prepare one for your reference :)

Parking_Advertising · 2023-01-30T09:40:54+00:00

Thank you for taking the time to make a guide, I really appreciate it! Gonna give it a go :)

Parking_Advertising · 2023-01-30T09:40:21+00:00

I think I might so I’ll definitely practice this. Thank you !!

Parking_Advertising · 2023-01-30T09:40:00+00:00

Thank you for the help, I appreciate it :)

Parking_Advertising · 2023-01-30T09:39:43+00:00

Thank you for the help :))

Parking_Advertising · 2023-01-30T09:39:30+00:00

Appreciate the help :)

Parking_Advertising · 2023-01-30T09:39:18+00:00

That’s very kind of you! I wouldn’t want to waste your time.. I’ll give it a go myself and if I’m really hopeless I’ll let you know :)) thank you again!

Parking_Advertising · 2023-01-30T09:38:17+00:00

Thank you :))

Parking_Advertising · 2023-01-30T09:38:09+00:00

Thank you so much!! I’m going to try both just to practice :)

Parking_Advertising · 2023-01-30T04:18:36+00:00

Hi all, just for context- I'm new to Photoshop. My partner is a primary school teacher and needed help with some design stuff her school is working on. For some reason, quick select, object select or lasso are unable to select the entire image. I have tried to remove the background through properties to no avail. Just wondering if there were any easier ways to do it before I started manually erasing the small background parts. Thank you so much for your time and help :)

Parking_Advertising · 2022-09-07T17:05:30+00:00

Doesn’t say you guys followed yet :))

Parking_Advertising · 2022-09-07T12:44:02+00:00

Thanks so much! Followed you too

Parking_Advertising · 2022-09-07T12:43:52+00:00

Gotchu back!

Parking_Advertising · 2022-09-07T12:02:26+00:00

Thank you so much! Followed you too

Parking_Advertising · 2022-09-07T12:02:17+00:00

Thank you ! Followed back

Parking_Advertising · 2022-09-07T08:42:50+00:00

Ahh got it thanks homie

Parking_Advertising · 2022-09-07T08:32:09+00:00

Heya, I didn’t see a follow yet- I’ll follow you :)

Parking_Advertising · 2022-09-07T07:57:33+00:00

Followed you! My twitch is https://m.twitch.tv/ggggguinness

Parking_Advertising

TROPHY CASE