repeat date and name in columns for invoice information based on sheet name

[Mussa-A]

Hi guys
I want copy invoice details from SL sheet to specific sheet based on cell D3 contains sheet name .
should repeat date and name and invoice no for B3,B5,B7 from SL to SH sheet in columns DATE, NAME, INVOICE NO up to TOTAL row as in my example based on sheet name in D3 also copy ITEM, ID,QTY ,UNIT PRICE ,TOTAL columns to ITEM, ID,QTY ,UNIT PRICE ,TOTAL columns in SH sheet after that should insert TOTAL row to sum column G as I did in requirement sheet . after copy from SL sheet I want clear cells B5,B7,A10:D with ignore any cell contains formula from clearing . as to TOTAL row in SL sheet is dynamic will add new rows before TOTAL row when I need more ID .
every time I will add new data(new details invoices in SL sheet) for so could reach the data for each sheet for about 4000 rows and should copy new details invoices to the bottom in each sheet.

[jindon]

Please Login or Register  to view this content.

[Mussa-A]

thanks ,but I want copy to the bottom ,not replace old data with new data and I want clearing filled data in SL sheet after copy to specific sheet as I said

I want clear cells B5,B7,A10:D with ignore any cell contains formula from clearing . as to TOTAL row in SL sheet is dynamic will add new rows before TOTAL row when I need more ID .

[jindon]

Please Login or Register  to view this content.

[Mussa-A]

thanks again
can avoid clear TOTAL word in last row for column A ? and I don't want repeating DAtE,NAME ,INVOICE NO in lastrow (TOTAL) ,sorry about my mistake in OP!

[jindon]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

If this is not what you want, upload a workbook showing After SL sheet.

[Mussa-A]

OK just see the TOTAL in lastrow for sh sheet doesn't repeat filling DATE,NAME,INVOICE NO , this is what I want it .
another thing after clear data and if I run the macro there is no data in SL sheet will continue copying to the bottom without data except ITEM and TOTAL row I don't need that as in WS sheet ,I don't want it . I want running the macro based on D3 is sheet name so I adjusted this line

Please Login or Register  to view this content.

if the D3 is empty then will not copy anything (because there is no sheet name to matching) and if I write wrong sheet name in D3 then will pops message "error sheet name".

[jindon]

Just add one line before On Error Resume Next

Please Login or Register  to view this content.

[Mussa-A]

I'm not sure if you read well my last post !
it doesn't solve anything what I ask for it.

[jindon]

Please Login or Register  to view this content.

[Mussa-A]

thanks again
but still filling DATE , NAME , INVOICE NO for adjacent cells for TOTAL row . I don't want it as I posted in SH sheet.

[jindon]

What you are presenting are confusing.

I always looked at "requirement" sheet for the result, so I wrote like that.

Please Login or Register  to view this content.

[Mussa-A]

What you are presenting are confusing.

my apologies !
now every thing is ok .
thank you so much for your time & help .