First of thanks Guys, I have had some great help of people on here and I have learn't so much.
My latest problem is this
I have eight sheets of data,containing 7 columns and a fair few rows of data, the final column of each sheet, denotes a letter H,F,S which refers to a type of Bet, the sheets are not in table form, the are basically a record of all bets, spread over 8 separate accounts, now I have 3 more sheets, which represent the 3 types of bets I make. (I used to ask is it possible, now I know it is)
so how can I write in say sheet 1, row 40... a bet record and depending on what letter I add in the 7th column (H,F,S) that row is copied and pasted in the sheet matching the type of bet, IE/ sheet H, or sheet F, or sheet S.
hope you can help as my project is starting to look really good now.
My latest problem is this
I have eight sheets of data,containing 7 columns and a fair few rows of data, the final column of each sheet, denotes a letter H,F,S which refers to a type of Bet, the sheets are not in table form, the are basically a record of all bets, spread over 8 separate accounts, now I have 3 more sheets, which represent the 3 types of bets I make. (I used to ask is it possible, now I know it is)
so how can I write in say sheet 1, row 40... a bet record and depending on what letter I add in the 7th column (H,F,S) that row is copied and pasted in the sheet matching the type of bet, IE/ sheet H, or sheet F, or sheet S.
hope you can help as my project is starting to look really good now.