Creating a macro to pull data from a sheet and transpose

[Closed]
Report
Posts
2
Registration date
Tuesday December 22, 2015
Status
Member
Last seen
December 29, 2015
-
Hello,

I am working on creating a journal entry form where I can enter a 'A" for accrual and have a macro look up the "A" then create a new spreadsheet copy the information and transpose the lines. (To reverse an accrual)

I am inserting a small sniped of what the form looks like