I'm building a template for processing supplier billing data with the corresponding process documentation for someone else to use the template on a monthly basis. It's based on mobile phone numbers and the supplier information has multiple rows against any one mobile number, but against700 to 1200 individual mobile numbers in any one billing cycle so manual intervention just takes too much staf time. I want to know, firstly, if the things i want to automate are possible with Macro's, these being: *Macro1: *With the worksheet sorted based on the mobile phone number column, i want to run a macro to insert 2 blank rows after every group of rows that are for one mobile number, so say the mobile number is held in column K, as soon as the value in that column changes (i.e. changes to the next mobile number) insert 2 blank rows, preferable the first new row being filled in one colour and the second in another, but colouring is not too important. Would it also be possible, to have this first Macro, or maybe another one to run next, to autopopulate the new rows based on the data in the rows above, except the two financial columns, and for the 2 date columns, to use the earliest date in one column and the latest date in the other? *Macro2: *The source data contains charges against, say for example, 12 charge types, i want to add all the charges against say 8 of the 12 charge types and have this total in the first of the two inserted (maybe coloured in) rows, for every grouping of data against the same monile number *Macro3: *To add up the other, for example, 4 of the 12 charge types and have this total in the second of the inserted rows, again, for each grouping of data against the same monile number. Obviously these will take some working out, but at this stage i just want to know that i;m right in thinking that these activities are possible to automate with VBA Macros? Thanks for taking the time to read this and hopefully steer me in the right direction! Jason
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
