RSS Feed
TJ's Blog
Posted by TJ on Friday March 4, 2016 @ 11:53 AM
[Tags: Excel, tips, accounting]
If you manage a partnership you might need to send out individual or personalized statements showing account activity or member financial information. If you already have a table in excel with the data one of the easiest ways to make an individual statement is to add a new tab and create the statement and then add a drop down (data validation) on the statement tab to select each persons name.
To add a drop down
1) From the Data Ribbon select Data Validation
2) Select Allow "list"
3) Your source should be the list of names from the data table you are pulling information from.
Now that you have a dropdown on the statement tab you can use the formula "SUMIF" to retrieve only the specific data from your data table for the name you select from the dropdown box.
Now if you have a lot of names you might want to automate selecting each name and printing the individual statement to the pdf. The below VB Code/macro will do this as long as on your statement tab you have the dropdown in cell A1 and the filename and path in cell A2 (ex: c:/folder/)
Read More...
[Tags: Excel, tips, accounting]
If you manage a partnership you might need to send out individual or personalized statements showing account activity or member financial information. If you already have a table in excel with the data one of the easiest ways to make an individual statement is to add a new tab and create the statement and then add a drop down (data validation) on the statement tab to select each persons name.
To add a drop down
1) From the Data Ribbon select Data Validation
2) Select Allow "list"
3) Your source should be the list of names from the data table you are pulling information from.
Now that you have a dropdown on the statement tab you can use the formula "SUMIF" to retrieve only the specific data from your data table for the name you select from the dropdown box.
Now if you have a lot of names you might want to automate selecting each name and printing the individual statement to the pdf. The below VB Code/macro will do this as long as on your statement tab you have the dropdown in cell A1 and the filename and path in cell A2 (ex: c:/folder/)
Read More...
Posted by TJ on Friday February 12, 2016 @ 03:01 PM
[Tags: excel, tips, accounting]
Below are some short cuts I use almost every day in Excel when auditing worksheets in excel. There are certainly more shortcuts than I discuss below but these are certainly less commonly discussed:
Ctrl + { Press these two keys together when you are in a cell with a formulated value and Excel will bring you to the sheet and cell it got linked from. If you go nowhere that likely means the cell does not contain a formula or there were too many variables.
Ctrl + } When you use this shortcut on a value Excel will bring you to the sheet and cell where the selected cell is being used in a formula. If you go nowhere that means the cell is not used in a formula or there are too many variables.
Ctrl + ~ When you use this shortcut you can switch displaying showing formulas or values on a sheet.
< Previous Page | Next Page >
[Tags: excel, tips, accounting]
Below are some short cuts I use almost every day in Excel when auditing worksheets in excel. There are certainly more shortcuts than I discuss below but these are certainly less commonly discussed:
Ctrl + { Press these two keys together when you are in a cell with a formulated value and Excel will bring you to the sheet and cell it got linked from. If you go nowhere that likely means the cell does not contain a formula or there were too many variables.
Ctrl + } When you use this shortcut on a value Excel will bring you to the sheet and cell where the selected cell is being used in a formula. If you go nowhere that means the cell is not used in a formula or there are too many variables.
Ctrl + ~ When you use this shortcut you can switch displaying showing formulas or values on a sheet.
Posted by TJ on Friday February 5, 2016 @ 03:45 PM
[Tags: humor, status, toplist]
It is almost Superbowl Sunday so we compiled the favorite funny status message related to football the the superbowl below:
If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=nfl OR football OR superbowl.
Read More...
[Tags: humor, status, toplist]
It is almost Superbowl Sunday so we compiled the favorite funny status message related to football the the superbowl below:
If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=nfl OR football OR superbowl.
Read More...
Posted by TJ on Tuesday January 19, 2016 @ 05:38 PM
[Tags: status, humor, toplist]
Below are some funny status messages or tweets related to post when it snows. If you like these you can browse more related funny status messages here: tjshome.com/statusmessages.php?f=&o=r&q=snow OR flurries OR winter.
Read More...
[Tags: status, humor, toplist]
Below are some funny status messages or tweets related to post when it snows. If you like these you can browse more related funny status messages here: tjshome.com/statusmessages.php?f=&o=r&q=snow OR flurries OR winter.
Read More...
Posted by TJ on Sunday January 10, 2016 @ 03:23 AM
[Tags: humor, status, toplist]
Well since no one won Saturday's Powerball... below are some funny status messages or tweets related to the Powerball or the lottery.
If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php.
Read More...
[Tags: humor, status, toplist]
Well since no one won Saturday's Powerball... below are some funny status messages or tweets related to the Powerball or the lottery.
If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php.
Read More...
Posted by TJ on Saturday January 9, 2016 @ 06:25 PM
[Tags: status, tjshome, update]
Happy New Year's Guys... We just wanted to check-in and talk about messages that appear on the "Funny Status Message" page that are not funny status messages .
In order to keep the content relevant and current we allow submissions to be posted live on our website immediately. We understand that this can cause issues since the content in submissions could be offensive and not funny and not represent the content we are looking for. While we are can not possibly be on here reviewing messages in real time we try to at least check-in once a day and do some moderating. The last few days we took a vacation and that is why you seen an influx of poor status submissions that were not effectively moderated. We apologize for this and we will be checking in more frequently to help keep the content interesting.
We also rely on support from our community for moderating status message submissions as well. One thing that visitors may do when they see a poor submission is post a comment about a posts using the "Funny Status Submission" Form in response, which is counterproductive as this will only be adding to the number of poor submissions. We recommend you do the following when you see a poor status submission:
[Tags: status, tjshome, update]
Happy New Year's Guys... We just wanted to check-in and talk about messages that appear on the "Funny Status Message" page that are not funny status messages .
In order to keep the content relevant and current we allow submissions to be posted live on our website immediately. We understand that this can cause issues since the content in submissions could be offensive and not funny and not represent the content we are looking for. While we are can not possibly be on here reviewing messages in real time we try to at least check-in once a day and do some moderating. The last few days we took a vacation and that is why you seen an influx of poor status submissions that were not effectively moderated. We apologize for this and we will be checking in more frequently to help keep the content interesting.
We also rely on support from our community for moderating status message submissions as well. One thing that visitors may do when they see a poor submission is post a comment about a posts using the "Funny Status Submission" Form in response, which is counterproductive as this will only be adding to the number of poor submissions. We recommend you do the following when you see a poor status submission:
- 1) Vote the message down by click the Thumbs Down icon (
). This will help us quickly spot the poor submissions when we moderate.
- 2) If you have a comment or response regarding a submission post your comment by clicking the number in the Comments (0) indicator. Do not respond to messages using the status message submission form.
- 3) You can also contact us using the contact form: http://tjshome.com/mailto.php
Posted by TJ on Thursday September 24, 2015 @ 12:58 AM
[Tags: tjshome, update, status]
Hi All...
We recently updated the server which is running new faster PHP and MySql. If anyone is noticing any bugs please let us know. We just resolved a bug where some submissions were not getting into our database due to a query error. For those that this effected, we apologize for the error.
We also want to get your thoughts on a couple items we are thinking about implementing:
1) We are finally considering removing the outdated "X is", "X says", etc., from the beginning of all status messages.
2) We are considering adding a login so users can easily post under a username and track their messages, their thumbs up and thumbs down and comments. This will take some time and work though.
3) Also let us know if you have any other ideas
Thanks for visiting Tjshome.com.
Update 10/21/2015: We improved the search engine function. Now when you search the default is to sort by rating so you should get better results now.
Update 10/29/2015: We made additional tweaks to the search engine. You should be able to sort results and see the most recent results for your name.
Update 10/30/2015: For mobile devices we made the next page easier to hit. Let us know what you think. You will not notice a change unless you are on a mobile device.
[Tags: tjshome, update, status]
Hi All...
We recently updated the server which is running new faster PHP and MySql. If anyone is noticing any bugs please let us know. We just resolved a bug where some submissions were not getting into our database due to a query error. For those that this effected, we apologize for the error.
We also want to get your thoughts on a couple items we are thinking about implementing:
1) We are finally considering removing the outdated "X is", "X says", etc., from the beginning of all status messages.
2) We are considering adding a login so users can easily post under a username and track their messages, their thumbs up and thumbs down and comments. This will take some time and work though.
3) Also let us know if you have any other ideas
Thanks for visiting Tjshome.com.
Update 10/21/2015: We improved the search engine function. Now when you search the default is to sort by rating so you should get better results now.
Update 10/29/2015: We made additional tweaks to the search engine. You should be able to sort results and see the most recent results for your name.
Update 10/30/2015: For mobile devices we made the next page easier to hit. Let us know what you think. You will not notice a change unless you are on a mobile device.
Posted by TJ on Friday August 7, 2015 @ 04:47 PM
[Tags: toplist, status, humor]
Below are some funny status messages or tweets related to Friday. If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=Friday.
Read More...
[Tags: toplist, status, humor]
Below are some funny status messages or tweets related to Friday. If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=Friday.
Read More...
Posted by TJ on Wednesday July 22, 2015 @ 04:12 PM
[Tags: status, humor, toplist]
Below are some funny status messages or tweets related to Donald Trump. If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=trump.
Read More...
[Tags: status, humor, toplist]
Below are some funny status messages or tweets related to Donald Trump. If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=trump.
Read More...
Posted by TJ on Wednesday June 3, 2015 @ 01:38 AM
[Tags: toplist, humor, status]
[Mood: Happy]
Below are some funny status messages or tweets related to Hump Day. If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=hump day.
For those of you that do not know "Hump day" is defined as the following:
Hump Day The middle of a work week (Wednesday); used in the context of climbing a proverbial hill to get through a tough week.
Courtesy of Urban Dictionary
Read More...
[Tags: toplist, humor, status]
[Mood: Happy]
Below are some funny status messages or tweets related to Hump Day. If you like these you can browse more related funny status messages here: http://tjshome.com/statusmessages.php?f=&o=r&q=hump day.
For those of you that do not know "Hump day" is defined as the following:
Hump Day The middle of a work week (Wednesday); used in the context of climbing a proverbial hill to get through a tough week.
Courtesy of Urban Dictionary
Read More...
< Previous Page | Next Page >
Site Links
© 1999 - 2021 Tjshome.com