Copying data between different worksheets

So you're looking for a macro to update the table on Active Projects starting at row 24 to list all the projects from Workflow with a status of "O" in column R? That can be done with a simple AUTOFILTER and COPY.

1) Copy A:D to A:D, easy enough
2) Fill in formulas in F:H
3) Where are the percentages in column E coming from?

What is AUTOFILER?

AUTOFILTER is a way to filter your spreadsheet with code.

He's going to write you some code that will filter your sheet and copy the results of the filter.

I would think a macro that is designed to recreate the source table below for your chart would need the ability to create ALL the columns. So the method for ascertaining the column E values needs to exist as well.

Hi guys. Thanks for your replies.
skywriter good to hear from you again.

I guess I misunderstood what JBeaucaire first said. That was autofilTer not autofiLer. Sorry.

So I spent the last couple of days trying to figure out how to copy and paste data from 'Workflow' sheet to 'Active Projects' sheet using OFFSET. Since I wasn't very successfull in understanding a thing about this function , I kind of kept the previous formula but stretched the IF condition:

Formula:

Please Login or Register  to view this content.

As you guys said an autofilter would do the trick, I expanded the chart's data source selection from A24:D74 to A24:D500. Then, I filtered the column A leaving blank cells out. BAM! Looks very good now. Chart is limited to 477 rows maximum but I do not intend to run such a hidious amount of projects at the same time anyway!

The only thing is that I have to hit Ctrl+Alt+L in both 'Workflow' and 'Active Projects' sheets in order to sort all data and update the chart. Is there a (simple) way for autofilter to automatically update the sorting as data is pasted into the cells in 'Active Projects' sheet?

Cheers mates!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.