The code above

I want to achieve from the "data" this workbook to extract the last value in the cell, 26 assigned to the workbook "daily form" line 9 8 to 14 listed the first empty cell, both workbook is updated daily

Is simply, 26 last line column of A workbook is copied to the workbook B line 9 8 to 14 listed first an empty cell

Now I have completed the first step, to extract the list of the last 26 cell values, but at the time of assignment to the "daily form" has not achieve them, after running more than a new form of "20200425", but the content and the form is the same old

Bosses give directions where the problem is, thank you!

CodePudding user response:

An hour passed...

CodePudding user response:

Don't post code?
In wb2. Save it, and then add
Try wb2. The save ()

CodePudding user response:

Ws2. Cell (9, I). value=https://bbs.csdn.net/topics/values

CodePudding user response:

refer to the second floor weixin_45903952 response:

post code won't?
In wb2. Save it, and then add
Try wb2. The save ()

Post for the first time, don't know how to paste the code

CodePudding user response:

The

reference 3 floor weixin_45903952 response:

ws2. Cell (9, I). value=https://bbs.csdn.net/topics/values

If can't

CodePudding user response:

 
If the values!=None: 
Ws2. Cell (9, I). value=https://bbs.csdn.net/topics/values 

With the editor in the post, the code to join, the judge should be!=?

CodePudding user response:

Lastrow (26) no value, so values are not written