Forum Discussion
Excel help requested
Hi folks
I am new to the forum but have been an Excel user for a good few years.
I would appreciate some advice from experts.
I have a spreadsheet with several worksheets on it. The first being the entries from bank statements.
I would like to have the entries on this sheet automatically added to the respective worksheet as each company my Masonic lodge uses has a separate worksheet. For example gas etc.
I’ve tried to attach the sheet but it doesn’t appear to be possible.
Thank you in advance.
steve
2 Replies
Seems, you need FILTER() function. Read this article from Microsoft. And This article from exceljet.
If you're not able to attach a workbook to your entries in this forum, you could paste a link to the workbook in either a OneDrive or a GoogleDrive location. But you should be able to use the little paper clip icon at the bottom of an entry box, or even just "drag and drop" the file into your forum entry.
