View Single Post
 
Old 07-11-2020, 11:41 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
do you really need to create different tabs for each month to enter your data?
It would be much simpler to enter your data in one sheet ( with a column for dates) for analysis or detecting duplicate entries.
Pivot Tables with slicers would allow extracting monthly data or whatever needed.
If you wish to keep you actuallayout,to help us help you it would be advisable to post a sample sheet with some data ( mocked up if needed) so we can see your data layout
Reply With Quote