Hi guys, I am a relative newbie to Excel and VBA, And whilst I like to try and find my own solutions to any problems, I have to ask for help occasionally.
My current project is a betting workbook, which has lots of tools and links and records of bets made on 8 accounts I hold, on these 8 sheets, I have a simple profit/loss record of bets made for that particular account, in the last column of each sheet, column H, I have the type of bet, Either F,H,or S (football,Horses or Sports). I also have 3 separate sheets that correspond to each type of bet, what I would like to do is when I enter data in any account sheet,then depending on which bet type is entered, I would like to run some code/macro ?
that then copies that row into the sheet which corresponds to the type of bet, at the first available free row in each of the 3 sheet's. I was wondering about an "if then" scenario, but I am not sure how to go about it, I am aware that I could use pivot table sto crunch the data, however i prefer to go down this path if possible. So two questions, first can it be done, and 2,How?
Oh and Hello to everyone