Hello there - I am reasonably proficient in basic Excel, but before this week have never tried anything with macros. I'm struggling with some of the terminology and feel like I am below the bottom step of the macro proficiency ladder and unable to see onto it!
I am trying to do a monitoring sheet for work, where there may be nil to several dozen items to be listed after a particular action has been taken. The first 8 fields list parts of the action, the ninth is the count of how many follow ups are needed.
i.e. A-H are identifying fields, I is a number usually between 0 and say 24. Columns after that will be the details of the follow up actions. I will probably be auto-transferring those sections onto another sheet, but have found code to do that easily enough on these forums.
The problem I am having is in getting the columns A-H to be automatically copied (so A2-H2 would be copied onto all the lines A3-H3, A4-H4, A5-H5 and A6-H6 if the count in I was 5). Ideally this would happen automatically once the number in I was typed and the box tabbed or entered out of by the inputter.
I have managed to do a macro which repeatedly copies and pastes one line, but it has to be run every time, but it only works for the first line, not any different sets of A-H further down the sheet.
Firstly - Am I on the wrong track trying to use a macro to do this?
Secondly - Is there any way to get the automatic running of a macro in this way?
Thirdly - How is a macro written to ignore a zero or 1 value, but to do x-1 copies when a value greater than 1 is put in column I?
I did try a column J to give TRUE/FALSE if I is less than/equal to or greater than 2 in case that made it easier but am still stumped.
Assistance greatly appreciated, I've been giving myself a headache trying to figure this out this week!
Thanks to all.
NEALR
I am trying to do a monitoring sheet for work, where there may be nil to several dozen items to be listed after a particular action has been taken. The first 8 fields list parts of the action, the ninth is the count of how many follow ups are needed.
i.e. A-H are identifying fields, I is a number usually between 0 and say 24. Columns after that will be the details of the follow up actions. I will probably be auto-transferring those sections onto another sheet, but have found code to do that easily enough on these forums.
The problem I am having is in getting the columns A-H to be automatically copied (so A2-H2 would be copied onto all the lines A3-H3, A4-H4, A5-H5 and A6-H6 if the count in I was 5). Ideally this would happen automatically once the number in I was typed and the box tabbed or entered out of by the inputter.
I have managed to do a macro which repeatedly copies and pastes one line, but it has to be run every time, but it only works for the first line, not any different sets of A-H further down the sheet.
Firstly - Am I on the wrong track trying to use a macro to do this?
Secondly - Is there any way to get the automatic running of a macro in this way?
Thirdly - How is a macro written to ignore a zero or 1 value, but to do x-1 copies when a value greater than 1 is put in column I?
I did try a column J to give TRUE/FALSE if I is less than/equal to or greater than 2 in case that made it easier but am still stumped.
Assistance greatly appreciated, I've been giving myself a headache trying to figure this out this week!
Thanks to all.
NEALR
