I tried to assemble this myself through lurking on the forums, but it seems like its just outside my skill level right now.
I have a download that I get that shows activity for the company by Accounting Unit. With Sub Accts, Desc, Amt, and Date. I would like to try and develop a macro that copies the rows based on the Value in AcctUnit Column to the appropriate tab (the first 3 numbers in Acct Unit to match its tab) There will be times where there are multiple entries for one acctunit (rows 5&6 as example) An added bonus would be if i could get the Amount to paste in the correct columns on the corresponding tabs. Since this will be a monthly process where items do not always clear i don’t want this to paste over data that exists in the individual tabs.
I have attached a small portion of what i am working with for a better Visualization
Bookmarks