Hi all,

I have a payroll file with an average of 45 tabs. The tabs are named as followed:

Page 1
....
Page 50

In any given tab, there may be under Column Y, the letter G and the associated dollar value in column Z.

I would like with a macro, be able to move (maybe cut and Paste) the information one row up (same position-Column Y and Column Z) and then be able to delete the entire row where the letter G and their corresponding value was before.

For example, in Page 20 in this file, in cell Y20, there is a letter G, and in cell Z20, there is a dollar value in the amount of $225.00. With a macro, I would like move the information one row up (to row 19), and after this I would like the macro to delete the entire row 20.

For example, in Page 30 in this file, in cell Y24, there is a letter G, and in cell Z24, there is a dollar value in the amount of $324.00. With a macro, I would like move the information one row up (to row 23), and after this I would like the macro to delete the entire row 24.

Hope this is not confusing.

Well, thank you in advance for your assistant and cooperation.

Regards,
rsrac