LinkBack URL
About LinkBacks
Trying to line-up Excel Bank Register to Excel Check register by Check number, with output showing all checks with blanks for register, as noted in the attached example. Thank you for your help.
Trying to line-up Excel Bank Register to Excel Check register by Check number, with output showing all checks with blanks for register, as noted in the attached example. Thank you for your help.
Last edited by Camtender; 01-27-2013 at 07:46 PM.
hi Camtender, welcome to the forum. so if Check number in Bank Register found in Bank Statement, then show the lines in Bank Statement, otherwise show blank? try this in G16, to be copied down & across:
=IF(COUNTIF($G$4:$G$10,$B16),VLOOKUP($B16,$G4:G$10,COLUMNS($G16:G16),0),"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi Camtender
Welcome to the Forum!
Sounds like a Bank Rec to me. Post a workbook(s) with what you have (Book File, Bank Statement File). Make certain the File(s) you post have the SAME structure as your actual files. Please replace all proprietary information if appropriate.
I've done thousands of Bank Recs, both manually and with Code...help if I can.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks