hi guys
im looking for some help please to auto fill data into specific areas of spreadsheet based on the day
please note i have attached spreadsheet
the data in columns h:n are auto populated and sorted from another spreadhseet
so what i would like to do with a button is this ( if possible )
in h11:n16 there are 2 days that correspond to MONDAY
what i need the macro to do is move that data ( as per heading ) to mondays range which is b13:f22
column a can be ignored as this looks up column b and returns the account code
and also to do the same for corresponding days
can anyone help please?
Bookmarks