Copy value of cells to new rows, whenever it changes !

**ajeetsingh** · 11-19-2014, 03:45 AM

I have attached an excel sheet.
It has dynamic web query with parameter in sheet1!C6
C6 has dropdown menu which changes its value after every 10 sec with help of macro
After calculations in sheet2, results are displayed in sheet1!C8, sheet1!D8 and sheet1!C9.
Now I manually feed these results to O10 P10 Q10 then on next web query O11 P11 Q11 and so on....
Kindly help me to automate this process.
Copying process must not be dependant on time rather it must wait till value of cell change.
Means copying process must be initiated only upon change in value of designated cells and not with time.

Capture.jpg

**bmouse** · 11-19-2014, 04:01 AM

I'm a VBA noobie, but it could be possible to write a macro based on IF, which compares the values in columns C and D to the values in columns O, P and Q. If the values differ, the new values get added to the next row. I do not know, however, how to write a macro that runs constantly like this one. If I was to write it, it would require to press a button everytime the value changes.

**ajeetsingh** · 11-19-2014, 04:12 AM

Originally Posted by bmouse

I'm a VBA noobie, ...........

To start with, Its ok with me.
Usually I stare on screen when above process goes on..... So its better to press button than to copy paste manually.
But do care that when ever I press button for new macro, it must not hinder the working of running macro named "ajeetsingh"
Also I have colour coded the respective positions of cells to be copied so that must be same through out the process.
Thanks for your quick reply.

**ajeetsingh** · 11-20-2014, 02:56 AM

please-help-call-to-action.jpg
...........

**ajeetsingh** · 11-20-2014, 11:38 PM

Anyone willing to help?

Copy value of cells to new rows, whenever it changes !

LinkBack

Thread Tools

Rate This Thread

Display

Copy value of cells to new rows, whenever it changes !

Re: Copy value of cells to new rows, whenever it changes !

Re: Copy value of cells to new rows, whenever it changes !

Re: Copy value of cells to new rows, whenever it changes !

Re: Copy value of cells to new rows, whenever it changes !

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Split Cell Contents to New Rows & Copy Cells containing single values to the new rows

[SOLVED] Identify duplicate rows and copy/Paste the first cell to all cells of equal rows

[SOLVED] Insert rows based on the current cell value and, then, copy some cells into the new rows

Copy multiple cells from two different rows to other rows based on a pull down list

how to copy cells down X rows but updating all copied formulas by less than X rows

Bookmarks

Bookmarks

Posting Permissions