Create a macro to extract a total from another sheet!

**McQLon** · 01-27-2009, 01:28 PM

Hi,

I attached an example. Basically I want a macro to select the "total" cell in sheet 2 and put it into the "total" cell in sheet 1.

The "total" cell in sheet 2 is always in the same column but can vary as to which row it will appear in. I know this has something to do with the 'lastcell' referencing but don't know how to do it.

Please help!

Thanks,
McQLon

**solnajeff** · 01-27-2009, 01:45 PM

Hi

If the changes in sheets 2 are as a result of inserting/deleting rows, you could possibly use link rather than vba. If not then there are a number of ways to find the last row/cell and for your example

Please Login or Register  to view this content.

regards

Jeff

**McQLon** · 01-28-2009, 06:34 AM

It works pefectly! Thank you very much for your help!

Create a macro to extract a total from another sheet!

LinkBack

Thread Tools

Rate This Thread

Display

Create a macro to extract a total from another sheet!

Re: Create a macro to extract a total from another sheet!

Re: Create a macro to extract a total from another sheet!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions