savePDF excel sheet

Code Sub SavePDF() Dim saveLocation As String Dim rng As Range saveLocation = Range("g5").Value & ".pdf" Set rng = Sheets("INVOICE").Range("A1:H30") rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:=saveLocation ActiveSheet.PrintOut preview:=True Range("g5").Value = Range("g5").Value + 1…

Continue ReadingsavePDF excel sheet

Compound Unit Exercise-2

Cash           -                  48000 SBI              -                  15000 Sundry debtors      -                  Sumit -        14000                                                  Pratik -        18000 Sundry Creditors   -                  Ganesh-      20000                                                 Kiran  -        19000…

Continue ReadingCompound Unit Exercise-2

Compound Unit Exercise- 1

Cash                              -        50000  PNB                               -        40000 Sundry debtors       -Rahul                        10000                                                            Shivam                      12000                                                              Sundry Creditors - Manoj                      2000 Loan & Liabilities-…

Continue ReadingCompound Unit Exercise- 1