HELP Creating a Cash-book from bank data

Hello,

I'm trying to create a spreadsheet to be used by multiple departments but I am struggling on compiling the spreadsheet.
My plan is to download the data from the bank every morning into 1 sheet. (adding new data, daily below the previous days) from here there will be three columns GL, PL and SL. if a mark is put under any of the three columns which then displays that data on the relevant sheet (3 sheets called, GL, PL and SL.)

Once the data is on the sheet further columns would be added which would enable that data to be categorised further but this would be manually added so it would mean that the data couldn't 'move around' day-to-day.

Is this possible in excel and if so how could I do this please?

Hi and welcome to the forum.

Certainly sounds possible if you're willing to have VBA do all the work for you.

Attach a sample workbook (the file not a picture of one) showing what the data looks like before and after.

Make it dummy data so you don't include anything sensitive, but it must be representative data. i.e. don't show text in a column if it's really a number.

We should be able to help from there.

BSB