Want to copy S.No (A1,A2,A3,A4.......) one by one from sheet "filter_data" to sheet "cheque print" , into Cell (Y22) using VBA

zahid wazir 1 Reputation point
2022-03-21T10:07:02.083+00:00

I have two Excel sheets with the name Filter data and Cheque Print on the same workbook, In the Filter Data, I have Cheque Serial Number in Column A2, A3, A4, A5...... and in the Cheque Print, Cheque Print format using VLOOKUP. Now I want to copy Cheque S.No (A2, A3, A4, A5......) to sheet Cheque Print into Cell Y22 one by one using VBA. Copy Cell A2 data to Y22 and print the Cheque, again Copy Cell A3 data to Y22 and print the Cheque, at last, to find the empty cell. Kindly someone helps me.

Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
Developer technologies | Visual Basic for Applications
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.