scraping info from one excel sheet to another

[hawee]

Hi,

I was wondering if its possible to scrape info from one excel sheet into another excel sheet in a specific format?

[FDibbins]

Depending on what data you want to pull to the other sheet, there are a number of ways of doing that

As far as pulling in the formatting, regular formulas only work with data, not formatting

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.