Đã hoàn thành

Write Excel macro (complex)


First Setp N/A Delete all "N/A" in this column

Second Step 1011 Copy the CHECK NUMBER to the DESC column as such "Check 1011"

Third Step TYPE Look at value (see formula in cells) If balance less than zero enter CREDIT, if balance greater than zero enter DEBIT.

Fourth Step Value Remove all minus signs from the numbers (note multiplying by -1 will NOT work).

Fifth Step TYPE Sort by this column and make two new spreadshets in this same book. One called DEBIT and another called CREDIT

Copy all CREDIT to the CREDIT tab along with the header of this sheet.

Copy all DEBIT to the DEBIT tab along with the header of this sheet.

Kĩ năng: Excel, Visual Basic

Xem nhiều hơn: macros in excel for beginners, advanced excel macros examples, excel macro function list, excel macro examples, what is macros excel, excel macro commands list, excel macros for dummies, excel macro tutorial pdf, where i hire someone to write excel macro for me, excel macro lotus notes, excel macro lotus notes send email, write excel macro sql server stored procedure, write excel macro mac, write excel macro internet, write excel macro read data pdf files

Về Bên Thuê:
( 50 nhận xét ) Katy, United States

ID dự án: #15447473

Được trao cho:

$185 USD trong 2 ngày
(172 Đánh Giá)

4 freelancer đang chào giá trung bình $190 cho công việc này

$185 USD trong 0 ngày
(566 Nhận xét)
$185 USD trong 10 ngày
(2 Nhận xét)
$205 USD trong 10 ngày
(2 Nhận xét)