Need to make each row in the Excel sheet as an individual style Excel sheet in batches? 40

sub splits **().

dim wb as workbook, c as integer, filename as string

falsewith thisworkbook

filename = & "Sharding.

filename)

for c = 2 to [a65536].end(3).rowa = cells(2, c).text

set wb =

a1")filename & "/" & cells(c,2) &".xlsx" 'Name the file after the station number.

nextend with

truemsgbox "Split completed -"

end sub

To use VBA** to get it,** 60 yuan.

Let's say your 20 rows are in "Table 0".

sub addworksheetafterlast()on error resume next

for i=1 to 20

worksheets( = "Table" & iworksheets("Table" & i).rows("1")=worksheets("TABLE 0").rows(i).value

next i

end sub

Using macros, this tool makes it possible.

Hello answer, I have seen your question Ha Now I am manually replying to the content for you, but it will take a little time, please wait patiently, thank you Ha I am here to wish you a prosperous Year of the Tiger

Do you have any other questions that I would like to answer for you?

The first table shard 1 of the source data (must be named 1).

a1=index (The source data is copied to the right.)

Duplicate Table 1 is renamed to ......Complete. The workbook must save the formula for it to take effect.

Splitting a worksheet into a workbook requires macros.

In Excel, press Alt+F11 View--** window, copy the following into it, and press F5 to run.

Please put this excel into a folder operation, the default generation to the current folder effect is as follows:

You can use the function method or VBA.

The function method is to match the data of the corresponding row and then print it.

A VBA, on the other hand, can do it all at once.

Generate an attachment that you can try、、、

It can be done, please send the original form and request to:

Find Data in the menu bar - Filter - Auto Filter.

It's really fast to use macros, you can write one yourself.

You can use mail merge, but you need to use word, and make a table in word. Then use the mail merge, the file comes from the excel source file! Finally printed in Word.

If you still don't understand, you can send me the ** and I'll do it for you. It can be done in 10 minutes.

I can help you, add me as a friend. QQ contact.

Mail merge, how to do it, there are too many, you can just check it on the Internet yourself.