MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need a Macro, or something...


Posted by George on November 23, 2001 4:49 AM

The workbooks I am using are over 7MB in size.

To reduce these (reports) I need to be able to press CTRL Z, for example and the set details will appear below the details I have just entered. The problem is the calculations are on 4 different sheets and so the different details on theses sheets also have to be copied down.

example
sheet1

{Address1} ____2000/01__{175.00}__{220.00}__{210.00}__700.00__40.00
_______________2001/02_______________________________650.00__33.00
_______________2002/03_______________________________620.00__30.00
.
.
{Address2} ____2000/01__{555.00}__{1000.00}__{900.00}__1500.00__140.00
_______________2001/02_______________________________1450.00__120.00
_______________2002/03_______________________________1410.00__110.00

The details in face brackets {} I need to enter myself, but after I have entered these details, I want to press CTRL Z for Address 2 to appear below.

The other sheets will follow the original layout of that sheet, but will pull through the figures from sheet1 above. If you need any more details or clarification please just say.


Posted by Jack on November 23, 2001 2:15 PM

Jack
Good luck on that one, its one for the VBA boys, its not so much of a question as a project, maybe a different approach is needed and scripts codes are fine, but not easy to edit and maintain unless your clued up in VBA Scripts.

Leys hope a good VBA programmer is about.
Take care and good luck.

NB Keep your work simple and see if there is another way thats easier for you to do.

Posted by JACK CAUTION JACK CAUTION JACK CAUTION JACK on November 23, 2001 2:26 PM

Something wrong, i cant even save this post as i do millions of others, Ermmm my Virus checker is 2 days out of date (normal zero to two day out of date) but i have never not been able to save a page in HTML...

STAY AWAY just in case DO NOT SAVE
DO NOT SAVE DOO NOT SAVE

My Checker sweep clean.. but caution....

Posted by George on November 24, 2001 11:20 AM

Moderator : Saved this post - no problem. I'll resend again later.

If moderator wants to delete this post as a precaution - OK by me . I'll ask the question again later.

George Something wrong, i cant even save this post as i do millions of others, Ermmm my Virus checker is 2 days out of date (normal zero to two day out of date) but i have never not been able to save a page in HTML... STAY AWAY just in case DO NOT SAVE

Posted by JACK on November 25, 2001 5:00 AM

Re: Moderator : Saved this post - no problem. I'll resend again later.

Nothing personal. me just being careful, re post and i hope you get the help we all get, sometime as if you read my postes, i hate virus programmers OKi admit they are extreamly cleaver butthey could help us all a lot more than being distructive.

I shy from any web page or file in general i dont even like the name of, format or even the lock of, my policy is simple if its not mine and brand new then i dont trsts it.

My post often say keep it safe keep it legal, best way i feel, sorry if i was a bit strong, but like i say i feel best way...

Go on re post...

Take car good luck