Hello Everyone,
I have come across a problem with my spreadsheet that generates the schedule for components and sub-components. I receive a file that I copy and paste special - values only. It looks like in Sheet1 but a lot longer. what I have to do next to make sure that the formula on the Sheet2 picks all the requirements is F2 and Enter every single cell with Part Number in column A and also row 4 as from A4 to AA4 to edit and enter all the dates.
Then I need to do exactly the same with all cells containing data (figures) in columns M,N,O,P,Q and R from row 5 down.
I was trying to avoid this now as the spreadsheet has grown significantly bigger and come out with the macro to do this for me. the only problem with macros I have is that when I record it to do on the blank cell (as the Part Numbers shown on the schedule may vary from week to week) it will always come back blank. When recording it with the figures it only saves a numer that is at this one time and no matter what else you put in there it will still come back with the original number as this is what it has remembered.
I have also made a macro that copies and pastes values only but this is not good at all as the formula doesn't pick it up at all.
I attached a sample file to look at with macros recorded.
Anybody has an idea how manipulate the macro to get the result as per 150110 part please share.
Thank you for giving it a go.
Simon
Bookmarks