partnumber

  1. U

    How do I change the format?

    Is there an easy way to change this. Currently my data is in the following format: PartNumber Description Jan Feb Mar ETC. The forecast is under each month currently. I will prefer to have the data like the format below PartNumber Month Description Forecast.
  2. RasGhul

    Update values based criteria and header cell value

    I have the following code that compares part numbers from 2 sheets and updates them to the latest entry. This works very well for one fixed column(last entry). What I'm trying to achieve is updating the values from a specific column based on a cell value("aCell") which matches the headers from...
  3. S

    2 Dimensional Array VBA

    Hi, struggling a bit if someone can help me out please. I want to create an array with two strings "partno" , "description" I can create a 1 string array but i haven't got a clue :confused:. with two strings Can you please put comments in the code - still finding my way about with VBA my...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top