Beginner help with data linking between sheets - VBA Required?

Well, you obviously have an Excel file, so why don't you attach that rather than pictures of it? We can't try out different formulae in picture files, and most contributors would be reluctant to type out all your data before being able to try different things in Excel.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

This is the excel file with what I've developed so far. It's far from complete and missing a lot of information, yet I'm hoping it will be sufficient as a starting point.

Many thanks for your assistance!

Originally Posted by AliGW

This should get you started:

A5 =IFNA(INDEX(Daily!$A$5:$Z$386,MATCH(Summary!$E$2,Daily!$A$5:$A$386,0),COUNTA($A$4:$A4)*2),"")
B5 =IFNA(INDEX(Daily!$A$5:$Z$386,MATCH(Summary!$E$2,Daily!$A$5:$A$386,0),(COUNTA($A$4:$A4)*2)+1),"")

Copy down.

If you need help understanding the formula so that you can adapt it for other sections of the summary sheet, just shout. Please don't expect anyone to do the whole lot for you, though - I am concerned that this is what you are expecting from the detail in your opening post.

Many thanks for your assistance AliGW!

I've copied and pasted as directed.

A pop-up displays to open a file with the heading "Update Values: Summary". I assume I need to then open up the same file for the update to the "Summary" sheet to come from the "Daily" sheet? If correct, I've done so, selecting the "Daily" sheet in the option provided, which results in "#NAME?". Am I missing something?

To use the formula for other sheets instead of "Daily", I assume I need to substitute the other sheet names and correct changes to column references similar to:

=IFNA(INDEX(Weekly!$B$5:$Z$386,MATCH(Summary!$E$2,Weekly!$B$5:$B$386,0),(COUNTA($B$4:$B4)*2)+1),"")

My understanding of the formula is limited so I'd always appreciate further clarification yet, from what I understand, the formula checks cells whether they have data in them or not, then searches a sheet for the date to match the TODAY date on the Summary page, counts how many empty cells there are and returns a value for the cell reference of the cells which are empty.

While I appreciate all the help I can get, I'm certainly not interested in someone doing all the work for me - all I need is for someone to show/explain to me how to do it for myself. I'd rather learn and understand how to do it and, why it works, rather than simply copy and pasting what someone else has done with no idea about how to do it for myself in the future.

Originally Posted by AliGW

By the way, I really don't think your workbook structure is particularly good or helpful, either in terms of populating your summary sheet or from a user's point of view.

The user input to tick off tasks as completed should, ideally, only be done through the "Summary" page with no need for a user to move to any other tab - i.e. one tab 'shopping' for all of their needs. Given that, while I'm not necessarily adverse to incorporating all the data into one sheet, I thought it might be easier to segregate it into relevant sheets for ease of 'back-end' use.

Any further assistance you can provide would be appreciated!

Originally Posted by AliGW

That's a completely different kettle of fish, then, and makes it all MUCH more complicated. I think you'd need VBA for that, and that's beyond my capabilities - sorry!

I'm off out now - will look in again later.

There's no need to apologise! I appreciate all help and assistance!

Originally Posted by Phreaky

I have thought to use the first sheet as a 'summary' page which lists the task under headings such as "Daily" etc. with the addition of a 'check box' to be used when a task is completed.

Perhaps I should clarify this further...?