Tony Miall
Active Member
- Joined
- Oct 16, 2007
- Messages
- 304
Afternoon
I have a large amount of information that needs formatting. I've tried to write some code but unfortunately still have the L plates on.
What I want to do is look at all rows down from and including row 28 that have the same value in colum E as is in E27 then copy the format for row 27 to all the rows below that meet the criteria For example. E27 = 1 and so does E50 and E60 so copy the format from row 27 to E50 and E60.
Thanks
I have a large amount of information that needs formatting. I've tried to write some code but unfortunately still have the L plates on.
What I want to do is look at all rows down from and including row 28 that have the same value in colum E as is in E27 then copy the format for row 27 to all the rows below that meet the criteria For example. E27 = 1 and so does E50 and E60 so copy the format from row 27 to E50 and E60.
Thanks
