Need to use VBA to copy a sheet table and increment the cell row

[jevi]

Hi All:

I have a workbook and on the first sheet I have made a summary of some data for a branch. Then I would like to copy this table in the other 56 sheets but with an increment of the cell row with + 1.

So the first sheet "named" Sheet 1 - all the cell are with the same row so is 8, so each filled data can be D8, E8, X8, N8 but is always 8, and the information for the next branch should be with the row 9, and the next branch with 10 and so on...but will be the same columns only the row will change.

How can I do it with a macro, please!! One way I have found is that after I do the first summary of this branch data, I open all the books that I take the information and copy to the next sheets and go replace 8 with 9 and so on which is easier thought but a macro would be a great help .

Thank you

 

[kevatarvind]

can you pls provide some sample of your data ?

 

[jevi]

I can't attach excel sheet as I am in the office or if I can send at your email address..still I will try to go home and attach the file, but the data is entered from different workbooks in this sheet 1, all the data entered like below have row 8 in common and for the next branches they will be at 9...

	Amount April</SPAN>	Amount May</SPAN>	Total</SPAN>
Loans</SPAN>	33,000.00</SPAN>	1,074.65</SPAN>	34,074.65</SPAN>
Deposit</SPAN>	45,000.00 </SPAN>	60,000.00 </SPAN>	105,000.00</SPAN>
Unsecured</SPAN>	39,000.00 </SPAN>	49,000.00 </SPAN>	88,000.00</SPAN>
Cards</SPAN>	400.00 </SPAN>	500.00 </SPAN>	900.00</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>

thank you for the reply.

 

[kevatarvind]

ok mail me on kevatarvind@yahoo.com

your excel file one master sheet and after then how 1st sheet copy and how to add next row for sample

 

[jevi]

Ok I will do so and then for sure post the soluation here ( if it will be any )


Shukriya

 

[jevi]

any solution kevatarvind?

 

[kevatarvind]

any solution kevatarvind?

sorry but i have not received any mail or file from your side i am waiting for you file ?

 

[jevi]

kevatarvind<wbr style="color: rgb(51, 51, 51); font-family: arial, sans-serif; font-size: 16px; line-height: 20px;">@yahoo.com

I have sent it to the above address, and I think is the same with the one you gave to me..so no mistakes. Don't know why you are not receiving it..maybe is in Junk mail..!! Or write me at xhevihoxha24@gmail.com so I can check if I do receive emails from you.

 

[jevi]

I have sent both files, hope you got them....let me know if there is any easy soluation .

I did a lot of google but can't figure it out as I am not good with creating macro only doing small changes and implementing them .

thnx