Hi Everybody / Kjbox,
Wish Kjbox are there and will help me as before.
I have been trying to create a solution. I have a worksheet Named (Bill) of a large data file. The worksheet data start from supposing A3.F103. Now I want to use a command button that creates a .xlsx file in a specific location E:\1. Upload file. The worksheet named Bill & with current date & Time.xlsx (Like Bill_01_07_2021 09_11.xlsx)
The worksheet creates with the following data:
- The First column “A” (will be named as “SL”) has an incremental number based on the worksheet “Bill” data B3 to Last data + one extra.
- The Second column “B” (Will be named as “Date”) inputs Today's date (dd /mm/ yyyy) to the last row based on the column “A”
- The Third Column “C” (will be named as “Invoice”) copied data from B3 to the last data cell (Suppose the data is available now from B3 to B103)
- The Forth column “D” (will be named as “Status”) input a text “Credit” to the last row based on the worksheet “Bill” data B3 to B103 but on the last row of the new worksheet D105 the text "Debit"
- The Fifth column “E” (will be named as “Number”) inputs a fixed value “50” to the last row based on the worksheet “Bill” data B3 to B103 but on the last row of the new worksheet D105 will be the summation of above data D2:D104 "
Can it be done by code? If yes, Please
(I have attached a file that will be the result file if the code possible)
Thanks in Advance.