If you have pasted the data onto the second sheet as values using the Paste Special command the pasted data cannot 'read' values from other lines. It'll be just fixed numbers.
Would you be able to send me the file so I can take a look at the data
Ok go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
Ok first try to replace the sensitive data with dummy values (you can delete most of the rows leaving only a few). Then go to this site to upload the file
After uploading you will be given two links, one for Downloading and the other for Deleting the file. Copy BOTH links and paste them in your reply so I can use the Delete link to delete the file from that website as soon as I have downloaded it
Ok I got the two files and deleted them both from that site. Will be looking at them shortly
I am not able to see the problem. Which of the two sheets has the issue and how would I find out which rows/columns are shifted
So the problem is in the All editor tab. Ok I see formulas on that sheet referencing another file which I do not have.
I still need to know what the problem is, can you give an example (i.e. one cell, one row, etc) so I can follow
I see. Ok you need to have formulas on the 'all editor' sheet which pull data from 'all jobs' based on the person's name and Job#. This means the existing formulas will be overwritten
Will start on it shortly and get back to you asap
Ok I wrote the formulas that refer to the 'all jobs' sheet fixed as shown in the yellow cells below. The problem is that there are over 400 lines on that sheet. Do you want me to fix them all?
There are VLOOKUP formulas in the yellow cells which dynamically look for the Job# on the other sheet. The formulas you had were static formulas and are not copyable to the cells below. With these formulas you can type a Job# in column A on the All Editor sheet and the formulas will automatically pull the data for that job number
Let me send you the Excel file so you will know what I mean. Give me a few minutes to upload it ...
Ok have a look at the formulas in the yellow cells and get back to me so we can continue