Related Posts
Additional Posts in Excel Genius
why is index match superior to vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
why is index match superior to vlookup?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Scan your QR code to download
Fishbowl app on your mobile
CTRL+q to trigger activeworkbook.sheets(1).select
Simple but so handy sometimes
Another helpful one can be having a shortcut to save as the current file with the current date in the file name to version it
I use a macro that will clear the sample data from a template, populate several worksheets in the template with pbc data, and delete worksheets and columns that don’t apply. Then, after classifying data in the template to complete the calculations, I use another macro to delete additional worksheets and columns to create a client deliverable version of the template.
Mentor
TTS
Anyone have the plug in avail?