I am a fractional CFO who is familiar with Power Query and its capabilities but have not been able to apply it in practice. One opportunity I see for PQ is to automate a monthly payroll entry I have to make to "close the books" for multiple clients. The client has many departments and close to...
Hello,
I would like a Macro that will look for "A" next to a journal entry and copy the items to a new worksheet within the same workbook and transpose the account numbers & Item descriptions vertically.Any help would be greatly appreciated! Thank you!
This is how the template looks...
I'm completely new with macros. I was wondering what you would need so that the information will automatically update itself onto a summary page. For example for entries on one worksheet to create a statement on another worksheet?
Example:
<tbody>
Asset Type
Description
Date
Amount
OA
Bonds...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.