I have a sheet with data for multiple machines with the data for each machine spanning 5 rows and about 30 columns. I am consolodating all of the useful data from each set to a single row in another sheet within the same workspace, but if I try to copy and paste the row, the formulas' references only move down 1 row. Is there any way that I could make the references move down 5 rows so I would not have to change each by hand?
hi danderson2692, u can upload the file for us to see. but if i were to just guess, u can paste the data 4 rows down the original place u pasted. then the formula will probably be moving 5 rows downwards. After that, just delete the excess rows.
but if u dont need these formulas, just Paste Special as values.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Sorry for not responding for so long. Your way worked perfectly. Thanks a bunch!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
danderson2692 
Register To Reply
Bookmarks