Streamline Your Accounting with Billing Software in Excel for Accounting and Tax

Billing software in excel for Accounting and Tax

[Music] hello everyone the last mother a topic of Marino in when Dracon resistor either it correctly at positive feedback model analysis conditions for Megan so first of all thank you so much for that other than the main stations are not doing early our inventory car wasn't able to connect an automatic building along a sales management system routing in mortgage in England after Omar this doesn't help another girl so another topic on how to build automatic inventory building and sales management system in a single platform wonder my question Oracle functions of macro code which will develop a the cistern of them meghanadha are these ended demorgan's theorum initiation I think I developed later than expensive okay then all the best ok it's epidemic other than a demonstration start again it will take me a night apart into the moon section honor first one is talk or inventory control second one is building other the invoice section third one is sales report okay Daniela command - icons is hot or hydrogen or full visibility humanity did the Carnival regular just on the upper Laguna click it and ugly combo - this Auto hide option under and the southern wind ok no ok in a bikini or a section on darlin oka okay now until never the corner I'd say the building and sales report our respective tab like a poem and eternal yes some sales to particular in Italy I'll automatically buoy we know stock like one another as well as an Anna building section click you the Windham stock Lego and exactly care ok she shop even a auto sections are gonna initial stock report in every let's talk will put on even a cardigan ok for example your sustaining emblem endure an angler antenna vendor the English respective stock details you would insert a the money okay the correcting will Amaka date item code product name HSN sack a little tax related code on GST writer respective product against lvsd percent original unit price and quantity ok boom even die any future lineal Adygea angular that the involve a little pasta see that the adding Gilliam product inside they are angling equivalent that's / - you dated ah I think what created other than a product name and just of the items they just said oh more popos in unity Corsi propensity tool okay second one is current inventory report otherwise and what is solve them with divination really posted building now mocking inventor in even March aniconic another for example is same item code and product inning and copy pasted into them but shaky then the colossal a the quantity of status a form line will done replicator gonna if I wanna sectional in buildings of the formula right with a cardigan ISM I'm not particular example a beam back for you either with I'm not sold leader just turn copy building like a boon yeah name a little section Le Poisson prospective customers Altoona m'kay furniture just selected under the net mk4 some come full details of equity I think over a co PG loop and pocketed it assumes you already written your invoice sexually with net automatic details in rational yeah indeed a light and burner you know topical gumo okay how many quantity never turned it I presume and read it you so in the program normally inventory on Amata can read uncle so go back to stock section okay Lou Brock on beam back become eighty right adult Inanna walk in a productive type is another you have no matter what every flip down to them okay next time status or the product in dole leg are Nikita movie put him a tea product balance in other one and I available gonnigan uh for example any beaten back even a hundred in the table so stock status out of strawberry okay next turn stock alert other reorder point in England thirty-two econo Auto provide for example here beanbag with eighty I attend England place oto melara to Carnegie ok other wall of the network sorry Soph orbited to Indiana glue other than I gotta go okay something able to manually cabinet alert IPM it in the car twenty-nine lucky see automatically yes the gunship Cano below thirteen sorry so that means out of the auto Chiana Anil already got again okay so even their impact and a piety graphical mannequin just to the colon selected instead will build and graphene in the select area and then just turn the but a demo purpose and when it start and sit in the box on clear whether I stock section below them so next turn building or invoice section the key K the Rinnegan rocker the already answer to the which down list of and randomly Peniel argued in a database or a key business database already a sheet with the height at which time it's not hung here in English but English itself generation by a click here and yes you unhide an optional click here in Italy customer database in lasheeda hydrogen application automatically well no not a list of customer random met in City then just on the high day you know okay but overall respect you custom select table of the day the ITIL and detail same time generator see ok other shape Tom Kyte uncoated they would I insert an oddity okay but are getting you look manually she to the quality coach agario low anonymous petite customers name is select a of the nine a bottle details generator she asian sales tape industry it's a narrow and angular say states say normal select a amber - yeah just don't need the eternal deity you know you completed leave now Sheila the former I can build on complete black on you see I didn't go to mother till you tell them and Condit you okay for example yeah no but every item quote over IV into distance ad them and make it too okay so I gonna total 3400 let's disco 19 percentage so number going to discount Amata to 10 percent Erica so 3 0 6 0 what is d40 it economy this industry turned on you have the state like a watch in England Ghana see just liquidy silicone converted the bowler to 0 2 0 4 okay shipping handling again yourself manually number changing but don't for example make it 300 grand wrote another clear any write 0 1 by 1 over new invoice number for example 1 zero Niner so next to vendor the 1 1 0 right but just new invoice click it will connect automatically 1 1 0 gamma so what do a click gear there will one next one 1 2 right we save data so there the overall invoice again assume any key sales to put a bearish if like automatically say with them ok for example am it in the car ok name m'kay furniture item code same coffee I do sure one okay 2004 okay you better 11:6 our last transaction okay building lady I say you data proceed click sales report see everyone ok just to know go back to building section in you are to the vernacular new invoice and occasionally a determinant any particular movie other than any kids or PDF file keeping your invoice no future of France a minute okay overall single guy nation but the money's safe we deftly caved nothing and Yan already your desktop will fold and I kinder okay see PDFs monitor a lake automatically generate another car now save PDF click a them okay - I respect you for to like o invoice PDF but Icona one one to see okay they have done a sales report just a sales report click on each sales to other the overall seal candidate show I'm gonna save data in certain ratio he or she really automatically battle what a sales report economy for example work on a list of customer sales tape state IG SD n equals P to customers in a selfie for example or furniture Walker the Mundy's drop-down click you popular from Mitchell mother of 17 okay see total for sale on on the total same bandwidth right other than a particular day to three month eternal and go to date and you could just in the April meemaw through my window select either okay proceed see you die totally 3 sale on total value for some this she darted through da time and I mean Satya murti other Walter a New Yorker for example state wisely I don't think you do Kerala bathroom are you okay with aluminum total 8 Ceylon total value within the function of mother well they're hanging on a form line said in a detail and in expenses are okay doesn't go back to building section next it lasting stock we only have the part of all that there's no hyperlink go to the on click is earning a stock intersection at the clear done overall let's talk Billy and sales report in Amica engineer to build up with a little mocha okay put the a sheet like a same not earning and copies T though but already karna so within the modeling and designing theme of a Camilla and other old timey invest Ivan illa then gonna develop whether the clear-eyed in the granita okay but I gonna stock building sales report customer database right I've got a list of meteors yeah course shamanic parabola items about organic another other than that he currently invented a report you same access to talk and in system the copy/paste am abhi baaki were they on a formal built up in the condom you were a Anna invoices show the initiation Stokely when the Martin reflect another ion Allah you section status area out of stock are not available to you are emulated I will then stock a lit right to your point of play sort via so no Lana community so no mechanic article made a moon at the night it'll be Mac Rhonda Shear a role of a Ronaldo you but a development in a tab insert a no are they enabling English is staring you look tablet or click Kia I click customize Ripper but econo customized repair your main tabs in other developer optional I just don't think we yeah ok boy when I our developer Nala a typo density and underline I eat Gordon Allah your group Laguna macros in them okay I've um Elsa to do in a back to stock Camila has actually Guerra so young have the water bowl a quantity little called anemic in uniform and sit in little mocha okay so aren't then anomalies in the summer gonna exit since is only is equal to some if Open bracket range you you know you didn't a syntax such you can another engine range is another I'm gonna existing item code or they actively more button code are selected above initial stock in a section to monitor your like energy company it's a little rather item code core module nine M&A arrangin loggia loci in the purpose no mana they will explain you the other one de + f4 see but low-key do put a dollar sign in city they're gonna lie sure but she's in a coma next we're gonna criteria and related in the item code on he first cellulite in Gordon select area window coma next is some rage some rage of this channel and I'm the existing quantity and chillness someone are together right other wanna initial stock section and we're a column G run and recorded Dean complete select area shishah window f4 procedure cross the bracket tender given up 100 in the Carnegie I gonna write this w key though the other one for example yarn over that 18 are clinically how would I eat even reflective right tonight 1913 when I Indian woman okay I just want what do you know actually I'm gonna purpose of the law for the purpose onthe what he invoices sure that she maintained everything back to you know no other one but a formula continued you know your formula section Lacovara - we into some if Open bracket building nila section Lacovara you what I gonna heat them corner la your section right complete select here that's the day I met there again I'm gonna have to Cheetos and first initial to do this but he needs to stock in an order and then you minus a into the I'm like invoicing item corn no matter okay window F for comma criteria back to stock criteria criteria select evil kamma go back to building section again after Judy than than some bridge euro invoices and Agana quantity resection complete solitaire V into f4 close the bracket under okay but a formal apology though me I just don't drag in appended a completely clear you had a formula in building Needham back to nine section of makan Shira and you know okay next one status status of the genome the Maki the status um when he woke up yeah but a quartic another zero on angular out of Stockholm other lengthily in stock like available to be gonnigan other one you seek l2 if open bracket your sill is equal to 0 comma put double quote Liliana mokuba and a status in that texted another in the text room double quote run insert a no they would at a pair money pool another out of stock double core so close with double quote the guy yet other in Lingle or a comma to available I wonder double code window just on available type is Emily a very level and closely double quote and close the bracket vendor available and system drag don't you yeah manually near 100 and Ruthenian just zero did you see automatically out of stock one okay you know give them don't bring in and cannot change he a little available on in green curriculum and how to stop an incredibly gonnigan it's very simple I'm giving you the column of a particular company itself dear for example a complete column select thiru shisha go to home condition formatting highlight cell rules text that contains at leave that in English you section below the McKay first to text and agenda available on angry if I rebel on and you'll either love mechanic and doesn't drop gangaiah grab by default light red fill with dark red text now and I don't have the already got a killer I never green filled with dark green text like you do okay see ya uni at the condition out of stock unaccredited on regarding complete select either window condition formatting highlight cell rules text that contains that texture type you know of stock so they cannot spilling in current Daniel caps regular you go under the light red with dark red text by default Allah then I could okay yeah just one see you what you see out of stuff other well then it is one not issue available never condition zero owning you Mark ran out of stock of a total diameter okay I just don't need formal I just don't know coffee BC the way you have to manually type is on the formula every site children okay enhancer stock alert neo slogan for example any Jesus penny stock but at any point at the Italian iconic you know or to place you know handle it for example random record O'Connor your first ng product around twenty County idling any color to the room okay mark you like it 10 10 and 10 but the only place order is solo kinda community only again if condition play unicorn is equal to if Open bracket existing quantity is less than reorder point count it electronic in the reorder point it 20 okay he said I think on decorum on angular nextdoor place he nodded to Garnica Naruto so coma start with double court yes rather Auto place your time I drilled another it's closed with double quote coma add a link below no loss with double quote loss the bracket just a drag don't you know you lost a little bit of a pickle light okay the same way number condition 400 worker complete select you do good home condition formatting highlight cell rules text that contains yes a default of any comes on they become red color okay other Lincoln a complete selective condition for money again highlight cell rules X that contains if it's no we do in color Lorca selective okay see before example nanny right encode this one copy do I think good insane Peru and quantity rate defines of you end up okay in stock session boyacá see even current you 15 quantity imbalance which is still available right Cano if it's the condition the zero I am male out of so conical but she fit among coup place the order less than 28 with the quantity clear so next turn insert graph insert graph in detail at advanced level in here we're gonna play least route another protein ID game it'll just a simple IQ Panera in Kerala graph is Dylan Saturday I am Bertram it's very simple Wrexham Lama he completed Ottoman down here again recog a went to the item go to court each Indian a status on ie represented a charter through when he calls the item code in a range complete select you do she should control key presses every yeah but Condit you sell it here so after that good in sit but econo your chart into the group number right otherwise it'll a shadow select you yeah but I just don't select you know you know 3d content icon select you see so now I'm currently the design money change yeah but I can design section the key though so now for example you cabinet under 50 economy see not America Jeff I was that tableau see clear so just on the tag don't you know the title okay so in general formula is my pledge you know this is dragged on 0 complete okay so your existing quantity or the sale initiation angle in a bath you can unlock up there the invoice issued the initiation okay so next on building like invoice session the already general just a template in bakasana so the are coding is a build-a-bear okay but iconic company details system or name address t pin code phone number invoice number date other than version a date GST a customer energy is numerological although than a sales table right in the street are no States sailor you know okay new tile a nice patina dings own in Korea item code product name HSN score tax rate unit price quantity grows some on a net amount so you better grow some on net amount of the dish you know the the number I tack Salmonella immoral net amount accentuation customer page you know and what okay as well there was a glow someone they did a total Agana Bertram chasm discount after discount buckle a bow section one first to sell it the easiest in amount of reflect down yeah formula applies in the garnet serum I just do this the industry its same with another next to another number see GST and they don't wanna seeee stst states a little wrong okay last one is shipping and handling and granddaughter but the never end of the it would have customer details automatically an F Papa for local so even I type in the moon and I'm gonna customer database keeping the majority of mini keepin on existing customers and details angular well then good but so pretty she's in your customer database in and I have the Heidi this of all the customer does that is right randomly and this donor builds up a long name or address state a pin code with contact number DHT I am okay even a section let me where near walking the stammering killing you to view customer on angle out of the store custom that if it's a dilemma okay one angle order we may ready and I am it too than further details and they were to a damn it okay I won't believe section Laguna unique name section even at number rather than that I'm gonna drop down list okay Erica mechanical dog down list in the air column and read IP yeah yeah what a drop-down list of the air comes in on a Sierra so I'm okay on top down going to the order cursor position here section level Jason go to doctor data validation DQ gonna list a pair of kiddo customer database they accompany it's a little down arrow and okay back on list of customer right in against Atalanta status automatically a polka polka other new big enough on ground on vlookup so any symbol you see Cal to we look up open bracket lookup value this one enamel array appears in the selected comma table array custom database Liverpool names rec Tia till address several dozen open upon them on lookup value every an allure in the mocha know the address on Okinawa one two right comma 2 comma 0 plus the bracket but I can make an EU Canada empty on but one day I just don't need insula to go for Misha point C along Bank classic traders Trishula in case yeah blank selectable na Nana pioneering ironically in came T Hanukkah so the one they wield uniformity teen intermix in the cursor place you know formal ADT Hanover dynamic are a formidable together a secret organization if error an error an angle that will be you know open bracket it to end Oliveira comma mg well double-quote double-quote are the empty never connect another okay and I the area we're adding Lee emptying oregano error on the garlic is not put okay close the bracket enter see Indiana a one furnitures and at you do empties everything the typically what empty okay other than a state sequel to we look up open bracket look up value name coma customer database one two three third cocktail a state-level comma 3 comma 0 cos T bracket and they can even over time I want the intermediate in each error coma double quote closing bracket yeah would I eat formula build up even the naive fervor start hearing a confusion I only yesterday the one I be looking for Ganesha for example down shallow center ok same way P she killed two we look up open bracket look up a new name coma customer database and pin code is fourth one comma 4 comma 0 close the bracket under he n and carrion convened formally did you know if error double click enter a coma double quote double quote close the bracket and for number is equal to V lookup open bracket and cap value name customer database and contact number 51 5 comma 0 again editing if error coma double quote frosty bracket enter invoice number invoice number a additionally the even number loop start a inverter okay now for for time being a reporter leave a new column but sale happen to you once at a yeah okay next is date is equal to today sister than a they turn open bracket and cross the bracket see today's date and reflective next is the HD number already database lender other one between do we look up name coma customer database complete select we do it to in denied to last applies 6 the Quran comma 6 comma 0 pasta bracket ready to you know if error kkoma double coat frosting bracket sales tape redundant theorem seen step out of the interstate to other wall that I state sales so a euro section number drop-down list in Dhaka okay everyone I've ended up closer please you put data data validation list the source Lord I manually done good idea state save coma in the street see okay states in Oman in the state to say one for K pursue you drop until economist HC alike in the state say okay in a Drama year section fill appear same method on an American ship for example writing code instead of automatically make in cellular details Papapa okay but I didn't go to run diesel - yeah me too onaji drop-down list and I'm gonna manually you have to put a friend of the manual economy prop down list which it in English the huge item distant English what are they put them to search here other were the best ways manual insert okay so number of die inside a book automatically regenerate down and Megara matter other than one dynamic enough formula here in mocha so normally would have a just say method another de platino we look up if formula functions okay product name is equal to we look up look up value this one coma stocks aluminum right reduce a complete around city the right but I gonna eat in each the stock report on the Mullen aye ting good and product name is second one so two comma 2 comma 0 close the bracket and and they can you know you were to empty on in case you have and Emily right then for some to you copy and insert see a chair on other than over items of whatever effect down the column okay in case is the DVD the Navy and they don't know and after one over either remove on England just to never if paronella formula appreciate Emily its error and Alera double coat and prostatic same way then Anna Boch you love them okay and this will insert do you know say kill - we look up don't drag it stalk HSN sad code is third 1 comma 3 comma 0 close the bracket we do BD teen is error comma double quote prosper tax rate sequel to vlookup I took four coma and GST rate comma 4 comma 0 if error coma Apple coach across the racket and you need price is equal to we look up a top coat and go back here and you price is fixed to 1 comma 5 comma 0 and if comma quantity section of the binary insert a nun okay gross amount so close someone of this user before tax of neck terminal after tax of this you know that okay you cunningly the hitting so the one thing right lady really the customers inverter okay so any other item for would answer do you know some cabinet copy though and bill it's actually gone and paste it see complete it is regenerated any quantity to pursue Judas you he cross amount is equal to 2 into unit price enter share some nectar on already including tax is equal to this 1 plus again this one in to 12% a she entered so seven eight five zero on either the net amount okay so any any I didn't go to delete a little in hiragana quantity would I go along that is the manner it said I don't identity though but she still another value Adama same function that I would apply yeah so they wanted us produced Silla sell Kia go here if error open bracket and deliver a coma double code cross the brackets same where net terminal section if error open bracket in the ER and coma double court closing bracket okay uni bar killer silicon omeka either place you know for the one day our respective cells can be there in select area dragged on children each section this interact on chair okay in an external gross amount rather a little tax in a manila total value sickle to some open bracket so you cross someone like your ing complete select area and close the bracket okay discount specific discount and angular number caliber didn't say it again person anyways level you know before tax in ammonia and is convertible okay about either manually she notices some believe in after discount is equal to Ross amount - a game gross amount into this conversation and for example yeah nobody 100th a pillow automatic hundred will no discount of 10% internal balance ninety clear just really clean oh okay so next turn over that I GST see GST it's the a c-section so is in the form and already and build a denied in the reflection on a monitor for example yarn over the state seal the power industry itself to you but automatically gonna I need stability of them right again in the schedule of the state seal sorry but I gotta see GST sthe border much is about i invisible i NAIA moon silly ability then gain and built up with Cara given any given under the interstate ignored ingly ie GST in a little for town so even in any functions of legitimate hakuna is equal to if Open bracket logical test rather is cellular level is equal to double code in the state say that each cell value in the state kinda Keanu Gill coma you had a third eye GST in the cardigan we're gonna itst defin code again coma other language in case college it in Lingle it whether States sailor I gotta can relate just a little bland iconic can close the bracket and you would have planned I can't you can overstate sarahpearl near Interstate cell to see you but I just did it flat even the same way you saloon next out of the seldom an estate sale and angle C GST is the esteem kana kanum okay you see kill to if Open bracket logical test the cell is is equal to double quote state sale double quote comma the other particular sale estate sale Akari gala killing you would reflect our under the years in different down to that see GST then we'll coat other leg low comma black close the bracket same way if I can again be sequel to if this cell is is equal to double court state sale double coat comma around angular ISA Liliana Canada double coat is GST close double quote other link below coma double quote where the black closely bracket so with a blank card again got no you would I in the state i jst gonna a little then state sales and if a little niggly I just avoided see GST missed you prefer by clear you know mocha never to a moment ago to reflect on the mocha okay for example first Internet industry trade again the state means state two states about even acting ever gone order i jst she then again settle of value in uniform formula to loca okay are uniformly will double then explain Kira you see can do if bracket the cell that means I 28 is equal to blank black but a formula da-da-da-da-da he's a little value and tiana kill em jericho jerusalem empty Erica no Martha okay either but states is the blank item of course other leg you know ironic idea ste one little niggly so I'm against a tool a value in a formula through in Anoka okay comma open bracket some again open bracket in a term under AG completes an idea and close the bracket minus against some open bracket cross some on range and close the bracket and close the bracket again again close the bracket remove the bracket away and I don't move the bracket already operate the children would have movement of it and end up okay see id est if it I already formula build up a little bit even a little item code would insert a multiple give it a pasty those enter see quantity to die pillow-talk load ahead of the gross amount 5400 discount earning 10% later for eight seven six zero the IDS yong-sun five six dilemma community okay even I am Nance I can't shoot a formula I'm gonna check into the net amount in the number to grow someone who might say the neck like actual tax figures will do okay other f3 are no other character digestive full of more iconically in next to another see GST miss G is Jim divided in the bowl of other the central government like own statement Milliken is in the half fight okay now mark of a mineral no car so the same way in equivalent CGS team is CSU Dana reflect Jana no car okay if it is still 100% on England even at 50% a 50-person I go divided the worker okay opinion it for my in sodium any o is equal to if open bracket this cell that means I turned in an e cell is equal to black blank on angle blank iconic errata again blank comma open bracket some again open bracket number ITA stick it under these same functions on Oggie with your salah the end delay / - no more a little net amount range close the bracket - against some open bracket gross amount range close the bracket again close the bracket / - and close the bracket and okay so if I were to see just in the phone will didn't other will deny SDS ting good I'm Kimberly ax is equal to if open bracket this cell that means SDS in the Solana I 30 of an original idea T is equal to blank blank are nickel comma blank I gotta get home again coma other lingual open brackets some again open bracket net the moon range close the bracket minus some open bracket again draw some one range close the brackets again close the bracket divide by 2 and + delete close the brackets cannot even turn the bracket over angle but only opportunity the bracket main bracket doing some minimal know what I wanted but then the bracket closed 0 / 2 equation closely and or bracket okay end up any other am onto the flat round of mocha okay in the statement the other wonder if it already exists you got at you you had a sales tape Madame Du Bois in the steel is no state sales Lily as you can see please 78 378 total 956 wait in it next are shipping and handling the manual recurring distance will be transitioning in sepia one hundred by a hundred grand total it's really easy it's equal to some Open bracket after discount on the La Silla written in de very silicate Emily lost the racket see they give total amount custom was supposed to be clear in Epson lay sectioning at come on English still in the customizer yeah this was a Meridian city the morning back because of a special remarks whenever little payment terms worker okay either the LRU Clara in wishes kill Arthur number two very interesting topic or not Makoto I Indiana they automatically printed automatically PDF I say we're automatically invoice reported sales reported transfer yeah I'm kicking out of okay so Arthur and Emma cover of macro combe o row buttons great you know so even at a sample buttons is symbol bailing an accreta dijanna Sarah go to insert better I'll distractions that Ghana shapes right so every day are rectangular in facility do so even MTC lot of cursor which you drag either and we still as ice and I said bracket it cursor Lucy yeah okay order button great deal so I think I've got then it could be real great you know just if I click gear animal they should it itself for example print invoice okay so now mechanically just on the alignment exert a got good to home and make it center so initiation in sizing greasy yeah in the design mode traffic a tourniquet formatting option to order so then it colors what fill shape under the shape or plane in the chronically 3d level and I need people I become the selector you'll see the main part is he already created which you just hide it which is on the oricon Geneva consists around on is she done the son head in unhide see I know but does create YouTube if they need macro ideally specific oh right link here for system new invoice so here button the popos initial the most racially neonics pages on so the one thing in a developed is mocha okay so and then I wonder the go to Developer tab click on visual basic back are empty cell the word of tender platform omen Microsoft we shall be sick for applications with VB and over here okay then I buddy detail I'd yam for the playlist written back Amanda wish I'm a chronometer Liliana in detail a editor okay so he didn't systems to this young be in another so antenna Vanderbilt ance a rainbow go to insert a kind of modules right sanitation sub sub position subroutine on in a full form space general does it appear in a macro for example the new invoice early but macro appear in Dragon book so they gasp a Sapodilla I'm only an new invoice in the type will I wished entered students that I were to offer and close number at econo other words an end subroutine in Kenora so even dead we do learn another code create into the the new in verse in the Quran range open bracket and put into a cell reference the cell reference with this you know that nobody enjoys number in the cell a record the terminal but it's not drag you didn't know that can lead number mean in Excel see to Ghana in verse number one de mallorca correct at was s9 on sale laptops okay just not you know he be even though sure sure double code h9 we don't close the bracket dot value is equal to range open bracket again the blue coat h9 close with the blue code cross the bracket dot value plus one proper into the ear arrange about the a channeler place slit only I don't use them on the bone well I wonder they're not two one two one two three or SFI she knows okay so you would record a creative area okay now moving around over mocha okay now to simultaneously for examining screen I'm just took that they would you do invoice number cell number calculated city which anyway Nina or green color the orange button macro and they alga Paulo de Lima greater name by to shortcut key we care about the new button sell you that jmburton pushy but I mean I could test in unity comes here yeah all right frosty to the c 2i 3i I deliver for i5y in a year recording engineering University button I attach this is Rosie who invoicing right click a mouse in there but I kind of a same Makarov clicking but I got number like yeah I knew universal background appeared click here okay that that you do you need to click anomaly see automata 6 7 8 9 bucks able to challenge a mono Mario para a previous history of ivory but I didn't go to moon energy generated to the inverse tomorrow for example but at another invoice yeah that or a majestic furnish and select you do product okay in your new invoice at 0 in England see lovin over tomorrow but shabak you move the clay around the lab but you can technically Raymond for the wounded we don't know the detail and are coded no king in a locker macro lockira new invoice edit so maybe even double no not at the core area and carving render than ever take a no clear end in LA and then name section of that your section b 9m other yonder stability in the bar Columbia but DNA no math on bow that I already oh just river devera at the Quran range open bracket double quote d9 double quote close the bracket dot clear content ok in a mucuna for example me on the minimize 0 for a selected class furniture sure yeah Iran I am debone and able a vanilla too low whatever the Nike classical a completely address were complete bility see when you to alloy buckle MJ next 39 Shea other work the net your item could delete you know sure your corn its intersection with it you know you're ing complete got a bottle above the bow elegant eyetality then automatically back you to the Delete icon quantity winner ever man you ready cuz know each another word I know okay so same just don't either copy paste you know go beat and copied some key item code in the column ranging in Anoka there is out it is ill around right there see 40:32 see 24 way round but I got Palamon arranged over tacacá see 14 column see turn your toe okay same way quantity section of quantity select start in H 49 H 1400 H 24 we're about the Wonder H 14 : h 24 okay in Jana just to no-name insanity is no custom name Shama okay over ten quantity so but a thirteen are not present in voice you know the closer you okay janna code already in words but tonight attached is another one a of the clicky turning automatically clear around click either completely 49 new invoice looking for three night clear in external save data either number inserted the complete invoice details automatically sales report on the Mike she like randomly and could say mu nu H Adama you would have one by one again no coming in are a little more calm okay yes you shall go to developer so even I have already buttons created a suit under so go to developer and record on go to developer we shall be sick so you would have been tangling with a thin and island you got a through middle PT I am gonna just don't say module and titrate you know subroutine space see better okay enter your end I would have been able to do laying on the ground is a predicate okay the number two moon and say new invoice in the code on okay so give it a again the coroner so the yeah D D means dimensions last row as long okay and again deep space SH s worksheet so we ble with my most interesting bottom and set s H is equal to sheets open bracket double quote initiation index Eliza nobody the object is not even I hope did a bit of schita but she do this you know they I'm ready the sheet like all and I'm gonna copy handle all of this so if it I gotta get a sales report along I'm gonna save the report yeah plus with double coat close the bracket and the last row is equal to s such dot range open bracket double quote a double quote they in addition to that note is a supporter in luck column either you wouldn't start in first at a time okay and Rose dot count close the bracket dot end open bracket Excel up close the bracket rope plus one ender so even upper in the ear she listens to polish it lick call me along the start either the above one by one only widening plus 1 the next logical number at a lotta copies in the reason I call it either okay anomaly next decoded again dominant number me enough said he can the but particular Sheetal I dotted on I'm gonna cope you know that the building Wilma she didn't know a little a specific cell number linkie cell address Monica unit our cellular friends in lab data sales support Allah either corn silicon for no other column a lack of beer account for example but econo tales to put data refers to another day to the column era I should be leaning Ocampo art eight in the mother cell phone from cheat and nam OU k BG turn in a couple hope other already noted O'Connor okay even a macaque coded again s such Note range open bracket that will quote a close the double quote and last row close the bracket dot value you see can do range open bracket double quote in your December offensive a mocha or the other he left said rely section the word another as such range of this you know the number of sales to piranha I said yes such as a sheet sales report right above each section like column a Leonid Archer number ten is Selena and another let the building lie is selling I've done a lot so nobody's section the word another sales report of ear I said yesterday mana session over the building recession I'm gonna work of a strip column a live and Rodarte would not even be another say it's reporting like a a the data that it date you know the first day of my line wasn't building in dating I enjoyed our date in the cellar from stronger each day to the listeners I done now is I then insert a double quote cross with bracket and dot value clear here are never have first ion so you date liquid a diet of another invoice in the ceiling light then the left cell reference in that River okay so other words then I come up from Ezra heading in the maka Nate invoice customer name sales tapes tape the edges to CGC hdhd investor total but nine eight things in the app okay this one Co PP shield about this day time you stay in time already I'm gonna do two three four five six seven eight nine okay and I will be just doing a sales report section real life equality endeavor friends from other wallet than a building sectional seller from squirrel family first again you have a session on sales reporting line invoice number be rather than write for that would be when I type we do not see we gonna invoice number ah be lingula invoice number every on your sender from saw h9 and just type it again state yeah Alton I see Nestor dh10 Thai okay toddler are you around the column right said Laura Salveson oka in it see let you see Linda Mae idea one of the customer name customer billing section with a custom name but have a benign I don't know that this sort of cursive lacy do I don't the other d9 insert a row be nice okay next is sales supertyphoon seal State Part D live another sales tape over to mocha you would have it I 12:1 so you diane i tool insert a believer even state and billing know come up stated elegant you rather well d lemon level so d 11 you would insert we do okay in next sales report Bua column a fuller idea to another so building in it in cellular knock idea ste I just didn't love every j28 Donna so next is j28 I've done a column G column G C GST another so go back to Billy c est value here sail along and then the j29 are so jay29 okay same way it shilada s GST of the building sectional avoid entangling but econo j13 and another so if it is j13 instead you know so final one sales report I yield another invoice total Donna so grant out omocha j32 one i KN stated j 32 instead we do okay so either on a saved at and a complete code so the number of the testes oh come as it's done the mean in my shadow shame her name insert a row okay item code chair her to copy n paste it and quantity make it three so number two karna last the sales to put it on the 17-6 son 1 1 2 into voice number Union latest invoice number I 15 yawn transfer me to prove you she plugin so the mundaneum viendo BB screen like we will know this was clean on the dragged on children in there to give it a grant button Latino Run button never gets to move information okay put him on the table sales to put a moment I save it I gonna complete information under SPT 100 in the thigh generative isn't clear you have our customers empty no m'kay okay inverse numbers in dhianeila other well up tonight I 10 core fvo five six on for okay it's cabinet quantity - okay it's same way I'm like is it again or thematically how degenerate in the corner okay so neon II saved I've done my code again button the billing game on the pool by clicking you know button I say macro save data okay yeah in external print invoice very simple coroner so go to Developer tab we shall be sick subroutine space print invoice and ER okay supply diagram needle ing severe active window dot selected sheet the Tia don't bring out that's it and those you do so he printed voice in Lumberton a particular co-writer attach even a same macro and bring in voice okay implicate an England printing started okay in external save PDF where the order inverse issue in the issue just for future reference I'm gonna say with over and them on that yeah just some desktop early or for the great you know new PDF okay shisha new or dynamic on the Mac or would call you the a coordinated t the more thermally pretty simple Stefano I'm gonna render the ECP DSL apart in order right-click here sure click on assign macro but I got a macaroni within a macaroni another one to save PDF snow but Apple to macaroni okay sure good cord start yeah the code okay say video for no and I'm gonna kill shirt cut to give an equal to that the option on this solution on the epical can only laugh okay say but I gonna stop recording on the already start is or the career so now the complete select arrow go to file and save as desktop Louie and the PDF smile for like a ceviche another right but I cannot do justice empty room sir you better save as Stabler so you can doesn't give it a PDF select in yeah sure Tiger optimize for a moon option and the file additionally options now click it and England you have gone on selection select is the morrow node is selected again to the both on the selection area Malta their own solution okay and save it okay Association come back here stop recording me a nice ap definitely' button I'll link it on the desk located in England click it'll automatically see where they got PDF you see Akshay but I share your challenge ended horizon number line II next in verse starts in English number already save again MLB Placerville butshe any could put the invoice you Peter salgo down the overall file name written particular invoice number ah but the one dynamic on the ear coded I DT and for that put your macros but I cannot see PDFs written English number even have to record it back and lower key the coding another you were to share your editing with handle it's very simple even a car a dot PDF number they the college Ottoman dot PDF right and the Peconic dr. Ned PDF for today just over Salinas telethia put a car not PDF / you never select a yeah ok sure little yeah in a PDF / you would have double quote / no in the dead canary Chia and sheets Open bracket a letter come that would come on to the auto invoice no file and he might invoice number overgrown podium I invoice number aired on easy street level Monica a nobody invoice love the name like billing and she'd run so if I open bracket double quotes building close with double quote close the brackets dot fini para in Chicago in cell number another every ro invoice number garlic in the cell reference or the evidence a together so even at its Niner so you know the blue coat it's my clothes will double quote close the brackets and dot value okay I say yes so the closer you know okay any Issei Pearson another Union the same save PDF I'm gonna cover what I can 16 right in other world Anna for example yeah new invoice will kill 79 a one other than a particular stock number hope you do okay quantity one we never say PDF link either 79 i right no come on it'll go see some d1 clear it will last an internal of the room hyperlink out for example you click a little niggly automatically sheet lady with no okay but other word a button regeneration right click here but a ghana link then we will do it the insert hyperlink them place in the same documents rather you document then either she's like iron to the level so even a sales report on the moon like in sales report select yeah you'd like well okay per se so in the key turning automatically you report nothing right so about the stock right you give you know link place the same document stock okay so see them t okay same way now anybody create here so go to insert illustrations shapes whatever Tangela sylheti an initial a ship's ilithyia that time sell t do drag either do so any code number no other word this is the select area copy and paste it okay never idea that respect to you link like another code family for example from edit button a key okay building Giroux and right-click we do and linked with place in this document building okay so the perceived and again a section like a boy okay same way nom okay through chamber to link with sales reported okay mium what i it to last module i sales reporting an avocado mocha it's very easy then the major portion number only cover python code to throwing another put generate a and wasn't saved Agana never the course charity no okay net the copy that you have this ability this honor so you know anthony achieve another tab would only create user accounts same format Allah okay just open science telephone to to just make it then you mean a building in them automatically copy mmm same format and I would have I didn't you okay so you better gonna count and total sale you know the delete II you know okay if I died criteria Kahanamoku don't cry tears account it runs well the total stay at home this summer good number it's very easy but a cursor worker is equal to subtotal open bracket but I got a list of functions other number commander karana they're just in the cliff key account down another kind of to Aaron Ghanim second and counter representing another coma Association total value under low or the complete Celica Eva died radar gender complete select area station close the bracket boom monogram total ten transactional just says she's gonna return transaction same way is equal to subtotal open bracket some some represent a number nine Anna I'm covering number 9 manually enter a name coma range can be self - yeah close the bracket see here show me hitting complicit a TIA a fourth rola go to data and filter it your drop-down icon Amano in a mechanically for example sales table state sales of Moreno state seals procedure I'll get under the moon total value of 3 so just to run filter you know in next that's petty customer for example majestic nice taken earlier and the sale in diet or low okay so number gets transit criteria quota - is result in Raytown Jim so they were at the along clear enemy shows you know and then go down to Clara frictional angle and a comment box Laura otherwise any templating in composition angular each session to feedback in a course and in England melee dimension zero and then practice is Oka all the best and thank you