RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
I am using this code to copy a particular range of data and paste it to notepad.
Sub SaveAsMasterXML()
Dim rngData As Range
Dim strData As String
Dim strTempFile As String
Dim x As Long, y As Long
Dim usr As String
Sheets("MasterData").Activate
y = Sheets("MasterData").Range("B2").CurrentRegion.Columns.Count
x = Sheets("MasterData").Range("AA2:A" & Sheets("MasterData").Range("A" & Rows.Count).End(xlUp).Row).Rows.Count
Range("AA2").Resize(x, y).Copy
The problem is that this code is selecting the data from AA2 to AM2 only whereas I want it to select the same number of rows as in B2 data from AA to BX. I would really appreciate if the code is corrected.
Sub SaveAsMasterXML()
Dim rngData As Range
Dim strData As String
Dim strTempFile As String
Dim x As Long, y As Long
Dim usr As String
Sheets("MasterData").Activate
y = Sheets("MasterData").Range("B2").CurrentRegion.Columns.Count
x = Sheets("MasterData").Range("AA2:A" & Sheets("MasterData").Range("A" & Rows.Count).End(xlUp).Row).Rows.Count
Range("AA2").Resize(x, y).Copy
The problem is that this code is selecting the data from AA2 to AM2 only whereas I want it to select the same number of rows as in B2 data from AA to BX. I would really appreciate if the code is corrected.
| query to resize cells.xlsx | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | BW | BX | ||||||||||||||||
| 1 | ALIAS | PARTY LEDGER NAME | PARENT GROUP | GSTIN NO. | REGISTRATION TYPE | ADDRESS 1 (Bldg / No) | ADDRESS (Road / Street) | ADDRESS (Area) | ADDRESS (City) | STATE | PINCODE | OPENING BALANCE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2 | cc | Cash & Carry | Sundry Debtors | 29xxx1111x29 | Regular | # 005 | ITI Layout | BSK 3rd Stage | Bangalore | Karnataka | 560085 | 12345.00 | <ENVELOPE> | <HEADER> | <TALLYREQUEST>Import Data</TALLYREQUEST> | </HEADER> | <BODY> | <IMPORTDATA> | <REQUESTDESC> | <REPORTNAME>All Masters</REPORTNAME> | <STATICVARIABLES> | <SVCURRENTCOMPANY></SVCURRENTCOMPANY> | </STATICVARIABLES> | </REQUESTDESC> | <REQUESTDATA> | <TALLYMESSAGE xmlns:UDF="TallyUDF"><LEDGER NAME=" | Cash & Carry | " RESERVEDNAME=""><ADDRESS.LIST TYPE="String"><ADDRESS> | # 005 | </ADDRESS><ADDRESS> | ITI Layout | </ADDRESS><ADDRESS> | BSK 3rd Stage | </ADDRESS><ADDRESS> | Bangalore | </ADDRESS></ADDRESS.LIST><MAILINGNAME.LIST TYPE="String"><MAILINGNAME> | Cash & Carry | </MAILINGNAME></MAILINGNAME.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><GUID></GUID><CURRENCYNAME>₹</CURRENCYNAME><PINCODE> | 560085 | </PINCODE><COUNTRYNAME>India</COUNTRYNAME><GSTREGISTRATIONTYPE> | Regular | </GSTREGISTRATIONTYPE><VATDEALERTYPE> | Regular | </VATDEALERTYPE><PARENT> | Sundry Debtors | </PARENT><TAXCLASSIFICATIONNAME/><TAXTYPE>Others</TAXTYPE><COUNTRYOFRESIDENCE>India</COUNTRYOFRESIDENCE><GSTTYPE/><APPROPRIATEFOR/><PARTYGSTIN> | 29xxx1111x29 | </PARTYGSTIN><GSTNATUREOFSUPPLY/><SERVICECATEGORY></SERVICECATEGORY><EXCISELEDGERCLASSIFICATION/><EXCISEDUTYTYPE/><EXCISENATUREOFPURCHASE/><LEDGERFBTCATEGORY/><LEDSTATENAME> | Karnataka | </LEDSTATENAME><ISBILLWISEON> | Yes | </ISBILLWISEON><ISCOSTCENTRESON>No</ISCOSTCENTRESON><ISINTERESTON>No</ISINTERESTON><ALLOWINMOBILE>No</ALLOWINMOBILE><ISCOSTTRACKINGON>No</ISCOSTTRACKINGON><ISBENEFICIARYCODEON>No</ISBENEFICIARYCODEON><ISUPDATINGTARGETID>No</ISUPDATINGTARGETID><ASORIGINAL>Yes</ASORIGINAL><ISCONDENSED>No</ISCONDENSED><AFFECTSSTOCK>No</AFFECTSSTOCK><ISRATEINCLUSIVEVAT>No</ISRATEINCLUSIVEVAT><FORPAYROLL>No</FORPAYROLL><ISABCENABLED>No</ISABCENABLED><ISCREDITDAYSCHKON>No</ISCREDITDAYSCHKON><INTERESTONBILLWISE>No</INTERESTONBILLWISE><OVERRIDEINTEREST>No</OVERRIDEINTEREST><OVERRIDEADVINTEREST>No</OVERRIDEADVINTEREST><USEFORVAT>No</USEFORVAT><IGNORETDSEXEMPT>No</IGNORETDSEXEMPT><ISTCSAPPLICABLE>No</ISTCSAPPLICABLE><ISTDSAPPLICABLE>No</ISTDSAPPLICABLE><ISFBTAPPLICABLE>No</ISFBTAPPLICABLE><ISGSTAPPLICABLE>No</ISGSTAPPLICABLE><ISEXCISEAPPLICABLE>No</ISEXCISEAPPLICABLE><ISTDSEXPENSE>No</ISTDSEXPENSE><ISEDLIAPPLICABLE>No</ISEDLIAPPLICABLE><ISRELATEDPARTY>No</ISRELATEDPARTY><USEFORESIELIGIBILITY>No</USEFORESIELIGIBILITY><ISINTERESTINCLLASTDAY>No</ISINTERESTINCLLASTDAY><APPROPRIATETAXVALUE>No</APPROPRIATETAXVALUE><ISBEHAVEASDUTY>No</ISBEHAVEASDUTY><INTERESTINCLDAYOFADDITION>No</INTERESTINCLDAYOFADDITION><INTERESTINCLDAYOFDEDUCTION>No</INTERESTINCLDAYOFDEDUCTION><ISOTHTERRITORYASSESSEE>No</ISOTHTERRITORYASSESSEE><OVERRIDECREDITLIMIT>No</OVERRIDECREDITLIMIT><ISAGAINSTFORMC>No</ISAGAINSTFORMC><ISCHEQUEPRINTINGENABLED>Yes</ISCHEQUEPRINTINGENABLED><ISPAYUPLOAD>No</ISPAYUPLOAD><ISPAYBATCHONLYSAL>No</ISPAYBATCHONLYSAL><ISBNFCODESUPPORTED>No</ISBNFCODESUPPORTED><ALLOWEXPORTWITHERRORS>No</ALLOWEXPORTWITHERRORS><CONSIDERPURCHASEFOREXPORT>No</CONSIDERPURCHASEFOREXPORT><ISTRANSPORTER>No</ISTRANSPORTER><USEFORNOTIONALITC>No</USEFORNOTIONALITC><ISECOMMOPERATOR>No</ISECOMMOPERATOR><SHOWINPAYSLIP>No</SHOWINPAYSLIP><USEFORGRATUITY>No</USEFORGRATUITY><ISTDSPROJECTED>No</ISTDSPROJECTED><FORSERVICETAX>No</FORSERVICETAX><ISINPUTCREDIT>No</ISINPUTCREDIT><ISEXEMPTED>No</ISEXEMPTED><ISABATEMENTAPPLICABLE>No</ISABATEMENTAPPLICABLE><ISSTXPARTY>No</ISSTXPARTY><ISSTXNONREALIZEDTYPE>No</ISSTXNONREALIZEDTYPE><ISUSEDFORCVD>No</ISUSEDFORCVD><LEDBELONGSTONONTAXABLE>No</LEDBELONGSTONONTAXABLE><ISEXCISEMERCHANTEXPORTER>No</ISEXCISEMERCHANTEXPORTER><ISPARTYEXEMPTED>No</ISPARTYEXEMPTED><ISSEZPARTY>No</ISSEZPARTY><TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE><ISECHEQUESUPPORTED>No</ISECHEQUESUPPORTED><ISEDDSUPPORTED>No</ISEDDSUPPORTED><HASECHEQUEDELIVERYMODE>No</HASECHEQUEDELIVERYMODE><HASECHEQUEDELIVERYTO>No</HASECHEQUEDELIVERYTO><HASECHEQUEPRINTLOCATION>No</HASECHEQUEPRINTLOCATION><HASECHEQUEPAYABLELOCATION>No</HASECHEQUEPAYABLELOCATION><HASECHEQUEBANKLOCATION>No</HASECHEQUEBANKLOCATION><HASEDDDELIVERYMODE>No</HASEDDDELIVERYMODE><HASEDDDELIVERYTO>No</HASEDDDELIVERYTO><HASEDDPRINTLOCATION>No</HASEDDPRINTLOCATION><HASEDDPAYABLELOCATION>No</HASEDDPAYABLELOCATION><HASEDDBANKLOCATION>No</HASEDDBANKLOCATION><ISEBANKINGENABLED>No</ISEBANKINGENABLED><ISEXPORTFILEENCRYPTED>No</ISEXPORTFILEENCRYPTED><ISBATCHENABLED>No</ISBATCHENABLED><ISPRODUCTCODEBASED>No</ISPRODUCTCODEBASED><HASEDDCITY>No</HASEDDCITY><HASECHEQUECITY>No</HASECHEQUECITY><ISFILENAMEFORMATSUPPORTED>No</ISFILENAMEFORMATSUPPORTED><HASCLIENTCODE>No</HASCLIENTCODE><PAYINSISBATCHAPPLICABLE>No</PAYINSISBATCHAPPLICABLE><PAYINSISFILENUMAPP>No</PAYINSISFILENUMAPP><ISSALARYTRANSGROUPEDFORBRS>No</ISSALARYTRANSGROUPEDFORBRS><ISEBANKINGSUPPORTED>No</ISEBANKINGSUPPORTED><ISSCBUAE>No</ISSCBUAE><ISBANKSTATUSAPP>No</ISBANKSTATUSAPP><ISSALARYGROUPED>No</ISSALARYGROUPED><USEFORPURCHASETAX>No</USEFORPURCHASETAX><AUDITED>No</AUDITED><SORTPOSITION> 1000</SORTPOSITION><ALTERID> 168</ALTERID><OPENINGBALANCE> | 12345.00 | </OPENINGBALANCE><SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST><LBTREGNDETAILS.LIST> </LBTREGNDETAILS.LIST><VATDETAILS.LIST> </VATDETAILS.LIST><SALESTAXCESSDETAILS.LIST> </SALESTAXCESSDETAILS.LIST><GSTDETAILS.LIST> </GSTDETAILS.LIST><LANGUAGENAME.LIST><NAME.LIST TYPE="String"><NAME> | Cash & Carry | </NAME><NAME> | cc | </NAME></NAME.LIST><LANGUAGEID> 1033</LANGUAGEID></LANGUAGENAME.LIST><XBRLDETAIL.LIST> </XBRLDETAIL.LIST><AUDITDETAILS.LIST> </AUDITDETAILS.LIST><SCHVIDETAILS.LIST> </SCHVIDETAILS.LIST><EXCISETARIFFDETAILS.LIST> </EXCISETARIFFDETAILS.LIST><TCSCATEGORYDETAILS.LIST> </TCSCATEGORYDETAILS.LIST><TDSCATEGORYDETAILS.LIST> </TDSCATEGORYDETAILS.LIST><SLABPERIOD.LIST> </SLABPERIOD.LIST><GRATUITYPERIOD.LIST> </GRATUITYPERIOD.LIST><ADDITIONALCOMPUTATIONS.LIST> </ADDITIONALCOMPUTATIONS.LIST><EXCISEJURISDICTIONDETAILS.LIST> </EXCISEJURISDICTIONDETAILS.LIST><EXCLUDEDTAXATIONS.LIST> </EXCLUDEDTAXATIONS.LIST><BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST><PAYMENTDETAILS.LIST> </PAYMENTDETAILS.LIST><BANKEXPORTFORMATS.LIST> </BANKEXPORTFORMATS.LIST><BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST><LEDGERCLOSINGVALUES.LIST> </LEDGERCLOSINGVALUES.LIST><LEDGERAUDITCLASS.LIST> </LEDGERAUDITCLASS.LIST><OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST><TDSEXEMPTIONRULES.LIST> </TDSEXEMPTIONRULES.LIST><DEDUCTINSAMEVCHRULES.LIST> </DEDUCTINSAMEVCHRULES.LIST><LOWERDEDUCTION.LIST> </LOWERDEDUCTION.LIST><STXABATEMENTDETAILS.LIST> </STXABATEMENTDETAILS.LIST><LEDMULTIADDRESSLIST.LIST> </LEDMULTIADDRESSLIST.LIST><STXTAXDETAILS.LIST> </STXTAXDETAILS.LIST><CHEQUERANGE.LIST> </CHEQUERANGE.LIST><DEFAULTVCHCHEQUEDETAILS.LIST> </DEFAULTVCHCHEQUEDETAILS.LIST><ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST> </AUDITENTRIES.LIST><BRSIMPORTEDINFO.LIST> </BRSIMPORTEDINFO.LIST><AUTOBRSCONFIGS.LIST> </AUTOBRSCONFIGS.LIST><BANKURENTRIES.LIST> </BANKURENTRIES.LIST><DEFAULTCHEQUEDETAILS.LIST> </DEFAULTCHEQUEDETAILS.LIST><DEFAULTOPENINGCHEQUEDETAILS.LIST> </DEFAULTOPENINGCHEQUEDETAILS.LIST><CANCELLEDPAYALLOCATIONS.LIST> </CANCELLEDPAYALLOCATIONS.LIST><ECHEQUEPRINTLOCATION.LIST> </ECHEQUEPRINTLOCATION.LIST><ECHEQUEPAYABLELOCATION.LIST> </ECHEQUEPAYABLELOCATION.LIST><EDDPRINTLOCATION.LIST> </EDDPRINTLOCATION.LIST><EDDPAYABLELOCATION.LIST> </EDDPAYABLELOCATION.LIST><AVAILABLETRANSACTIONTYPES.LIST> </AVAILABLETRANSACTIONTYPES.LIST><LEDPAYINSCONFIGS.LIST> </LEDPAYINSCONFIGS.LIST><TYPECODEDETAILS.LIST> </TYPECODEDETAILS.LIST><FIELDVALIDATIONDETAILS.LIST> </FIELDVALIDATIONDETAILS.LIST><INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST><GSTCLASSFNIGSTRATES.LIST> </GSTCLASSFNIGSTRATES.LIST><EXTARIFFDUTYHEADDETAILS.LIST> </EXTARIFFDUTYHEADDETAILS.LIST><VOUCHERTYPEPRODUCTCODES.LIST> </VOUCHERTYPEPRODUCTCODES.LIST></LEDGER></TALLYMESSAGE> | </REQUESTDATA> | </IMPORTDATA> | </BODY> | </ENVELOPE> | ||||||||||||||||
| 3 | Rajesh Capital A/c | Capital Account | 13345.00 | <ENVELOPE> | <HEADER> | <TALLYREQUEST>Import Data</TALLYREQUEST> | </HEADER> | <BODY> | <IMPORTDATA> | <REQUESTDESC> | <REPORTNAME>All Masters</REPORTNAME> | <STATICVARIABLES> | <SVCURRENTCOMPANY></SVCURRENTCOMPANY> | </STATICVARIABLES> | </REQUESTDESC> | <REQUESTDATA> | <TALLYMESSAGE xmlns:UDF="TallyUDF"><LEDGER NAME=" | Rajesh Capital A/c | " RESERVEDNAME=""><ADDRESS.LIST TYPE="String"><ADDRESS> | 0 | </ADDRESS><ADDRESS> | 0 | </ADDRESS><ADDRESS> | 0 | </ADDRESS><ADDRESS> | 0 | </ADDRESS></ADDRESS.LIST><MAILINGNAME.LIST TYPE="String"><MAILINGNAME> | Rajesh Capital A/c | </MAILINGNAME></MAILINGNAME.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><GUID></GUID><CURRENCYNAME>₹</CURRENCYNAME><PINCODE> | 0 | </PINCODE><COUNTRYNAME>India</COUNTRYNAME><GSTREGISTRATIONTYPE> | 0 | </GSTREGISTRATIONTYPE><VATDEALERTYPE> | 0 | </VATDEALERTYPE><PARENT> | Capital Account | </PARENT><TAXCLASSIFICATIONNAME/><TAXTYPE>Others</TAXTYPE><COUNTRYOFRESIDENCE>India</COUNTRYOFRESIDENCE><GSTTYPE/><APPROPRIATEFOR/><PARTYGSTIN> | 0 | </PARTYGSTIN><GSTNATUREOFSUPPLY/><SERVICECATEGORY></SERVICECATEGORY><EXCISELEDGERCLASSIFICATION/><EXCISEDUTYTYPE/><EXCISENATUREOFPURCHASE/><LEDGERFBTCATEGORY/><LEDSTATENAME> | 0 | </LEDSTATENAME><ISBILLWISEON> | Yes | </ISBILLWISEON><ISCOSTCENTRESON>No</ISCOSTCENTRESON><ISINTERESTON>No</ISINTERESTON><ALLOWINMOBILE>No</ALLOWINMOBILE><ISCOSTTRACKINGON>No</ISCOSTTRACKINGON><ISBENEFICIARYCODEON>No</ISBENEFICIARYCODEON><ISUPDATINGTARGETID>No</ISUPDATINGTARGETID><ASORIGINAL>Yes</ASORIGINAL><ISCONDENSED>No</ISCONDENSED><AFFECTSSTOCK>No</AFFECTSSTOCK><ISRATEINCLUSIVEVAT>No</ISRATEINCLUSIVEVAT><FORPAYROLL>No</FORPAYROLL><ISABCENABLED>No</ISABCENABLED><ISCREDITDAYSCHKON>No</ISCREDITDAYSCHKON><INTERESTONBILLWISE>No</INTERESTONBILLWISE><OVERRIDEINTEREST>No</OVERRIDEINTEREST><OVERRIDEADVINTEREST>No</OVERRIDEADVINTEREST><USEFORVAT>No</USEFORVAT><IGNORETDSEXEMPT>No</IGNORETDSEXEMPT><ISTCSAPPLICABLE>No</ISTCSAPPLICABLE><ISTDSAPPLICABLE>No</ISTDSAPPLICABLE><ISFBTAPPLICABLE>No</ISFBTAPPLICABLE><ISGSTAPPLICABLE>No</ISGSTAPPLICABLE><ISEXCISEAPPLICABLE>No</ISEXCISEAPPLICABLE><ISTDSEXPENSE>No</ISTDSEXPENSE><ISEDLIAPPLICABLE>No</ISEDLIAPPLICABLE><ISRELATEDPARTY>No</ISRELATEDPARTY><USEFORESIELIGIBILITY>No</USEFORESIELIGIBILITY><ISINTERESTINCLLASTDAY>No</ISINTERESTINCLLASTDAY><APPROPRIATETAXVALUE>No</APPROPRIATETAXVALUE><ISBEHAVEASDUTY>No</ISBEHAVEASDUTY><INTERESTINCLDAYOFADDITION>No</INTERESTINCLDAYOFADDITION><INTERESTINCLDAYOFDEDUCTION>No</INTERESTINCLDAYOFDEDUCTION><ISOTHTERRITORYASSESSEE>No</ISOTHTERRITORYASSESSEE><OVERRIDECREDITLIMIT>No</OVERRIDECREDITLIMIT><ISAGAINSTFORMC>No</ISAGAINSTFORMC><ISCHEQUEPRINTINGENABLED>Yes</ISCHEQUEPRINTINGENABLED><ISPAYUPLOAD>No</ISPAYUPLOAD><ISPAYBATCHONLYSAL>No</ISPAYBATCHONLYSAL><ISBNFCODESUPPORTED>No</ISBNFCODESUPPORTED><ALLOWEXPORTWITHERRORS>No</ALLOWEXPORTWITHERRORS><CONSIDERPURCHASEFOREXPORT>No</CONSIDERPURCHASEFOREXPORT><ISTRANSPORTER>No</ISTRANSPORTER><USEFORNOTIONALITC>No</USEFORNOTIONALITC><ISECOMMOPERATOR>No</ISECOMMOPERATOR><SHOWINPAYSLIP>No</SHOWINPAYSLIP><USEFORGRATUITY>No</USEFORGRATUITY><ISTDSPROJECTED>No</ISTDSPROJECTED><FORSERVICETAX>No</FORSERVICETAX><ISINPUTCREDIT>No</ISINPUTCREDIT><ISEXEMPTED>No</ISEXEMPTED><ISABATEMENTAPPLICABLE>No</ISABATEMENTAPPLICABLE><ISSTXPARTY>No</ISSTXPARTY><ISSTXNONREALIZEDTYPE>No</ISSTXNONREALIZEDTYPE><ISUSEDFORCVD>No</ISUSEDFORCVD><LEDBELONGSTONONTAXABLE>No</LEDBELONGSTONONTAXABLE><ISEXCISEMERCHANTEXPORTER>No</ISEXCISEMERCHANTEXPORTER><ISPARTYEXEMPTED>No</ISPARTYEXEMPTED><ISSEZPARTY>No</ISSEZPARTY><TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE><ISECHEQUESUPPORTED>No</ISECHEQUESUPPORTED><ISEDDSUPPORTED>No</ISEDDSUPPORTED><HASECHEQUEDELIVERYMODE>No</HASECHEQUEDELIVERYMODE><HASECHEQUEDELIVERYTO>No</HASECHEQUEDELIVERYTO><HASECHEQUEPRINTLOCATION>No</HASECHEQUEPRINTLOCATION><HASECHEQUEPAYABLELOCATION>No</HASECHEQUEPAYABLELOCATION><HASECHEQUEBANKLOCATION>No</HASECHEQUEBANKLOCATION><HASEDDDELIVERYMODE>No</HASEDDDELIVERYMODE><HASEDDDELIVERYTO>No</HASEDDDELIVERYTO><HASEDDPRINTLOCATION>No</HASEDDPRINTLOCATION><HASEDDPAYABLELOCATION>No</HASEDDPAYABLELOCATION><HASEDDBANKLOCATION>No</HASEDDBANKLOCATION><ISEBANKINGENABLED>No</ISEBANKINGENABLED><ISEXPORTFILEENCRYPTED>No</ISEXPORTFILEENCRYPTED><ISBATCHENABLED>No</ISBATCHENABLED><ISPRODUCTCODEBASED>No</ISPRODUCTCODEBASED><HASEDDCITY>No</HASEDDCITY><HASECHEQUECITY>No</HASECHEQUECITY><ISFILENAMEFORMATSUPPORTED>No</ISFILENAMEFORMATSUPPORTED><HASCLIENTCODE>No</HASCLIENTCODE><PAYINSISBATCHAPPLICABLE>No</PAYINSISBATCHAPPLICABLE><PAYINSISFILENUMAPP>No</PAYINSISFILENUMAPP><ISSALARYTRANSGROUPEDFORBRS>No</ISSALARYTRANSGROUPEDFORBRS><ISEBANKINGSUPPORTED>No</ISEBANKINGSUPPORTED><ISSCBUAE>No</ISSCBUAE><ISBANKSTATUSAPP>No</ISBANKSTATUSAPP><ISSALARYGROUPED>No</ISSALARYGROUPED><USEFORPURCHASETAX>No</USEFORPURCHASETAX><AUDITED>No</AUDITED><SORTPOSITION> 1000</SORTPOSITION><ALTERID> 168</ALTERID><OPENINGBALANCE> | 13345.00 | </OPENINGBALANCE><SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST><LBTREGNDETAILS.LIST> </LBTREGNDETAILS.LIST><VATDETAILS.LIST> </VATDETAILS.LIST><SALESTAXCESSDETAILS.LIST> </SALESTAXCESSDETAILS.LIST><GSTDETAILS.LIST> </GSTDETAILS.LIST><LANGUAGENAME.LIST><NAME.LIST TYPE="String"><NAME> | Rajesh Capital A/c | </NAME><NAME> | 0 | </NAME></NAME.LIST><LANGUAGEID> 1033</LANGUAGEID></LANGUAGENAME.LIST><XBRLDETAIL.LIST> </XBRLDETAIL.LIST><AUDITDETAILS.LIST> </AUDITDETAILS.LIST><SCHVIDETAILS.LIST> </SCHVIDETAILS.LIST><EXCISETARIFFDETAILS.LIST> </EXCISETARIFFDETAILS.LIST><TCSCATEGORYDETAILS.LIST> </TCSCATEGORYDETAILS.LIST><TDSCATEGORYDETAILS.LIST> </TDSCATEGORYDETAILS.LIST><SLABPERIOD.LIST> </SLABPERIOD.LIST><GRATUITYPERIOD.LIST> </GRATUITYPERIOD.LIST><ADDITIONALCOMPUTATIONS.LIST> </ADDITIONALCOMPUTATIONS.LIST><EXCISEJURISDICTIONDETAILS.LIST> </EXCISEJURISDICTIONDETAILS.LIST><EXCLUDEDTAXATIONS.LIST> </EXCLUDEDTAXATIONS.LIST><BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST><PAYMENTDETAILS.LIST> </PAYMENTDETAILS.LIST><BANKEXPORTFORMATS.LIST> </BANKEXPORTFORMATS.LIST><BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST><LEDGERCLOSINGVALUES.LIST> </LEDGERCLOSINGVALUES.LIST><LEDGERAUDITCLASS.LIST> </LEDGERAUDITCLASS.LIST><OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST><TDSEXEMPTIONRULES.LIST> </TDSEXEMPTIONRULES.LIST><DEDUCTINSAMEVCHRULES.LIST> </DEDUCTINSAMEVCHRULES.LIST><LOWERDEDUCTION.LIST> </LOWERDEDUCTION.LIST><STXABATEMENTDETAILS.LIST> </STXABATEMENTDETAILS.LIST><LEDMULTIADDRESSLIST.LIST> </LEDMULTIADDRESSLIST.LIST><STXTAXDETAILS.LIST> </STXTAXDETAILS.LIST><CHEQUERANGE.LIST> </CHEQUERANGE.LIST><DEFAULTVCHCHEQUEDETAILS.LIST> </DEFAULTVCHCHEQUEDETAILS.LIST><ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST> </AUDITENTRIES.LIST><BRSIMPORTEDINFO.LIST> </BRSIMPORTEDINFO.LIST><AUTOBRSCONFIGS.LIST> </AUTOBRSCONFIGS.LIST><BANKURENTRIES.LIST> </BANKURENTRIES.LIST><DEFAULTCHEQUEDETAILS.LIST> </DEFAULTCHEQUEDETAILS.LIST><DEFAULTOPENINGCHEQUEDETAILS.LIST> </DEFAULTOPENINGCHEQUEDETAILS.LIST><CANCELLEDPAYALLOCATIONS.LIST> </CANCELLEDPAYALLOCATIONS.LIST><ECHEQUEPRINTLOCATION.LIST> </ECHEQUEPRINTLOCATION.LIST><ECHEQUEPAYABLELOCATION.LIST> </ECHEQUEPAYABLELOCATION.LIST><EDDPRINTLOCATION.LIST> </EDDPRINTLOCATION.LIST><EDDPAYABLELOCATION.LIST> </EDDPAYABLELOCATION.LIST><AVAILABLETRANSACTIONTYPES.LIST> </AVAILABLETRANSACTIONTYPES.LIST><LEDPAYINSCONFIGS.LIST> </LEDPAYINSCONFIGS.LIST><TYPECODEDETAILS.LIST> </TYPECODEDETAILS.LIST><FIELDVALIDATIONDETAILS.LIST> </FIELDVALIDATIONDETAILS.LIST><INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST><GSTCLASSFNIGSTRATES.LIST> </GSTCLASSFNIGSTRATES.LIST><EXTARIFFDUTYHEADDETAILS.LIST> </EXTARIFFDUTYHEADDETAILS.LIST><VOUCHERTYPEPRODUCTCODES.LIST> </VOUCHERTYPEPRODUCTCODES.LIST></LEDGER></TALLYMESSAGE> | </REQUESTDATA> | </IMPORTDATA> | </BODY> | </ENVELOPE> | |||||||||||||||||||||||||
| 4 | ro | Round Off | Indirect Expenses | <ENVELOPE> | <HEADER> | <TALLYREQUEST>Import Data</TALLYREQUEST> | </HEADER> | <BODY> | <IMPORTDATA> | <REQUESTDESC> | <REPORTNAME>All Masters</REPORTNAME> | <STATICVARIABLES> | <SVCURRENTCOMPANY></SVCURRENTCOMPANY> | </STATICVARIABLES> | </REQUESTDESC> | <REQUESTDATA> | <TALLYMESSAGE xmlns:UDF="TallyUDF"><LEDGER NAME=" | Round Off | " RESERVEDNAME=""><ADDRESS.LIST TYPE="String"><ADDRESS> | 0 | </ADDRESS><ADDRESS> | 0 | </ADDRESS><ADDRESS> | 0 | </ADDRESS><ADDRESS> | 0 | </ADDRESS></ADDRESS.LIST><MAILINGNAME.LIST TYPE="String"><MAILINGNAME> | Round Off | </MAILINGNAME></MAILINGNAME.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><GUID></GUID><CURRENCYNAME>₹</CURRENCYNAME><PINCODE> | 0 | </PINCODE><COUNTRYNAME>India</COUNTRYNAME><GSTREGISTRATIONTYPE> | 0 | </GSTREGISTRATIONTYPE><VATDEALERTYPE> | 0 | </VATDEALERTYPE><PARENT> | Indirect Expenses | </PARENT><TAXCLASSIFICATIONNAME/><TAXTYPE>Others</TAXTYPE><COUNTRYOFRESIDENCE>India</COUNTRYOFRESIDENCE><GSTTYPE/><APPROPRIATEFOR/><PARTYGSTIN> | 0 | </PARTYGSTIN><GSTNATUREOFSUPPLY/><SERVICECATEGORY></SERVICECATEGORY><EXCISELEDGERCLASSIFICATION/><EXCISEDUTYTYPE/><EXCISENATUREOFPURCHASE/><LEDGERFBTCATEGORY/><LEDSTATENAME> | 0 | </LEDSTATENAME><ISBILLWISEON> | Yes | </ISBILLWISEON><ISCOSTCENTRESON>No</ISCOSTCENTRESON><ISINTERESTON>No</ISINTERESTON><ALLOWINMOBILE>No</ALLOWINMOBILE><ISCOSTTRACKINGON>No</ISCOSTTRACKINGON><ISBENEFICIARYCODEON>No</ISBENEFICIARYCODEON><ISUPDATINGTARGETID>No</ISUPDATINGTARGETID><ASORIGINAL>Yes</ASORIGINAL><ISCONDENSED>No</ISCONDENSED><AFFECTSSTOCK>No</AFFECTSSTOCK><ISRATEINCLUSIVEVAT>No</ISRATEINCLUSIVEVAT><FORPAYROLL>No</FORPAYROLL><ISABCENABLED>No</ISABCENABLED><ISCREDITDAYSCHKON>No</ISCREDITDAYSCHKON><INTERESTONBILLWISE>No</INTERESTONBILLWISE><OVERRIDEINTEREST>No</OVERRIDEINTEREST><OVERRIDEADVINTEREST>No</OVERRIDEADVINTEREST><USEFORVAT>No</USEFORVAT><IGNORETDSEXEMPT>No</IGNORETDSEXEMPT><ISTCSAPPLICABLE>No</ISTCSAPPLICABLE><ISTDSAPPLICABLE>No</ISTDSAPPLICABLE><ISFBTAPPLICABLE>No</ISFBTAPPLICABLE><ISGSTAPPLICABLE>No</ISGSTAPPLICABLE><ISEXCISEAPPLICABLE>No</ISEXCISEAPPLICABLE><ISTDSEXPENSE>No</ISTDSEXPENSE><ISEDLIAPPLICABLE>No</ISEDLIAPPLICABLE><ISRELATEDPARTY>No</ISRELATEDPARTY><USEFORESIELIGIBILITY>No</USEFORESIELIGIBILITY><ISINTERESTINCLLASTDAY>No</ISINTERESTINCLLASTDAY><APPROPRIATETAXVALUE>No</APPROPRIATETAXVALUE><ISBEHAVEASDUTY>No</ISBEHAVEASDUTY><INTERESTINCLDAYOFADDITION>No</INTERESTINCLDAYOFADDITION><INTERESTINCLDAYOFDEDUCTION>No</INTERESTINCLDAYOFDEDUCTION><ISOTHTERRITORYASSESSEE>No</ISOTHTERRITORYASSESSEE><OVERRIDECREDITLIMIT>No</OVERRIDECREDITLIMIT><ISAGAINSTFORMC>No</ISAGAINSTFORMC><ISCHEQUEPRINTINGENABLED>Yes</ISCHEQUEPRINTINGENABLED><ISPAYUPLOAD>No</ISPAYUPLOAD><ISPAYBATCHONLYSAL>No</ISPAYBATCHONLYSAL><ISBNFCODESUPPORTED>No</ISBNFCODESUPPORTED><ALLOWEXPORTWITHERRORS>No</ALLOWEXPORTWITHERRORS><CONSIDERPURCHASEFOREXPORT>No</CONSIDERPURCHASEFOREXPORT><ISTRANSPORTER>No</ISTRANSPORTER><USEFORNOTIONALITC>No</USEFORNOTIONALITC><ISECOMMOPERATOR>No</ISECOMMOPERATOR><SHOWINPAYSLIP>No</SHOWINPAYSLIP><USEFORGRATUITY>No</USEFORGRATUITY><ISTDSPROJECTED>No</ISTDSPROJECTED><FORSERVICETAX>No</FORSERVICETAX><ISINPUTCREDIT>No</ISINPUTCREDIT><ISEXEMPTED>No</ISEXEMPTED><ISABATEMENTAPPLICABLE>No</ISABATEMENTAPPLICABLE><ISSTXPARTY>No</ISSTXPARTY><ISSTXNONREALIZEDTYPE>No</ISSTXNONREALIZEDTYPE><ISUSEDFORCVD>No</ISUSEDFORCVD><LEDBELONGSTONONTAXABLE>No</LEDBELONGSTONONTAXABLE><ISEXCISEMERCHANTEXPORTER>No</ISEXCISEMERCHANTEXPORTER><ISPARTYEXEMPTED>No</ISPARTYEXEMPTED><ISSEZPARTY>No</ISSEZPARTY><TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE><ISECHEQUESUPPORTED>No</ISECHEQUESUPPORTED><ISEDDSUPPORTED>No</ISEDDSUPPORTED><HASECHEQUEDELIVERYMODE>No</HASECHEQUEDELIVERYMODE><HASECHEQUEDELIVERYTO>No</HASECHEQUEDELIVERYTO><HASECHEQUEPRINTLOCATION>No</HASECHEQUEPRINTLOCATION><HASECHEQUEPAYABLELOCATION>No</HASECHEQUEPAYABLELOCATION><HASECHEQUEBANKLOCATION>No</HASECHEQUEBANKLOCATION><HASEDDDELIVERYMODE>No</HASEDDDELIVERYMODE><HASEDDDELIVERYTO>No</HASEDDDELIVERYTO><HASEDDPRINTLOCATION>No</HASEDDPRINTLOCATION><HASEDDPAYABLELOCATION>No</HASEDDPAYABLELOCATION><HASEDDBANKLOCATION>No</HASEDDBANKLOCATION><ISEBANKINGENABLED>No</ISEBANKINGENABLED><ISEXPORTFILEENCRYPTED>No</ISEXPORTFILEENCRYPTED><ISBATCHENABLED>No</ISBATCHENABLED><ISPRODUCTCODEBASED>No</ISPRODUCTCODEBASED><HASEDDCITY>No</HASEDDCITY><HASECHEQUECITY>No</HASECHEQUECITY><ISFILENAMEFORMATSUPPORTED>No</ISFILENAMEFORMATSUPPORTED><HASCLIENTCODE>No</HASCLIENTCODE><PAYINSISBATCHAPPLICABLE>No</PAYINSISBATCHAPPLICABLE><PAYINSISFILENUMAPP>No</PAYINSISFILENUMAPP><ISSALARYTRANSGROUPEDFORBRS>No</ISSALARYTRANSGROUPEDFORBRS><ISEBANKINGSUPPORTED>No</ISEBANKINGSUPPORTED><ISSCBUAE>No</ISSCBUAE><ISBANKSTATUSAPP>No</ISBANKSTATUSAPP><ISSALARYGROUPED>No</ISSALARYGROUPED><USEFORPURCHASETAX>No</USEFORPURCHASETAX><AUDITED>No</AUDITED><SORTPOSITION> 1000</SORTPOSITION><ALTERID> 168</ALTERID><OPENINGBALANCE> | 0.00 | </OPENINGBALANCE><SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST><LBTREGNDETAILS.LIST> </LBTREGNDETAILS.LIST><VATDETAILS.LIST> </VATDETAILS.LIST><SALESTAXCESSDETAILS.LIST> </SALESTAXCESSDETAILS.LIST><GSTDETAILS.LIST> </GSTDETAILS.LIST><LANGUAGENAME.LIST><NAME.LIST TYPE="String"><NAME> | Round Off | </NAME><NAME> | ro | </NAME></NAME.LIST><LANGUAGEID> 1033</LANGUAGEID></LANGUAGENAME.LIST><XBRLDETAIL.LIST> </XBRLDETAIL.LIST><AUDITDETAILS.LIST> </AUDITDETAILS.LIST><SCHVIDETAILS.LIST> </SCHVIDETAILS.LIST><EXCISETARIFFDETAILS.LIST> </EXCISETARIFFDETAILS.LIST><TCSCATEGORYDETAILS.LIST> </TCSCATEGORYDETAILS.LIST><TDSCATEGORYDETAILS.LIST> </TDSCATEGORYDETAILS.LIST><SLABPERIOD.LIST> </SLABPERIOD.LIST><GRATUITYPERIOD.LIST> </GRATUITYPERIOD.LIST><ADDITIONALCOMPUTATIONS.LIST> </ADDITIONALCOMPUTATIONS.LIST><EXCISEJURISDICTIONDETAILS.LIST> </EXCISEJURISDICTIONDETAILS.LIST><EXCLUDEDTAXATIONS.LIST> </EXCLUDEDTAXATIONS.LIST><BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST><PAYMENTDETAILS.LIST> </PAYMENTDETAILS.LIST><BANKEXPORTFORMATS.LIST> </BANKEXPORTFORMATS.LIST><BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST><LEDGERCLOSINGVALUES.LIST> </LEDGERCLOSINGVALUES.LIST><LEDGERAUDITCLASS.LIST> </LEDGERAUDITCLASS.LIST><OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST><TDSEXEMPTIONRULES.LIST> </TDSEXEMPTIONRULES.LIST><DEDUCTINSAMEVCHRULES.LIST> </DEDUCTINSAMEVCHRULES.LIST><LOWERDEDUCTION.LIST> </LOWERDEDUCTION.LIST><STXABATEMENTDETAILS.LIST> </STXABATEMENTDETAILS.LIST><LEDMULTIADDRESSLIST.LIST> </LEDMULTIADDRESSLIST.LIST><STXTAXDETAILS.LIST> </STXTAXDETAILS.LIST><CHEQUERANGE.LIST> </CHEQUERANGE.LIST><DEFAULTVCHCHEQUEDETAILS.LIST> </DEFAULTVCHCHEQUEDETAILS.LIST><ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST> </AUDITENTRIES.LIST><BRSIMPORTEDINFO.LIST> </BRSIMPORTEDINFO.LIST><AUTOBRSCONFIGS.LIST> </AUTOBRSCONFIGS.LIST><BANKURENTRIES.LIST> </BANKURENTRIES.LIST><DEFAULTCHEQUEDETAILS.LIST> </DEFAULTCHEQUEDETAILS.LIST><DEFAULTOPENINGCHEQUEDETAILS.LIST> </DEFAULTOPENINGCHEQUEDETAILS.LIST><CANCELLEDPAYALLOCATIONS.LIST> </CANCELLEDPAYALLOCATIONS.LIST><ECHEQUEPRINTLOCATION.LIST> </ECHEQUEPRINTLOCATION.LIST><ECHEQUEPAYABLELOCATION.LIST> </ECHEQUEPAYABLELOCATION.LIST><EDDPRINTLOCATION.LIST> </EDDPRINTLOCATION.LIST><EDDPAYABLELOCATION.LIST> </EDDPAYABLELOCATION.LIST><AVAILABLETRANSACTIONTYPES.LIST> </AVAILABLETRANSACTIONTYPES.LIST><LEDPAYINSCONFIGS.LIST> </LEDPAYINSCONFIGS.LIST><TYPECODEDETAILS.LIST> </TYPECODEDETAILS.LIST><FIELDVALIDATIONDETAILS.LIST> </FIELDVALIDATIONDETAILS.LIST><INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST><GSTCLASSFNIGSTRATES.LIST> </GSTCLASSFNIGSTRATES.LIST><EXTARIFFDUTYHEADDETAILS.LIST> </EXTARIFFDUTYHEADDETAILS.LIST><VOUCHERTYPEPRODUCTCODES.LIST> </VOUCHERTYPEPRODUCTCODES.LIST></LEDGER></TALLYMESSAGE> | </REQUESTDATA> | </IMPORTDATA> | </BODY> | </ENVELOPE> | |||||||||||||||||||||||||
| 5 | January | Sundry Debtors | 29xxxxx1111x1 | Regular | # 006 | ITI Layout | BSK 3rd Stage | Bangalore | Karnataka | 560085 | <ENVELOPE> | <HEADER> | <TALLYREQUEST>Import Data</TALLYREQUEST> | </HEADER> | <BODY> | <IMPORTDATA> | <REQUESTDESC> | <REPORTNAME>All Masters</REPORTNAME> | <STATICVARIABLES> | <SVCURRENTCOMPANY></SVCURRENTCOMPANY> | </STATICVARIABLES> | </REQUESTDESC> | <REQUESTDATA> | <TALLYMESSAGE xmlns:UDF="TallyUDF"><LEDGER NAME=" | January | " RESERVEDNAME=""><ADDRESS.LIST TYPE="String"><ADDRESS> | # 006 | </ADDRESS><ADDRESS> | ITI Layout | </ADDRESS><ADDRESS> | BSK 3rd Stage | </ADDRESS><ADDRESS> | Bangalore | </ADDRESS></ADDRESS.LIST><MAILINGNAME.LIST TYPE="String"><MAILINGNAME> | January | </MAILINGNAME></MAILINGNAME.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><GUID></GUID><CURRENCYNAME>₹</CURRENCYNAME><PINCODE> | 560085 | </PINCODE><COUNTRYNAME>India</COUNTRYNAME><GSTREGISTRATIONTYPE> | Regular | </GSTREGISTRATIONTYPE><VATDEALERTYPE> | Regular | </VATDEALERTYPE><PARENT> | Sundry Debtors | </PARENT><TAXCLASSIFICATIONNAME/><TAXTYPE>Others</TAXTYPE><COUNTRYOFRESIDENCE>India</COUNTRYOFRESIDENCE><GSTTYPE/><APPROPRIATEFOR/><PARTYGSTIN> | 29xxxxx1111x1 | </PARTYGSTIN><GSTNATUREOFSUPPLY/><SERVICECATEGORY></SERVICECATEGORY><EXCISELEDGERCLASSIFICATION/><EXCISEDUTYTYPE/><EXCISENATUREOFPURCHASE/><LEDGERFBTCATEGORY/><LEDSTATENAME> | Karnataka | </LEDSTATENAME><ISBILLWISEON> | Yes | </ISBILLWISEON><ISCOSTCENTRESON>No</ISCOSTCENTRESON><ISINTERESTON>No</ISINTERESTON><ALLOWINMOBILE>No</ALLOWINMOBILE><ISCOSTTRACKINGON>No</ISCOSTTRACKINGON><ISBENEFICIARYCODEON>No</ISBENEFICIARYCODEON><ISUPDATINGTARGETID>No</ISUPDATINGTARGETID><ASORIGINAL>Yes</ASORIGINAL><ISCONDENSED>No</ISCONDENSED><AFFECTSSTOCK>No</AFFECTSSTOCK><ISRATEINCLUSIVEVAT>No</ISRATEINCLUSIVEVAT><FORPAYROLL>No</FORPAYROLL><ISABCENABLED>No</ISABCENABLED><ISCREDITDAYSCHKON>No</ISCREDITDAYSCHKON><INTERESTONBILLWISE>No</INTERESTONBILLWISE><OVERRIDEINTEREST>No</OVERRIDEINTEREST><OVERRIDEADVINTEREST>No</OVERRIDEADVINTEREST><USEFORVAT>No</USEFORVAT><IGNORETDSEXEMPT>No</IGNORETDSEXEMPT><ISTCSAPPLICABLE>No</ISTCSAPPLICABLE><ISTDSAPPLICABLE>No</ISTDSAPPLICABLE><ISFBTAPPLICABLE>No</ISFBTAPPLICABLE><ISGSTAPPLICABLE>No</ISGSTAPPLICABLE><ISEXCISEAPPLICABLE>No</ISEXCISEAPPLICABLE><ISTDSEXPENSE>No</ISTDSEXPENSE><ISEDLIAPPLICABLE>No</ISEDLIAPPLICABLE><ISRELATEDPARTY>No</ISRELATEDPARTY><USEFORESIELIGIBILITY>No</USEFORESIELIGIBILITY><ISINTERESTINCLLASTDAY>No</ISINTERESTINCLLASTDAY><APPROPRIATETAXVALUE>No</APPROPRIATETAXVALUE><ISBEHAVEASDUTY>No</ISBEHAVEASDUTY><INTERESTINCLDAYOFADDITION>No</INTERESTINCLDAYOFADDITION><INTERESTINCLDAYOFDEDUCTION>No</INTERESTINCLDAYOFDEDUCTION><ISOTHTERRITORYASSESSEE>No</ISOTHTERRITORYASSESSEE><OVERRIDECREDITLIMIT>No</OVERRIDECREDITLIMIT><ISAGAINSTFORMC>No</ISAGAINSTFORMC><ISCHEQUEPRINTINGENABLED>Yes</ISCHEQUEPRINTINGENABLED><ISPAYUPLOAD>No</ISPAYUPLOAD><ISPAYBATCHONLYSAL>No</ISPAYBATCHONLYSAL><ISBNFCODESUPPORTED>No</ISBNFCODESUPPORTED><ALLOWEXPORTWITHERRORS>No</ALLOWEXPORTWITHERRORS><CONSIDERPURCHASEFOREXPORT>No</CONSIDERPURCHASEFOREXPORT><ISTRANSPORTER>No</ISTRANSPORTER><USEFORNOTIONALITC>No</USEFORNOTIONALITC><ISECOMMOPERATOR>No</ISECOMMOPERATOR><SHOWINPAYSLIP>No</SHOWINPAYSLIP><USEFORGRATUITY>No</USEFORGRATUITY><ISTDSPROJECTED>No</ISTDSPROJECTED><FORSERVICETAX>No</FORSERVICETAX><ISINPUTCREDIT>No</ISINPUTCREDIT><ISEXEMPTED>No</ISEXEMPTED><ISABATEMENTAPPLICABLE>No</ISABATEMENTAPPLICABLE><ISSTXPARTY>No</ISSTXPARTY><ISSTXNONREALIZEDTYPE>No</ISSTXNONREALIZEDTYPE><ISUSEDFORCVD>No</ISUSEDFORCVD><LEDBELONGSTONONTAXABLE>No</LEDBELONGSTONONTAXABLE><ISEXCISEMERCHANTEXPORTER>No</ISEXCISEMERCHANTEXPORTER><ISPARTYEXEMPTED>No</ISPARTYEXEMPTED><ISSEZPARTY>No</ISSEZPARTY><TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE><ISECHEQUESUPPORTED>No</ISECHEQUESUPPORTED><ISEDDSUPPORTED>No</ISEDDSUPPORTED><HASECHEQUEDELIVERYMODE>No</HASECHEQUEDELIVERYMODE><HASECHEQUEDELIVERYTO>No</HASECHEQUEDELIVERYTO><HASECHEQUEPRINTLOCATION>No</HASECHEQUEPRINTLOCATION><HASECHEQUEPAYABLELOCATION>No</HASECHEQUEPAYABLELOCATION><HASECHEQUEBANKLOCATION>No</HASECHEQUEBANKLOCATION><HASEDDDELIVERYMODE>No</HASEDDDELIVERYMODE><HASEDDDELIVERYTO>No</HASEDDDELIVERYTO><HASEDDPRINTLOCATION>No</HASEDDPRINTLOCATION><HASEDDPAYABLELOCATION>No</HASEDDPAYABLELOCATION><HASEDDBANKLOCATION>No</HASEDDBANKLOCATION><ISEBANKINGENABLED>No</ISEBANKINGENABLED><ISEXPORTFILEENCRYPTED>No</ISEXPORTFILEENCRYPTED><ISBATCHENABLED>No</ISBATCHENABLED><ISPRODUCTCODEBASED>No</ISPRODUCTCODEBASED><HASEDDCITY>No</HASEDDCITY><HASECHEQUECITY>No</HASECHEQUECITY><ISFILENAMEFORMATSUPPORTED>No</ISFILENAMEFORMATSUPPORTED><HASCLIENTCODE>No</HASCLIENTCODE><PAYINSISBATCHAPPLICABLE>No</PAYINSISBATCHAPPLICABLE><PAYINSISFILENUMAPP>No</PAYINSISFILENUMAPP><ISSALARYTRANSGROUPEDFORBRS>No</ISSALARYTRANSGROUPEDFORBRS><ISEBANKINGSUPPORTED>No</ISEBANKINGSUPPORTED><ISSCBUAE>No</ISSCBUAE><ISBANKSTATUSAPP>No</ISBANKSTATUSAPP><ISSALARYGROUPED>No</ISSALARYGROUPED><USEFORPURCHASETAX>No</USEFORPURCHASETAX><AUDITED>No</AUDITED><SORTPOSITION> 1000</SORTPOSITION><ALTERID> 168</ALTERID><OPENINGBALANCE> | 0.00 | </OPENINGBALANCE><SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST><LBTREGNDETAILS.LIST> </LBTREGNDETAILS.LIST><VATDETAILS.LIST> </VATDETAILS.LIST><SALESTAXCESSDETAILS.LIST> </SALESTAXCESSDETAILS.LIST><GSTDETAILS.LIST> </GSTDETAILS.LIST><LANGUAGENAME.LIST><NAME.LIST TYPE="String"><NAME> | January | </NAME><NAME> | 0 | </NAME></NAME.LIST><LANGUAGEID> 1033</LANGUAGEID></LANGUAGENAME.LIST><XBRLDETAIL.LIST> </XBRLDETAIL.LIST><AUDITDETAILS.LIST> </AUDITDETAILS.LIST><SCHVIDETAILS.LIST> </SCHVIDETAILS.LIST><EXCISETARIFFDETAILS.LIST> </EXCISETARIFFDETAILS.LIST><TCSCATEGORYDETAILS.LIST> </TCSCATEGORYDETAILS.LIST><TDSCATEGORYDETAILS.LIST> </TDSCATEGORYDETAILS.LIST><SLABPERIOD.LIST> </SLABPERIOD.LIST><GRATUITYPERIOD.LIST> </GRATUITYPERIOD.LIST><ADDITIONALCOMPUTATIONS.LIST> </ADDITIONALCOMPUTATIONS.LIST><EXCISEJURISDICTIONDETAILS.LIST> </EXCISEJURISDICTIONDETAILS.LIST><EXCLUDEDTAXATIONS.LIST> </EXCLUDEDTAXATIONS.LIST><BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST><PAYMENTDETAILS.LIST> </PAYMENTDETAILS.LIST><BANKEXPORTFORMATS.LIST> </BANKEXPORTFORMATS.LIST><BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST><LEDGERCLOSINGVALUES.LIST> </LEDGERCLOSINGVALUES.LIST><LEDGERAUDITCLASS.LIST> </LEDGERAUDITCLASS.LIST><OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST><TDSEXEMPTIONRULES.LIST> </TDSEXEMPTIONRULES.LIST><DEDUCTINSAMEVCHRULES.LIST> </DEDUCTINSAMEVCHRULES.LIST><LOWERDEDUCTION.LIST> </LOWERDEDUCTION.LIST><STXABATEMENTDETAILS.LIST> </STXABATEMENTDETAILS.LIST><LEDMULTIADDRESSLIST.LIST> </LEDMULTIADDRESSLIST.LIST><STXTAXDETAILS.LIST> </STXTAXDETAILS.LIST><CHEQUERANGE.LIST> </CHEQUERANGE.LIST><DEFAULTVCHCHEQUEDETAILS.LIST> </DEFAULTVCHCHEQUEDETAILS.LIST><ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST> </AUDITENTRIES.LIST><BRSIMPORTEDINFO.LIST> </BRSIMPORTEDINFO.LIST><AUTOBRSCONFIGS.LIST> </AUTOBRSCONFIGS.LIST><BANKURENTRIES.LIST> </BANKURENTRIES.LIST><DEFAULTCHEQUEDETAILS.LIST> </DEFAULTCHEQUEDETAILS.LIST><DEFAULTOPENINGCHEQUEDETAILS.LIST> </DEFAULTOPENINGCHEQUEDETAILS.LIST><CANCELLEDPAYALLOCATIONS.LIST> </CANCELLEDPAYALLOCATIONS.LIST><ECHEQUEPRINTLOCATION.LIST> </ECHEQUEPRINTLOCATION.LIST><ECHEQUEPAYABLELOCATION.LIST> </ECHEQUEPAYABLELOCATION.LIST><EDDPRINTLOCATION.LIST> </EDDPRINTLOCATION.LIST><EDDPAYABLELOCATION.LIST> </EDDPAYABLELOCATION.LIST><AVAILABLETRANSACTIONTYPES.LIST> </AVAILABLETRANSACTIONTYPES.LIST><LEDPAYINSCONFIGS.LIST> </LEDPAYINSCONFIGS.LIST><TYPECODEDETAILS.LIST> </TYPECODEDETAILS.LIST><FIELDVALIDATIONDETAILS.LIST> </FIELDVALIDATIONDETAILS.LIST><INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST><GSTCLASSFNIGSTRATES.LIST> </GSTCLASSFNIGSTRATES.LIST><EXTARIFFDUTYHEADDETAILS.LIST> </EXTARIFFDUTYHEADDETAILS.LIST><VOUCHERTYPEPRODUCTCODES.LIST> </VOUCHERTYPEPRODUCTCODES.LIST></LEDGER></TALLYMESSAGE> | </REQUESTDATA> | </IMPORTDATA> | </BODY> | </ENVELOPE> | ||||||||||||||||||
| 6 | February | Sundry Debtors | 29xxxxx1111x2 | Regular | # 007 | ITI Layout | BSK 3rd Stage | Bangalore | Karnataka | 560085 | <ENVELOPE> | <HEADER> | <TALLYREQUEST>Import Data</TALLYREQUEST> | </HEADER> | <BODY> | <IMPORTDATA> | <REQUESTDESC> | <REPORTNAME>All Masters</REPORTNAME> | <STATICVARIABLES> | <SVCURRENTCOMPANY></SVCURRENTCOMPANY> | </STATICVARIABLES> | </REQUESTDESC> | <REQUESTDATA> | <TALLYMESSAGE xmlns:UDF="TallyUDF"><LEDGER NAME=" | February | " RESERVEDNAME=""><ADDRESS.LIST TYPE="String"><ADDRESS> | # 007 | </ADDRESS><ADDRESS> | ITI Layout | </ADDRESS><ADDRESS> | BSK 3rd Stage | </ADDRESS><ADDRESS> | Bangalore | </ADDRESS></ADDRESS.LIST><MAILINGNAME.LIST TYPE="String"><MAILINGNAME> | February | </MAILINGNAME></MAILINGNAME.LIST><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST><GUID></GUID><CURRENCYNAME>₹</CURRENCYNAME><PINCODE> | 560085 | </PINCODE><COUNTRYNAME>India</COUNTRYNAME><GSTREGISTRATIONTYPE> | Regular | </GSTREGISTRATIONTYPE><VATDEALERTYPE> | Regular | </VATDEALERTYPE><PARENT> | Sundry Debtors | </PARENT><TAXCLASSIFICATIONNAME/><TAXTYPE>Others</TAXTYPE><COUNTRYOFRESIDENCE>India</COUNTRYOFRESIDENCE><GSTTYPE/><APPROPRIATEFOR/><PARTYGSTIN> | 29xxxxx1111x2 | </PARTYGSTIN><GSTNATUREOFSUPPLY/><SERVICECATEGORY></SERVICECATEGORY><EXCISELEDGERCLASSIFICATION/><EXCISEDUTYTYPE/><EXCISENATUREOFPURCHASE/><LEDGERFBTCATEGORY/><LEDSTATENAME> | Karnataka | </LEDSTATENAME><ISBILLWISEON> | Yes | </ISBILLWISEON><ISCOSTCENTRESON>No</ISCOSTCENTRESON><ISINTERESTON>No</ISINTERESTON><ALLOWINMOBILE>No</ALLOWINMOBILE><ISCOSTTRACKINGON>No</ISCOSTTRACKINGON><ISBENEFICIARYCODEON>No</ISBENEFICIARYCODEON><ISUPDATINGTARGETID>No</ISUPDATINGTARGETID><ASORIGINAL>Yes</ASORIGINAL><ISCONDENSED>No</ISCONDENSED><AFFECTSSTOCK>No</AFFECTSSTOCK><ISRATEINCLUSIVEVAT>No</ISRATEINCLUSIVEVAT><FORPAYROLL>No</FORPAYROLL><ISABCENABLED>No</ISABCENABLED><ISCREDITDAYSCHKON>No</ISCREDITDAYSCHKON><INTERESTONBILLWISE>No</INTERESTONBILLWISE><OVERRIDEINTEREST>No</OVERRIDEINTEREST><OVERRIDEADVINTEREST>No</OVERRIDEADVINTEREST><USEFORVAT>No</USEFORVAT><IGNORETDSEXEMPT>No</IGNORETDSEXEMPT><ISTCSAPPLICABLE>No</ISTCSAPPLICABLE><ISTDSAPPLICABLE>No</ISTDSAPPLICABLE><ISFBTAPPLICABLE>No</ISFBTAPPLICABLE><ISGSTAPPLICABLE>No</ISGSTAPPLICABLE><ISEXCISEAPPLICABLE>No</ISEXCISEAPPLICABLE><ISTDSEXPENSE>No</ISTDSEXPENSE><ISEDLIAPPLICABLE>No</ISEDLIAPPLICABLE><ISRELATEDPARTY>No</ISRELATEDPARTY><USEFORESIELIGIBILITY>No</USEFORESIELIGIBILITY><ISINTERESTINCLLASTDAY>No</ISINTERESTINCLLASTDAY><APPROPRIATETAXVALUE>No</APPROPRIATETAXVALUE><ISBEHAVEASDUTY>No</ISBEHAVEASDUTY><INTERESTINCLDAYOFADDITION>No</INTERESTINCLDAYOFADDITION><INTERESTINCLDAYOFDEDUCTION>No</INTERESTINCLDAYOFDEDUCTION><ISOTHTERRITORYASSESSEE>No</ISOTHTERRITORYASSESSEE><OVERRIDECREDITLIMIT>No</OVERRIDECREDITLIMIT><ISAGAINSTFORMC>No</ISAGAINSTFORMC><ISCHEQUEPRINTINGENABLED>Yes</ISCHEQUEPRINTINGENABLED><ISPAYUPLOAD>No</ISPAYUPLOAD><ISPAYBATCHONLYSAL>No</ISPAYBATCHONLYSAL><ISBNFCODESUPPORTED>No</ISBNFCODESUPPORTED><ALLOWEXPORTWITHERRORS>No</ALLOWEXPORTWITHERRORS><CONSIDERPURCHASEFOREXPORT>No</CONSIDERPURCHASEFOREXPORT><ISTRANSPORTER>No</ISTRANSPORTER><USEFORNOTIONALITC>No</USEFORNOTIONALITC><ISECOMMOPERATOR>No</ISECOMMOPERATOR><SHOWINPAYSLIP>No</SHOWINPAYSLIP><USEFORGRATUITY>No</USEFORGRATUITY><ISTDSPROJECTED>No</ISTDSPROJECTED><FORSERVICETAX>No</FORSERVICETAX><ISINPUTCREDIT>No</ISINPUTCREDIT><ISEXEMPTED>No</ISEXEMPTED><ISABATEMENTAPPLICABLE>No</ISABATEMENTAPPLICABLE><ISSTXPARTY>No</ISSTXPARTY><ISSTXNONREALIZEDTYPE>No</ISSTXNONREALIZEDTYPE><ISUSEDFORCVD>No</ISUSEDFORCVD><LEDBELONGSTONONTAXABLE>No</LEDBELONGSTONONTAXABLE><ISEXCISEMERCHANTEXPORTER>No</ISEXCISEMERCHANTEXPORTER><ISPARTYEXEMPTED>No</ISPARTYEXEMPTED><ISSEZPARTY>No</ISSEZPARTY><TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE><ISECHEQUESUPPORTED>No</ISECHEQUESUPPORTED><ISEDDSUPPORTED>No</ISEDDSUPPORTED><HASECHEQUEDELIVERYMODE>No</HASECHEQUEDELIVERYMODE><HASECHEQUEDELIVERYTO>No</HASECHEQUEDELIVERYTO><HASECHEQUEPRINTLOCATION>No</HASECHEQUEPRINTLOCATION><HASECHEQUEPAYABLELOCATION>No</HASECHEQUEPAYABLELOCATION><HASECHEQUEBANKLOCATION>No</HASECHEQUEBANKLOCATION><HASEDDDELIVERYMODE>No</HASEDDDELIVERYMODE><HASEDDDELIVERYTO>No</HASEDDDELIVERYTO><HASEDDPRINTLOCATION>No</HASEDDPRINTLOCATION><HASEDDPAYABLELOCATION>No</HASEDDPAYABLELOCATION><HASEDDBANKLOCATION>No</HASEDDBANKLOCATION><ISEBANKINGENABLED>No</ISEBANKINGENABLED><ISEXPORTFILEENCRYPTED>No</ISEXPORTFILEENCRYPTED><ISBATCHENABLED>No</ISBATCHENABLED><ISPRODUCTCODEBASED>No</ISPRODUCTCODEBASED><HASEDDCITY>No</HASEDDCITY><HASECHEQUECITY>No</HASECHEQUECITY><ISFILENAMEFORMATSUPPORTED>No</ISFILENAMEFORMATSUPPORTED><HASCLIENTCODE>No</HASCLIENTCODE><PAYINSISBATCHAPPLICABLE>No</PAYINSISBATCHAPPLICABLE><PAYINSISFILENUMAPP>No</PAYINSISFILENUMAPP><ISSALARYTRANSGROUPEDFORBRS>No</ISSALARYTRANSGROUPEDFORBRS><ISEBANKINGSUPPORTED>No</ISEBANKINGSUPPORTED><ISSCBUAE>No</ISSCBUAE><ISBANKSTATUSAPP>No</ISBANKSTATUSAPP><ISSALARYGROUPED>No</ISSALARYGROUPED><USEFORPURCHASETAX>No</USEFORPURCHASETAX><AUDITED>No</AUDITED><SORTPOSITION> 1000</SORTPOSITION><ALTERID> 168</ALTERID><OPENINGBALANCE> | 0.00 | </OPENINGBALANCE><SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST><LBTREGNDETAILS.LIST> </LBTREGNDETAILS.LIST><VATDETAILS.LIST> </VATDETAILS.LIST><SALESTAXCESSDETAILS.LIST> </SALESTAXCESSDETAILS.LIST><GSTDETAILS.LIST> </GSTDETAILS.LIST><LANGUAGENAME.LIST><NAME.LIST TYPE="String"><NAME> | February | </NAME><NAME> | 0 | </NAME></NAME.LIST><LANGUAGEID> 1033</LANGUAGEID></LANGUAGENAME.LIST><XBRLDETAIL.LIST> </XBRLDETAIL.LIST><AUDITDETAILS.LIST> </AUDITDETAILS.LIST><SCHVIDETAILS.LIST> </SCHVIDETAILS.LIST><EXCISETARIFFDETAILS.LIST> </EXCISETARIFFDETAILS.LIST><TCSCATEGORYDETAILS.LIST> </TCSCATEGORYDETAILS.LIST><TDSCATEGORYDETAILS.LIST> </TDSCATEGORYDETAILS.LIST><SLABPERIOD.LIST> </SLABPERIOD.LIST><GRATUITYPERIOD.LIST> </GRATUITYPERIOD.LIST><ADDITIONALCOMPUTATIONS.LIST> </ADDITIONALCOMPUTATIONS.LIST><EXCISEJURISDICTIONDETAILS.LIST> </EXCISEJURISDICTIONDETAILS.LIST><EXCLUDEDTAXATIONS.LIST> </EXCLUDEDTAXATIONS.LIST><BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST><PAYMENTDETAILS.LIST> </PAYMENTDETAILS.LIST><BANKEXPORTFORMATS.LIST> </BANKEXPORTFORMATS.LIST><BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST><INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST><LEDGERCLOSINGVALUES.LIST> </LEDGERCLOSINGVALUES.LIST><LEDGERAUDITCLASS.LIST> </LEDGERAUDITCLASS.LIST><OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST><TDSEXEMPTIONRULES.LIST> </TDSEXEMPTIONRULES.LIST><DEDUCTINSAMEVCHRULES.LIST> </DEDUCTINSAMEVCHRULES.LIST><LOWERDEDUCTION.LIST> </LOWERDEDUCTION.LIST><STXABATEMENTDETAILS.LIST> </STXABATEMENTDETAILS.LIST><LEDMULTIADDRESSLIST.LIST> </LEDMULTIADDRESSLIST.LIST><STXTAXDETAILS.LIST> </STXTAXDETAILS.LIST><CHEQUERANGE.LIST> </CHEQUERANGE.LIST><DEFAULTVCHCHEQUEDETAILS.LIST> </DEFAULTVCHCHEQUEDETAILS.LIST><ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST><AUDITENTRIES.LIST> </AUDITENTRIES.LIST><BRSIMPORTEDINFO.LIST> </BRSIMPORTEDINFO.LIST><AUTOBRSCONFIGS.LIST> </AUTOBRSCONFIGS.LIST><BANKURENTRIES.LIST> </BANKURENTRIES.LIST><DEFAULTCHEQUEDETAILS.LIST> </DEFAULTCHEQUEDETAILS.LIST><DEFAULTOPENINGCHEQUEDETAILS.LIST> </DEFAULTOPENINGCHEQUEDETAILS.LIST><CANCELLEDPAYALLOCATIONS.LIST> </CANCELLEDPAYALLOCATIONS.LIST><ECHEQUEPRINTLOCATION.LIST> </ECHEQUEPRINTLOCATION.LIST><ECHEQUEPAYABLELOCATION.LIST> </ECHEQUEPAYABLELOCATION.LIST><EDDPRINTLOCATION.LIST> </EDDPRINTLOCATION.LIST><EDDPAYABLELOCATION.LIST> </EDDPAYABLELOCATION.LIST><AVAILABLETRANSACTIONTYPES.LIST> </AVAILABLETRANSACTIONTYPES.LIST><LEDPAYINSCONFIGS.LIST> </LEDPAYINSCONFIGS.LIST><TYPECODEDETAILS.LIST> </TYPECODEDETAILS.LIST><FIELDVALIDATIONDETAILS.LIST> </FIELDVALIDATIONDETAILS.LIST><INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST><GSTCLASSFNIGSTRATES.LIST> </GSTCLASSFNIGSTRATES.LIST><EXTARIFFDUTYHEADDETAILS.LIST> </EXTARIFFDUTYHEADDETAILS.LIST><VOUCHERTYPEPRODUCTCODES.LIST> </VOUCHERTYPEPRODUCTCODES.LIST></LEDGER></TALLYMESSAGE> | </REQUESTDATA> | </IMPORTDATA> | </BODY> | </ENVELOPE> | ||||||||||||||||||
MasterData | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| AU2:AU6,AO2:AO6 | AO2 | =B2 |
| AQ2:AQ6 | AQ2 | =F2 |
| AS2:AS6 | AS2 | =G2 |
| AW2:AW6 | AW2 | =I2 |
| AY2:AY6 | AY2 | =AO2 |
| BA2:BA6 | BA2 | =K2 |
| BC2:BC6 | BC2 | =E2 |
| BE2:BE6 | BE2 | =BC2 |
| BG2:BG6 | BG2 | =C2 |
| BI2:BI6 | BI2 | =D2 |
| BK2:BK6 | BK2 | =J2 |
| BO2:BO6 | BO2 | =L2 |
| BQ2:BQ6 | BQ2 | =AO2 |
| BS2:BS6 | BS2 | =A2 |
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| E2:E6 | List | =$W$2:$W$6 |
| C2:C6 | List | =$U$2:$U$46 |
| J2:J6 | List | =$R$2:$R$38 |
