HI to Forum!
Thank you Admin for tips and message, hope now is better :-)
So, I have Excel files and some data are in wrong place - 2 cells left and one row down.
Excel is from Office365.
I have to do a following task:
Complete row 129,131,133,135 etc... (start with cell B129,C129,D129 etc.) have to be moved on row 128,130,132,134 etc. start with cell D128,D130,D132,D134...
That mean B129 to D128, C129 to E128 etc...
In this case, all contents from other cells (B129,C129,D129...) fit correctly in rest of table - B129 is actually D128, C129 is E129 etc.
So I have actually move content of complete row 129,131,133 etc... 2 cells on the right and one row up.
I can do this manually, copy one by one, but this is not an option, file is about 35MB and I have to do this every week.
In attachment you can find a part of file, first two rows are correct and the others have to have same look as the first two rows.
Also there's another pattern start at row 76 (emtpy row and then pattern as I described)
Any help/advice are welcome:-)
Best regards to all:-)
Bookmarks