I have a large list of items that I want to verify. There are two sheets, one with the raw data and the second with a list of items. Set up kind of like this:
Sheet One
<tbody>
Host
User
host1
user1
host1
user2
host2
user1
host2
user2
host3
user3
</tbody>
Sheet 2
<tbody>
Host
User...
Hi all,
Is there a way to automatically change workbook name dependent on which folder its in?
If say the host folder is called "2019" and the workbook is called "test.xlsm". When "test.xlsm" workbook is placed into the "2019" folder the workbook then changes name to 2019.xlsm?
regards
Ged
I am having an issue with finding the correct syntax to utilize the vlookup where two criteria are met if the first vlookup returns no data. so I was thinking something like
find host on datatableA, - if there is an address value (not blank), display it; if not, then look for the host {still on...
Hi all
I have zero working knowledge of access. I am considering purchasing an access database for CRM (customer relationship management) purposes. The only drawback is that this would sit on my desktop and for obvious reasons I am hesitant. Is there a service or somewhat simple way for me to...
I know this website is mostly used for Excel but I'm hoping someone can point me in the right direction for this! I'm programming in passport Host in Win 3270. The programs should all start at the same coordinate location (i.e. Row 3 Column 5).
Does anyone know the code to force the program to...
Can excel be used to randomize a secret Santa draw? It needs to have functionality that it randomises a name and wither emails that person or puts onto a tab or hides the name from everyone else.. maybe only access with a password so the host doesn't see who has who either?
I would like to seek help from the expert in Mr.Excel with my issue below.
i have some sample data as per below. Host is in 1 table and Port is on another table.
<tbody>
Host
Port1
Port2
Port3
Host1
1A
1B
1C
Host2
</tbody>
I would like to output the data as per below in another...
I dont know why this code is not working.
Please advise. Thanks
Ped;)
Sub host_name()
Dim ClientMachineEntry As System.Net.IPHostEntry
ClientMachineEntry = System.Net.Dns.GetHostByAddress(Request.ServerVariables.Item("REMOTE_HOST"))
messagebox.Show (ClientMachineEntry.HostName)
End Sub
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.