Best Method to Fix Computer Errors: Solution to Error: Macro to copy varying prices of parts onto separate sheets

Macro to copy varying prices of parts onto separate sheets

Don’t really no how to explain this but basically I have a spreadsheet with the first sheet consisting of a list of part numbers in column A, and then in column B, C and D there are different prices based upon quantities ordered i.e

PART NO       0-10     11-100             100 +
1234                £50      £40                  £30
2121                £10      £8                    £6

I then have a separate sheet for different units which consist of all the different part numbers listed in the first sheet like above (cost roll ups of each unit).
There are numerous tabs which contain the same part numbers, and rather than going through
every sheet searching for each part number and then listing the various prices in the adjacent cells, is there any way I can create a Macro for each sheet to do this? I used an IF function with a look up (=IF(A8=Sheet2!A:A,VLOOKUP(Sheet1!A8,Sheet2!A:E,5,FALSE),""),
but its not searching the whole column and only works if the part number on sheet 1 is in the same cell as the part number on the other sheets.

I hope this makes sense I don’t really no how else to explain it!

Anwsers to the Problem Macro to copy varying prices of parts onto separate sheets

Download Error Fixer for Free Now

Perhaps I have missed a point here also, but I think you can do what you want with just a formula.
It seems your problem is caused by not being able to accurately determine if the part number on a given sheet is on Sheet2 - and that is what you were trying to determine with your IF(A8=Sheet2!A:A part of the formula.
You could use the Excel 2007/2010 feature IFERROR() to deal with this:
=IFERROR(VLOOKUP($A8,Sheet2!$A:$E,5,FALSE),"")
If the value in A8 of the sheet with the formula is not found on Sheet2, column A, then a blank is returned. If it does exist, then you get the value from column E in this case.
If you need to use the workbook with Excel 2003 or earlier, you could write it this way, which also works in Excel 2007/2010:
BUT with Excel 2003 and earlier you would have to specify a range for A:E like this:
=IF(ISNA(VLOOKUP($A8,Sheet2!$A$2:E1000,5,FALSE)),"",VLOOKUP($A8,Sheet2!$A$2:$E$1000,5,FALSE))
where 1000 would take you far enough down the sheet to catch all part numbers, with maybe some extra rows to add new entries onto Sheet2 without having to rewrite the formulas.
***
But I may have the sheets turned around? In the above, I am assuming that Sheet2 is the sheet you've shown sample data from in your posting - with many part numbers in column A along with their prices in B, C and D.

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Macro to copy varying prices of parts onto separate sheets in Windows.

Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
Close the Command Prompt Window because we are done.

Try and see if you still get the same error Macro to copy varying prices of parts onto separate sheets in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Another Safe way to Fix the Problem: Macro to copy varying prices of parts onto separate sheets:

How to Fix Macro to copy varying prices of parts onto separate sheets with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.