VBA code to keep data in parity between two worksheets

[SamCha]

Hi all,

I am new to VBA and I am searching for an easy code to connect my data flow in 2 worksheets in the same macro workbook. One worksheet is the "Input" worksheet (Sheet 1) and the other is "Format" worksheet (Sheet 2). Manually data are entered in Sheet 1. Column B (Data starts from Row 15) in Sheet 1 is the main column where account numbers are entered. Rest of the cells are either connected to this account with vlookup or is REF cell. Column D in Sheet 2 is the REF column of Column B in Sheet 1. So both the column has the account numbers. Now what is required is if there is no account number in Sheet 1 in column B, that means no account number in Sheet 2 in column D - the entire row in Sheet 2 will be removed and if there is an account number the entire row will automatically be filled taking reference of the previous row. In Sheet 1 the account number entries vary (starting from Row 15) - sometimes being 20 entries and sometimes 5. Entry starts in Sheet 2 from Row 5. Range of data in Sheet 2 is from A1:DJ. If we have an account number in Column D - the entire range from A:DJ will be populated take ref from the row above and will be blank if Column D is blank

 

[SamCha]

Hi all,

Just to add to what I am looking for please refer to the Sheet 1 attached. I am not able to attach the Sheet 2. But what I meant was Sheet 1 and Sheet 2 have cell reference. Column B (starting from Row 15) in Sheet 1 is cell reference for Column D in Sheet 2 (Starting from Row 5). The size of the Debit account varies in Sheet 1. I am trying to find a solution that when there is no account number in a row in Sheet 1, the entire row in Sheet 2 will be deleted, and when there is an account number the entire row will take the formula reference in increasing order from row above. Hope I am able to explain.

Thanks in advance.