Hello,
I need help with a macro to copy the formulas from A7 to N7 to the next row (A8 to N8) in a spreadsheet.
Then paste the absolute values back into the original row. It should always go to the next row, but I can't get it to do it. Any help?
Thanks Nelly
How about something like this?
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
I have found the following site that has various codes http://dmcritchie.mvps.org/excel/insrtrow.htm but still cant seem to work it out - any help please
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Thanks Dave
the worksheet "line quote" is where i need the macro A7 to N7 copied below or above. the line quote is populated partly from the first worksheet and the yellow highlights populated manually.
Any help would be amazing.
Nelly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks