Note: The other languages of the website are Google-translated. Back to English
  Anonymous User
  Wednesday, 03 August 2022
  8 Replies
  2.1K Visits
0
Votes
Undo
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?
4 months ago
·
#2990
0
Votes
Undo
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.
4 months ago
·
#2993
0
Votes
Undo
Hi there,

You can attach the file with the worksheets you mentioned to help we better understand and solve your problem. :)

Amanda
4 months ago
·
#2994
0
Votes
Undo
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
4 months ago
·
#2996
0
Votes
Undo
Yes. you have it correct. The columns can not be changed.
4 months ago
·
#2997
0
Votes
Undo
Thanks for your help! Worksheet B can not be changed.
4 months ago
·
#2999
0
Votes
Undo
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
4 months ago
·
#3009
0
Votes
Undo
Data from worksheet A will go to worksheet B

worksheet A column A to Worksheet B column B
worksheet A column C to Worksheet B column I
worksheet A column D to Worksheet B column J
worksheet A column G to Worksheet B column L

Does that make sense? could we use a macro?
3 months ago
·
#3029
0
Votes
Undo
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.
timer.png

In Module1, please change the below content according to your situation.
change path.png

Hope this could help you :)

Amanda
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL