When I do a insert paste row on column D, how can I have column A,B and C insert a new row as well while duplicating their data?
Example:
a3 = algebra
b3 = 7th grade
c3 = Mr. Teacher
d3 = Student name
If I did an insert paste row on my students name, then algebra, 7th grade, Mr. Teacher will also be created next to them.
I've searched through similar threads but no luck.
It could be done with macros but the simplist way (I think) would be to
1. Copy entire previous row, paste insert copied cells
2. paste the new students name over the old students name.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Can you show me how it's done with macros?
not sure i follow.. can possibly help if u explain what you are tryin to do exactly
Here's an example. Hopefully this makes sense.
Last edited by curb; 09-15-2008 at 07:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks