Thank you for watching the video. I appreciate your support and I hope you found it helpful. Please feel free to share your thoughts and feedback in the comments section.
Many many thanks to you for the creating the useful video. This video is very useful to me and others. I hope you create a multi-sheet data calculation and sum calculation formula is easily taken.
Thank You so much, Filter formula seems to be a much easier solution than macros or helper. I had a query. After copying data upto H column in all the sheets, i have 6 more columns which are there in all the other sheets except the main data sheet. There are formulae for each specific sheet. Is it possible that once new data is auto updated in a person's individual sheet, then automatically the formulae in the 6 columns after H column gets copied to the new data's rows ?
In the first method can you choose to add the filters back on the headers and edit in multiple sheets if that information exists in the column? For example: If you had a column named PO number and on that column there was a PO number that was on multiple sheets and you need to edit the date column for that PO number. Could you filter to that specific PO number on the master sheet then edit the date column and have it update on every sheet that PO number on was?
You can apply filters on your master sheet. After applying filters, edit the data, and whatever the editing will be done, it will be visible on specific sheet. Try it once, it works
Really apologize for delay in reply. If we do entry of new person, we will have to create copy of last sheet, change the name from the dropdown and new data is ready
@@Office-Monk so is there anything we can do same on google sheets except import range because it does not bring the same format in the rest of the sheets
Google sheet is bit different from Excel. So what all you do in Excel, can't do in Google Sheets. So you will have to look a way, how to get the desired results on Sheets.