I have a list of over 500 entries by customer name and I want to be able to create a sheet for each unique customer using macros. Is there a way to do this and to name each sheet based on the customer as well?
I am new to VBA but I tried using two separate strings of code (one to sort through...
Hello,
I'm in the process of expanding on a macro to look at customer ID and the product name they ordered. If they ordered a set of a particular product then it will combine both product name into one and delete the oldest record.
I have created another tab that combines the product...
Team,
I am trying to use an excel spread sheet copied into a Sheet in excel to input information.
Example:
Sheet 1 Cell A2(in cell A2 =desired number) I want information to be filled with units sold by Location1.
The location information will be in Sheet 3. The difficult thing is the...
Hi!
Is there a way to find the colum-name and the row-number from a named cell?
I know that I can get the complete address using:
Sheet1.Range("some_named_cell").Address
Answer (e.g.): $A$1
I want to seperately get 'A' and '1' (in VBA).
Is this possible?
TIA,
Willem!
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.