XL2BB Error

[smozgur]

Something don't look right. I am new to MrExcel, and I am a beginner in excel, I apologize for not knowing how to post my question correctly.

I understand that you installed the XL2BB successfully.

All you need to do is now, selecting the actual range in the workbook that you need help with, click Mini-sheet in the XL2BB ribbon tab that will copy the selected range with the formulas, formats, etc. to the clipboard, and paste in your question post. You don't need to reveal your formulas as text as you did in the previous post. Just like below, then the helpers will be able to copy the entire range easily, including formulas - see F16 cell in the sample below, to their worksheets to provide a solution. Consider a mini-sheet as a basic worksheet that is good enough to transfer the range between the question thread and an Excel worksheet.

XL2BB v2.0.0 Demo.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Category	SubCategory	Account	Payee	Expense Amount		Categories	Sub Categories	Accounts	Payees
2	1/4/2021	Home/Rent	Lawn Mowing	Debit Card	Best Lawn Mover	85.00		Car/Auto	Electricity	Cash	Best Food
3	1/5/2021	Food/Groceries	Restaurant/Fast food	Credit Card	Nice Food	7.44		Departmental	Furniture	Credit Card	Best Lawn Mover
4	1/5/2021	Food/Groceries	Groceries	Credit Card	Supermarket	19.03		Food/Groceries	Gas/Heating	Debit Card	Electric Company
5	1/5/2021	Departmental	Furniture	Credit Card	Furniture Company	241.24		Home/Rent	Gasoline		Furniture Company
6	1/6/2021	Food/Groceries	Groceries	Credit Card	Supermarket	125.05		Utilities	Groceries		Gas Company
7	1/7/2021	Utilities	Internet	Debit Card	Phone Company	60.00			Internet		Gas Station
8	1/7/2021	Food/Groceries	Groceries	Credit Card	Supermarket	38.48			Lawn Mowing		Nice Food
9	1/12/2021	Utilities	Gas/Heating	Cash	Gas Company	41.49			Mobile		Pest Controller
10	1/17/2021	Home/Rent	Pest Control	Debit Card	Pest Controller	110.00			Pest Control		Phone Company
11	1/18/2021	Food/Groceries	Restaurant/Fast food	Cash	Best Food	16.73			Restaurant/Fast food		Supermarket
12	1/19/2021	Car/Auto	Gasoline	Credit Card	Gas Station	21.13
13	1/21/2021	Car/Auto	Gasoline	Credit Card	Gas Station	13.73
14	1/22/2021	Utilities	Mobile	Debit Card	Phone Company	75.30
15	1/25/2021	Utilities	Electricity	Debit Card	Electric Company	66.20
16	Total					920.82
Jan 2021 Expenses

Cell Formulas
Range	Formula
F16	F16	=SUBTOTAL(109,'Jan 2021 Expenses'!$F$2:$F$15)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2:F14	Cell Value	>100	text	NO
F2:F14	Cell Value	<20	text	NO

 

[GSILVA66]

Thank you so much I was able to add it to my original post correctly, would like me post here to if you could help me?

 

[smozgur]

Thank you so much I was able to add it to my original post correctly, would like me post here to if you could help me?

You did it perfectly!

No need to post here. This forum (About This Board) is not a place to post Excel Questions. It might take some time but I am sure your question will receive an answer or request for further info in order to answer your question by one of the amazing experts in the MrExcel Message Board!

One important note: Please make sure that you are not posting sensitive data with your samples, like real names, addresses, etc.

 

[GSILVA66]

Thank you for the advice.. I did post it with First names only, I didn't think about using numbers instead.