GVN KUMAR
Member
Sir,
I am preparing a Master date in sheet "master" it is containing of a financial data projected 5 years (2015 to 2019) vertically mode.
So we are printing purpose (2015 to 2019 ) individually given print out year basis.
So i am copying master file 5 times and using "CTR +ENTER" same data in all sheets, so after i am preparing individually printing purpose sheet rename 2015 to 2019 and vertical to horizontal mode give page setup remaining columns hide every sheet. finally output attached sheet.
it is very long time first time next time any new data and new rows insert in master sheet remaining all sheet also unhide rows and same design pattern change and page setup each sheet.
any master sheet printing purpose separate each year suffering with time waste any solution sir,
2nd doubt in same file
title also formula give it's good due to stand value / title
but ↓ the below line not possible to each sheet separate in each sheet
AUDITED / ESTIMATED / PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 15,16,17,18,19
TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 15
ESTIMATED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 16
PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 17
PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 18
PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 19
AUDITED / ESTIMATED / PROJECTED BALANCE SHEET AS ON 31ST MARCH 2015,16,17,18,19
BALANCE SHEET AS ON 31ST MARCH 2015 IN 2015 SHEET
ESTIMATED BALANCE SHEET AS ON 31ST MARCH 2016 IN 2016 SHEET
PROJECTED BALANCE SHEET AS ON 31ST MARCH 2017 IN 2017 SHEET
PROJECTED BALANCE SHEET AS ON 31ST MARCH 2018 IN 2018 SHEET
PROJECTED BALANCE SHEET AS ON 31ST MARCH 2019 IN 2019 SHEET
same mode in each year sheet same title writing purpose any formula
I am preparing a Master date in sheet "master" it is containing of a financial data projected 5 years (2015 to 2019) vertically mode.
So we are printing purpose (2015 to 2019 ) individually given print out year basis.
So i am copying master file 5 times and using "CTR +ENTER" same data in all sheets, so after i am preparing individually printing purpose sheet rename 2015 to 2019 and vertical to horizontal mode give page setup remaining columns hide every sheet. finally output attached sheet.
it is very long time first time next time any new data and new rows insert in master sheet remaining all sheet also unhide rows and same design pattern change and page setup each sheet.
any master sheet printing purpose separate each year suffering with time waste any solution sir,
2nd doubt in same file
title also formula give it's good due to stand value / title
but ↓ the below line not possible to each sheet separate in each sheet
AUDITED / ESTIMATED / PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 15,16,17,18,19
TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 15
ESTIMATED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 16
PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 17
PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 18
PROJECTED TRADING ACCOUNTS & PROFIT AND LOSS ACCOUNT AS ON 31ST MARCH 19
AUDITED / ESTIMATED / PROJECTED BALANCE SHEET AS ON 31ST MARCH 2015,16,17,18,19
BALANCE SHEET AS ON 31ST MARCH 2015 IN 2015 SHEET
ESTIMATED BALANCE SHEET AS ON 31ST MARCH 2016 IN 2016 SHEET
PROJECTED BALANCE SHEET AS ON 31ST MARCH 2017 IN 2017 SHEET
PROJECTED BALANCE SHEET AS ON 31ST MARCH 2018 IN 2018 SHEET
PROJECTED BALANCE SHEET AS ON 31ST MARCH 2019 IN 2019 SHEET
same mode in each year sheet same title writing purpose any formula
