LinkBack URL
About LinkBacks
ziadkhan 
hi gys...
i wana generate a coulumn table from value to be put in a single input cell.... is it possible in a simple spread sheet without any programming ????
hi gys...
i wana generate a coulumn table from value to be put in a single input cell.... is it possible in a simple spread sheet without any programming ????
can you upload example workbook with your input and desired output?
Never use Merged Cells in Excel
zbor here is the example hope u get itOriginally Posted by zbor
actually i wana make maintenance expenditure sheet for my car.. what i want to avoid is scrooling though my mobile to go to the cell and feed value...i want that there is a single input cell at the top of column and i keep on putting the value in it and they come in tabulated form below that cell
Last edited by ziadkhan; 10-13-2012 at 06:25 AM. Reason: invalid format
zbor here is the example hope u get it
actually i wana make maintenance expenditure sheet for my car.. what i want to avoid is scrooling though my mobile to go to the cell and feed value...i want that there is a single input cell at the top of column and i keep on putting the value in it and they come in tabulated form below that cell
i uploaded the sheet. so nice of u for response..................
I get it but nobody want to retype data from the picture.
So can you upload example workbook?
If you are willing to do it in Access here is a database I prepared for someone else that keeps track of expenses related to his car. You can track as many cars as you wish. It does expenses by service and it tracks mileage and costs per mile.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
the problem is that iwana do it in EXCEL coz my mobile does not support access
It certainly should be possible. However, I cannot see from the pictures or workbook or discussion what the logic should be. What type of input value will you be inputting? What should each cell in the table do with this input value to generate the table?i wana generate a coulumn table from value to be put in a single input cell.... is it possible in a simple spread sheet without any programming ????
the yellow portion is of interest only . simple values like 200, 4000 etc and they should populate the table.... just this much...
Gys here is the most simplified example if u can help me create it.
i put value in hte cell and these values come in tabulated form below that cell
zbor ....
either the code is not Working or i did not understand....... i put value in c2 and paste the code in c17. i chages the value and it did not do any thing except the new value
Here, try this.
Enter something in C2 and use this code to write it at the end of range:
Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target <> Sheets("Sheet1").Range("C2") Then Exit Sub Application.EnableEvents = False Sheets("Sheet1").Range("C65536").End(xlUp).Offset(1).Value = Sheets("Sheet1").Range("C2") Application.EnableEvents = True End Sub
It's a macro function.
You must enable macro to use it.
basically, when you enter something in C2 it will appear at the end of list.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks