Sorry, but I can't modify this macro without something to work from, that is a sample worksheet. I would be guessing as to your layout and I don't want to guess. The sheet you attached in post # 8 does not have anything in column A and cell G5 says Tax%.

If this query is not related to your original post, please post a separate question.