Hello,
I have a column with title and list of numbers. I need to calculate per every 2 rows the yield (i.e. 1st row - 2nd row) and write the result in first of both rows of next column.
e.g. source data are in column A, and results go in column B. I write the results only every 2 rows, so I have every time 1 row empty. I'm looking to write VBA code for this exercise.
Thank you for your help.
Something like this perhaps.
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
Hello JapanDave,
Thank you for your code suggestion. Your code works fine!
Last edited by zeno1; 05-22-2012 at 12:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks