Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Anonymous User
  Wednesday, 03 August 2022
  8 Replies
  4.7K 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?
1 year 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.
1 year 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
1 year 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
1 year ago
·
#2996
0
Votes
Undo
Yes. you have it correct. The columns can not be changed.
1 year ago
·
#2997
0
Votes
Undo
Thanks for your help! Worksheet B can not be changed.
1 year 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
1 year 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?
1 year 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.