Hi I have been trying to make these but have failed. ^ ^;; I’d like to create a macro
A21 has a word called ‘Date’ And somewhere down in column A has a cell with a word ‘FBT Details’. The location of FBT details depends on the amount of data between these two headings. I’d like to remove any blank rows between A21 and location of FBT details – 7. What I mean is For example, location of FBT details is A1207. Then I’d like to remove any empty rows (cells) between A21 and A1200 (not A1207). so 7 rows above. I’d like to do this because the data between these cells are one row apart. Could you help me please? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
