Macro for linking cells from different rows to a specific place on other worksheets

Originally Posted by realniceguy5000

Hi Welcome to the Forum...

Here is a mini version of your spreadsheet.

See if this will work for you...

Anytime you put information in a cell it will transfer to the correct worksheet. This example only has 4 worksheets but you can see how it works.

Let me know if you need some changes.

...

Thanks Mike. I was able to use the first macro here (http://www.rondebruin.nl/summary.htm) to do the reverse of what I needed, or link data on each worksheet back to the main summary worksheet. I guess this is just as good.

Now I have to manually enter data from our utility provider's website, one line item at a time. This is going to take all week or more There's no way to have Excel navigate to a website, sign in, and copy and paste select data, is there?

Thanks for your help!

Richard