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
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.
Sure. Will come up with such a format soon
it was sooo helpful. thank you for teaching step by step. enjoy and did according to your instructions and it is working.
Wow. That's really great to hear that. Keep learning, keep growing 😊😊😊
Thanks for sharing such a nice info
Thank you so much 😊
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 ?
If heads will be missing, it will not pick-up the data in extra columns
Good morning mr. Vijay, you have given a very nice idea and information thanks
That's great to hear that you learnt something new. Thanks for loving the video. Stay connected for such awesome topics 😊😊😊
I have been looking for such things in 2 years thank u so much. Where can i contact u from
You can message me on my Instagram
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
Btw, I never tried it earlier. After your comment, I tried it and it's working 😊
@@Office-Monk thank you so much! This is exactly what I need. New subscriber now
@thezonemtb Thank you so much 😊😊😊
The filter formula is not enabled in my Excel sheet. How do I enable it?
The FILTER function is only available in Microsoft 365 and Excel 2021. The older versions of Excel do not have this function.
In first method if we make new entry then is the new sheet will automatically generated with their name? Or we need to do something else
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
Is it working with diff workbook?
Different workbook means ?
Aap isako hindi me bhi translet kijiye
Office Freak.
Ye mera Hindi Channel hai. Aapko same video Hindi me wahan mil jayega
@@Office-Monk ok