ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them).
I used these small macros a lot to add a daily of semi-daily logs to my daily spreadsheets, like daily weight, exercise logs, and other habits I want to track.
This macro helped in adding the new record at bottom of list then sort the list to make the newly added record at top.
You may change the order, and where to use. Just assign it to a command and enjoy.

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Boldcodes.com

Linkedin Login

Parameters

Column1, Column2, FromRow, ToRow, Optional Shee = "Active", Optional WB = "This", Optional ThenSort = 0, Optiona SortByCol = 1, Optional SortOrder = 1

Examples

Example call: ANmAdd_ThenSort_2Columns "C", "D", 6, 7, "Sheet1", "MyWb.xlsm", 1, 1, 1)

Permanenet link

Statistics

Views 321

Downloads 70

IDs

CodeID
DB ID