VB Function for Copy & Paste

S

sivakr68

Hi

Need some assistance in creating a function in Excel 2007.
Attached is a sample of a table I am working with Actual data table an
Stored data table.

In the first table in cell B2..G2, that has formula which are based o
live data. When the formula is correct, it will display a figure an
when it is not, it will display blank. The rest of the rows 3 to 8 wil
populate accordingly based on row 2.

Anyway, I need to create a function that
• When cell B2 (for example) gets populated, the function will cop
B2..B8 and paste to B11..B17. Each Column is independent of eac
other.

• When B2 goes blank, data in B11..B17 will still remain. For exampl
in column F, the cell F2 is blank but the data in F11..F17 is stil
there.

• When B2 get populated again, it will overwrite cells B11..B17.

• If the date and time (row 7 & 8) can work with the function, it woul
be great.

Thanks in Advance
Regards

Siva

+-------------------------------------------------------------------
|Filename: SampleData.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=306
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
IF function says too many nested 1
how to copy and paste value from one sheet to another 4
index function 1
Help with a formula (calculating totals based on individual percentages 7
Excel function needed 24
countifs Function not giving desired result with date criteria 2
Muti-result for lookup function 0

Top