How to add counter to monitor numberof edits and copy this data in diff cells??

Dear Reader!!

My objective is to reduce the time a errors occured in data entry in a manufacturing unit.

My requirement is:

Firstly, i select a data in the cell B5 by drop down list, then select another data from C5, again select a numeric value from D5, again a value from E5, and enter manually a number in cell F5: the visulalisation goes here: B5,C5,D5,E5,F5.
This data in B5 shoukd get copied to B10, data in C5 copy to c10 and so on til F5 data gets copied to F10
hence, B5 to B10, C5 to C10, D5 to D10, E5 to E10, F5 to F10.

Similarly, B5 to B15, C5 to C15, D5 to D15, E5 to E15, F5 to F15.

upto, B5 to B1500, C5 to C1500, D5 to D1500, E5 to E1500, F5 to F1500.

Request for solutions.

Appreciate for the valuable solution and thank you in advance.

Regards,
Chetan

Perhaps..

Please Login or Register  to view this content.

You need to execute the macro once you have populated the cells in B5 to F5. Whats the error you've run into?

Alternatively, to just copy values run

Please Login or Register  to view this content.

Do you need these values replicated all the way from row#10 to row#100 or is it that they need to be updated in the immediate next non-blank row every time that you input values in Row#5? Your last post is inconsitent with your first one in terms of requirements

they need to be updated in the immediate next non-blank row every time that you input values in Row#5

---------- Post added at 11:54 AM ---------- Previous post was at 11:18 AM ----------

Please reply sir!!!!

---------- Post added at 12:47 PM ---------- Previous post was at 11:54 AM ----------

The Code provided by you:

Please Login or Register  to view this content.

the data from B5,C5, D5, E5,F5 location is copied to b6, c6, d6, e6, f6. this works fine.

again if i add data in B5,C5, D5, E5,F5, the data replaces the previous content in b6, c6, d6, e6, f6. that is not required to me.

My requirement is, as i add data in B5,C5, D5, E5,F5, the data has to keep on adding in the next rows, like first the data is copied in b6, c6, d6, e6, f6, then to b7, c7, d7, e7, f7, again then to b8, c8, d8, e8, f8. and son on.....

please rectify the code and revert to me.

regards,
Chetan

Use this instead..Cell B4 should be non-blank for it to work!

Please Login or Register  to view this content.

If you paste special values this might not be the case..also ensure Cell B4 is non-blank! You would need to execute the macro every time you update Row5

Please Login or Register  to view this content.

please upload a sample worksheet.

The problem was due to 'merged cells' and incorrect row numbers that you provided. Avoid merged cells, they screw up the most! Use 'center across selection' alignment if you need the cosmetic visual effect.

Refer attached. The code has been copied therein. I have also amended the data validation lists which were earlier picking the header rows too!

Here's the code...

If you want only the date rplace the NOW() with TODAY() in the code

Please Login or Register  to view this content.

P.S. You can show your appreciation by clicking on the * icon towards the left!

As I mentioned earlier, do away with the merged cells. Make sure the ranges in the code refer to the ranges you need and adapt accordingly.

Not sure what does not work in this..At what instance do you get the error 400?

Sir, i have Solved the problem of " Error 400". thanks a lot for you help here!!!!!

could please change the code, so that i can copy the values to other sheet....

could please change the code, so that i can copy the values to other sheet....

Could you please elaborate?

this is code, where in the data is copied to 8th row on the same sheet:

Please Login or Register  to view this content.

please change the code , so that i can store the data on the other sheet.

Do you intend to copy this sheet onto another sheet? Then, try this

Please Login or Register  to view this content.

You have to be better at explaining your requirements and get them alll out at once instead of piecemeal posts! Save everyone time and effort