Welcome to the Forum - Here you should find the solution to your problem......
Firstly it is simple to run a macro which can be fired by a number of means to delimit a file. ie
Selection.TexttoColumns Destination:=Range("A1"), DataType:=xlDelimited, _
This will delimit a range of data by using a comma delimiter. The data will then be placed accross the colums in row A.
I'm not sure how you intend to input your data but again you can import data as shown below - this is from a text file.
' setting up constants
Const ForReading = 1
Const TristateUseDefault = -2
'dimming new objects etc
Dim newobject, file, data, datastring
'creating a new object
Set newobject = CreateObject("Scripting.FileSystemObject")
'setting up the file so it can be found
Set file = newobject.getfile(ThisWorkbook.path & Application.PathSeparator & "textfile.txt")
' opening up the textbox for reading only
Set data = file.OpenasTextstream(ForReading, TristateUseDefault)
'setting the data to read the line of info
datastring = data.readline
'closing the textbox
'now loading the datastream into the cell and delimiting it
.Value = datastring
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
You would then need to have the math either set into the cell location or use VBA to wright the equation you were after.
and to re-name the work sheet, this would be done after the data is delimited and set simply by the following:
Sheets("sheet1").Name = Range("A1").Value
ActiveSheet.Name = Range("A1").Value
Hope this is what you were after - Phil
Video Tutorials / Excel Dashboards Reports