0
Undo
Votes
I have an data in an excel worksheet that needs to be placed in another worksheet. The format of the worksheets do not match. I have 5 columns of data that need to be place in the 2nd worksheet. This will be a recurring event. Any suggestions?
0
Undo
Votes
I need data from one worksheet to be moved to another worksheet on a recurring basis. Is there a way to automate this functionality? Does your product have this functionality?
It is only 5 columns; the column names are not the same.
Any guidance will be appreciated.
It is only 5 columns; the column names are not the same.
Any guidance will be appreciated.
0
Undo
Votes
Hi there,
You can attach the file with the worksheets you mentioned to help we better understand and solve your problem.
Amanda
You can attach the file with the worksheets you mentioned to help we better understand and solve your problem.
Amanda
0
Undo
Votes
Hi there,
Do you mean that you need to automatically move 5 columns from worksheet A to worksheet B on a recurring basis?
Are the columns in the fixed position? Since you mentioned the names are different so I suppose that we cannot move the columns by matching their names?
Amanda
Do you mean that you need to automatically move 5 columns from worksheet A to worksheet B on a recurring basis?
Are the columns in the fixed position? Since you mentioned the names are different so I suppose that we cannot move the columns by matching their names?
Amanda
0
Undo
Votes
Hi there,
Excel files recieved. However, can you be more specific?
Are you saing you want to move column A-E from worksheet B to column A-E of worksheet A?
Amanda
Excel files recieved. However, can you be more specific?
Are you saing you want to move column A-E from worksheet B to column A-E of worksheet A?
Amanda
0
Undo
Votes
Hi there,
Please see the macro in the below attached file.
In ThisWorkbook and Module1, we set to auto move columns at 9:00 everyday.
In Module1, please change the below content according to your situation.
Hope this could help you
Amanda
Please see the macro in the below attached file.
In ThisWorkbook and Module1, we set to auto move columns at 9:00 everyday.
In Module1, please change the below content according to your situation.
Hope this could help you
Amanda
- Page :
- 1
There are no replies made for this post yet.