How to automatically copy data with specific information to other sheets?

[ale99]

Hi everyone!

I'm looking for an option to reduce time and mistakes. Daily I have to do payment batch. I get the information through a web page, so I copy it everyday to a excel workbook and filter the information and copy 1 by 1.
As a batch it has pre-charged and fixed information, so I need that just some columns with specific information be copied to their specific sheet
We managed 1 sheet per location and there are 6 or more locations into the mentioned web page information on 1 mixed excel sheet.

So I need the information to be organized on their correspondent sheet, is there any option for this?


Thanks in advance.

 

[alansidman]

This can probably be done with VBA, but for that to happen, we need to understand the the locations sheets, where the data resides on the sheet imported from the web. Lots of details to make it happen. Be as specific as possible with a step by step narrative of what you want.