sammerloves: do you see the ( Counter ) and the N, N+1 cells, the main step is I started recording macro, then I copied the cell under N+1, which is I3, then (past special) in the H3 cell then stop macro recording
to do this copy and paste 200 times I went to macro editor and make counter from 1 to 200 to repeat the copy action, you can download the excel file to see it
@sameerloves100 do you see the ( Counter ) and the N, N+1 cells, the main step is I started recording macro, then I copied the cell under N+1, which is I3, then (past special) in the H3 cell then stop macro recording
to do this copy and paste 200 times I went to macro editor and made counter from 1 to 200 to repeat the copy action, you can download the excel file to see it
thx. yeah - it's like one of those flip books where the image changes slightly eac frame (tab). I shrunk the cells/rows down quite a bit to get 'pixels' and formatted from there. There's about 200 tabs in the animation.
sammerloves: do you see the ( Counter ) and the N, N+1 cells, the main step is I started recording macro, then I copied the cell under N+1, which is I3, then (past special) in the H3 cell then stop macro recording
to do this copy and paste 200 times I went to macro editor and make counter from 1 to 200 to repeat the copy action, you can download the excel file to see it
haidar976 3 months ago
please sir tell me how to do this ?
sameerloves100 3 months ago
@sameerloves100 do you see the ( Counter ) and the N, N+1 cells, the main step is I started recording macro, then I copied the cell under N+1, which is I3, then (past special) in the H3 cell then stop macro recording
to do this copy and paste 200 times I went to macro editor and made counter from 1 to 200 to repeat the copy action, you can download the excel file to see it
haidar976 3 months ago
thx. yeah - it's like one of those flip books where the image changes slightly eac frame (tab). I shrunk the cells/rows down quite a bit to get 'pixels' and formatted from there. There's about 200 tabs in the animation.
mxstrand 2 years ago
nice work, is it done by changing cells colors?
haidar976 2 years ago