kylefoley76
Well-known Member
- Joined
- Mar 1, 2010
- Messages
- 1,553
in sheet 2 i have data that was the autofiltered version of the data in sheet 1. i made some changes on the data because with the blanks removed it was easier. now i want to take that data and copy it back into sheet 1 but sheet 1 must be in auto filter format for me to do that. let me draw some more pictures.
in step one i have sheet 1 (in the real spreadsheet there are about 8000 rows with gaps of about 10 cells between them so it is necessary that i use the auto filter or some other trick to help me)
step two, i filter out the blanks
step three i paste the results on a new sheet and add columns aj and ak together, the result being in al
step four is the step i cannot do, i'm trying to paste the results in column al back onto sheet one so that they are the sum of the two cells to their left
in step one i have sheet 1 (in the real spreadsheet there are about 8000 rows with gaps of about 10 cells between them so it is necessary that i use the auto filter or some other trick to help me)
step two, i filter out the blanks
step three i paste the results on a new sheet and add columns aj and ak together, the result being in al
step four is the step i cannot do, i'm trying to paste the results in column al back onto sheet one so that they are the sum of the two cells to their left
