Generate Subnet, Router, Mask And Broadcast From IP.

May 18, 2009

I've got a list of 300 IP addresses in Column A.

I want a formula which will return the router, mask and broadcast IP

Eg. If i have 192.168.1.129, the result are:

router = 192.168.1.1
mask = 255.255.255.0
broadcast = 192.168.1.255

View 9 Replies


ADVERTISEMENT

Mask In User Form

Oct 16, 2007

I have a user form with 2 textboxes (used as parameters for an ODBC query). The entry should be a period, as yyyymm. How can I check, for instance when clicking the Ok button after entry, that both textboxes are of the "000000" format and the last 2 numbers are between 01 and 12?

View 9 Replies View Related

Display In The Input Box As A Mask

Feb 24, 2010

I would like to have some kind of input mask on my input boxes, the input box is for currency IN GBP (£)

The program itself obviously has no use for the £ sign, but I would like it to display in the input box as a mask.

Is this possible?

I should mention I am using:


Application.InputBox

View 9 Replies View Related

Creating A Time Mask

Aug 4, 2006

I need the users to be able to enter the time using either a . or a colon :,

So: 13:30 would give 13:30 and 13.30 would give 13:30. They have end up in time format too since I will be performing calculations on them. When that decimal place is entered I would like it to be turned into a dot

View 3 Replies View Related

Time Mask For Thousands Of Hours

Feb 13, 2009

Basically I want to be able to type a number and have a colon inserted two spaces to the left. So 123 would become 1:23, 1234 would be 12:34 and 12345 would be 123:45.

I'm working with anywhere from one to several thousand hours in a spreadsheet. I'd like to be able to use a time mask like this:

View 6 Replies View Related

Mask Password Input Or Entry

Oct 31, 2006

how can i show asterixes instead of the input data as it is being typed in a cell? somewhat like a password box...

View 6 Replies View Related

Applying Mask For Date Entries

Jan 24, 2007

I'd like to enter dates without having to use the forward slash symbol between the day, month and year values. I've read a post by Dave Hawley explaing how to do it, but I can't get it to work for me. There must be some step that I am not aware of.

View 9 Replies View Related

Mask Times Entered Into Range

Oct 9, 2007

Want to enter 6 digits for each cell in a range of cells with VBA mask change to time format hh:mm:ss for each cell when entered. Code below does this for hours and minutes but I haven't been successful in modifying to work including seconds.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim vVal
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Range("A1:A100")) Is Nothing Then Exit Sub

With Target

vVal = Format(.Value, "0000")
If IsNumeric(vVal) And Len(vVal) = 4 Then
Application.EnableEvents = False
.Value = Left(vVal, 2) & ":" & Right(vVal, 2)
.NumberFormat = "[h]:mm"
End If
End With

Application.EnableEvents = True

End Sub

View 3 Replies View Related

Easy Time Entry Mask

Apr 25, 2008

I have entered VBA code and tested it with success. If I then save & close the excel file and then re-open it, the mask time entry is not saved (time does not appear correctly after input) and per instructions I have designated (and am using) the cell input range.

View 9 Replies View Related

Disguise/Mask Cell Contents

May 22, 2008

I’m trying to write a VBA script to create disguised prices in an empty column “A” by extracting, and adding additional random generated characters (alpha, numeric, extended character set) from adjacent column “B” to create a scrambled price sheet.

Example Data: (2 columns and 5 rows)

Column A = newly scrambled prices. Column B = product prices.

Input: Column B = $13.95, $5.99, $4.00, $12.50, $10.10

Output: Column A = XCP1D3-VG9S5T.1L1, HUI0F5-SJ9W9X.9A6, RTJ0K4-JM0D0Z.4B4, KET1S2-AK5G0B.3M2, DLE1S0-QK1G0M.0C0...................

View 2 Replies View Related

Change / Mask Client Sensitive Data

Nov 28, 2013

I have a long list of data (around 10,000 rows) with one column Client Sensitive (Column A see below) that needs to be changed before using in a pivot so the client won't see this data.

At the moment I'm using a formula but happy to use VBA for this as the rest of the report updates with VBA.

The formula that works but takes far too long is
=IF(COUNTIF($A$1:$A2,$A2)>1,VLOOKUP($A2,$A:$R,18,FALSE),MAX($R$1:$R1)+1)
Where column A is the sensitve data (and the unique identifier) and column R is the column the formula is entered.

The below is what I want, the column R I now use in a pivot to get the results I want then I can hide that column and delete Column A so no Client Sensitve data is with the spreadsheet.

However as I've said it takes far too long to calculate down 10,000 rows..

Column A
Column R

A12345
1

[Code] .....

View 4 Replies View Related

Create A Custom Mask That Will Always Put A / At The Start Of Each Cell

Feb 19, 2010

how I can create a custom mask that will always put a / at the start of each cell in column C. So basically when I enter a number in, say 350, the mask will automatically put a / in front of it - /350 or even better /space350. The only issue is that the number will change in length a little, so not sure if this is a problem or not.

View 4 Replies View Related

Excel 2007 :: Mask Certain Characters In A String

Jul 11, 2013

Is there a formula that I can put in AI that will mask the text character from text position 3 through the 2nd to last text position of each business name in AH? Where in the heck do you find XLGenie in the Excel 2007 ribbon? I have it installed and its in my addins list, yet nowhere to be found in the ribbon!

AH

13
ABC Rental

14
Professional Tool Service

15
Wonder Plumbing

16
Jim's Bar & Grill

17
Bobs Hair Salon

View 2 Replies View Related

How To Create Mask (Userform) To Insert Data

Aug 17, 2013

I have a simple table with these column: Name, Surname, Address, Date of Birth, etc.

I would like to create a button which open a mask to insert the above data "automatically" in the table/columns.

I tried playing, being able to create the mask UI, but it doesn't work: the command "OK" doesn't insert the data. I am sure it is a stupid thing, but I can't sort it out.

View 3 Replies View Related

Excel 2007 :: Input Mask To Format Cell Content

Jan 20, 2014

The cell content is to be 0-7 characters in length.

Alpha characters only, i.e., no numeric.

First character must be uppercase.

Remaining characters may be lowercase or blank.

Is that possible to do in MS Excel 2007?

View 10 Replies View Related

Generate A Listbox

Oct 3, 2008

I have a list of names on a worksheet in cells C9:C:C395. Their respected team numbers are located in G9:G395. What I'd like to know is it possible to put a team number in lets say cell K2 and have a listbox appear with the names of each of the team member from that team.

View 4 Replies View Related

Generate PDF With All Sheets?

Mar 12, 2014

I have a big Excel file with 20+ sheets. All these sheets have different margins and layouts.

I need to generate a Single PDF with all these sheets. Is it possible?

When I save the file as PDF, it converts only the current sheet and NOT the whole file. As I said all my sheets have different margins and layouts, I can not combine them into a single sheet.

View 2 Replies View Related

Generate New Document

Nov 12, 2008

I have an excel document that is a form.

Can I use the data collected from this form to generate another new document?

I want the user to enter some data and hit "Create" and a new excel document with that data is created.

Also, the new document has some data in it already. So it has some data and it will get new data from the form.

View 3 Replies View Related

How To Generate A Number?

Apr 27, 2009

here it is..

500 to 599>>>> equal t0 600
600 to 699>>>> equal to 700

the numbers from equals is the scale of the drawings which i use plot.

sample:

32039.98
31959.50 ...

View 9 Replies View Related

Generate Report With %

Jan 8, 2008

Analysis of Profit is very impt in business , that is why i keep trying to find way to use excel to generate profit report.

I have been trying to solve this for last one month. even when i bath... But no result.

May i ask any one here know how to convert my data to a report using . Below table said every thing.

Project (10)  HIJ1My Raw Data File  2BrandMonthProfit In %3Brand AJan 0730%4Brand BFeb 0750%5Brand AJan 0730%6Brand BFeb 0750%7   8   9I Need Report In New Work Sheet  10   11BrandJan 07Feb 0712Brand A30%30%13Brand B50%50% Excel tables to the web >> Excel Jeanie HTML 4

View 9 Replies View Related

Generate A Word Doc

Jun 9, 2009

I have a macro here that is not working becuase User-Defined Type not Defined. I think i understand it but i want to make sure and if there is any advice for the macro below even better.

what is in red below is what i think i need to identify as Type /end Type.

these are named cells from my data page.

Sub Makeworddoc()
' create a word doc
Dim wordapp As Object
Dim data As Range, message As String
Dim Notes As Integer, i As Integer
Dim Participant As sting, POC As String, phone As String, Email As String, Staff As String
Dim Contact As String, When As String

The rest of the macro is

' Collected information from worksheet
Set data = Sheets("data").Range("A13:G13")
Notes = Sheets("data").Range("notes")
' updated status bar
Application.StatusBar = "Creating Word Doc."
' assign current data to variables.............

View 9 Replies View Related

Generate Unique ID

Jun 17, 2006

on generating a unique ID for each row in a spreadsheet. My current manually entered ID numbers are alpha numeric, so I want to use a formula or macro to follow the same format.

For example the IDs may be ABC001, ABC002, AAA001, AAA002, AAA003. So user enters info in a form built in excel, and I run a macro which takes the data entered into that form and populates another spreadsheet and I assign an ID number.

The ID number should look for the next number in the sequence, based upon the first three characters.

View 4 Replies View Related

Generate All Possible Combinations

Dec 28, 2006

Is there an Excel Addin that will let me figure out the total number of combinations for any size number pool I specify (39,49, 53) and with any combination quantity I specify (3, 4, 5, 6)? And most important is that all these combinations be displayed in a column separated by commas.

Is a VBA script designed to handle something this complex.

View 9 Replies View Related

Generate A Chart With VBA

Feb 2, 2007

I am working in a Lotus notes application that enables me to add an Excel report and chart. I have no problem adding a report using their template creater. however it says for me to add a chart I have to create an excel template that must contain the vbscript needed to generate a chart.

I tried using the macro editor to create the report but i get an error "Microsoft Excel Select method of range failed".

View 3 Replies View Related

Vba Programming Generate List?

Nov 18, 2012

I am looking for a code to generate a combinations of x numbers taken 5 at the time. t

View 2 Replies View Related

Bar Charts Generate With Some Requirements

Jan 5, 2014

What is my requirements in the attached snapshot and excel file .

Please check the attachment. Charts.JPG

View 1 Replies View Related

How To Generate A Status Indicator

Apr 29, 2014

I have a sheet with work tasks on. Column I shows the completion date for each project. In column J I would like an automated response linked to todays date. Can we use row 2 as our example? So I need in this case cell J2 to show the following:

- If todays date is more than 5 days before the completion date (in cell I2) I would like the cell J2 to show "IN PROGRESS"

- If todays date is less than 5 days before the completion date (in cell I2) I would like the cell J2 to show "AT RISK"

View 4 Replies View Related

Generate Random Numbers?

Aug 19, 2014

I am creating an excel spread sheet for a project I am doing, I need to create a daily chart for 6 months of water usage that results in averaging set targets.

I have made a chart with the average uses per day but would like to have daily numbers that average out to what i have but in a random sequence e.g. i have that a shower uses 320 litres per day for 2 people is there a way i can make a chart that says: 300 (a1) 340(a2) 260(a3) 360(a4) etc i need to do this for 180 days with random numbers generated to average the same overall. I dont know even how to generate random numbers.

View 4 Replies View Related

Is Excel Can Generate Form

Mar 31, 2014

As you can see I have only one attached file which has a two sheet tab, one is the "DATALIST" and the other is "FORM" in which this tab will be the one to be generated with blank highlighted yellow, and get data from datalist tab.....

View 4 Replies View Related

Auto Generate Passwords

Nov 24, 2008

Is there a way to auto generate passwords? I would like the result to start off with the word "cook" and end in numbers. Is this possible?

Password: cook###

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved