Automatically Insert New Row For New Info
Apr 4, 2008
The spreadsheet is used to keep track of shares that are purchased / sold
It will make all tax calculations as well as provide a single statement showing all transactions rather than having to sort through dozens of individual statements.
I seem to have most of it working but could use some help with the following.
I would like to be able to have a spot (maybe on a separate worksheet) where you could enter the four items from which everything else is derived, share price, date, number of shares and whether it was a purchase or a sale, and have it automatically:
1. add a new row (complete with formulas and formatting info) to display the new information
2. sort the new data to fit into the right spot in the spreadsheet by date.
View 8 Replies
ADVERTISEMENT
Feb 6, 2014
Attached is a sample of what I need completed.
Monthly, I have to do a chart just like this except slightly more complicated.
In the Sample download, there are three charts, "Sample Chart", "Sample Input", and "Desired Result".
"Sample Chart" has a list of accounts from different companies, The first column being their number, the second being their name, and the third being the money they spent.
The "Money Spent" Column is always blank when I start for ALL companies.
I have another chart, "Sample Input", which contains the prices that I'm supposed to put in "Sample Chart, Money Spent" column.
The thing is, "Sample Input" only has the companies with prices listed.. Not all companies have prices, so this means the "Sample Input" is always a shorter list than "Sample Chart".
What I need is the prices from "Sample Input" to be put in the correct position in "Sample Chart". The "Desired Result" chart is what I want it to look like.. exactly like that!
When I do this monthly, I have to scroll through several thousand accounts doing this.
Suggestions:
- Possibly have a macro or formula take the Account # in "Sample Input".. Sample it in "Sample Chart", then copy the price and paste it in the right location.
- Possibly make "Sample Input" have blank rows inserted in the places where it should have the account with no prices.
View 5 Replies
View Related
Jan 14, 2010
to be able to do is have a stock control sheet that tells me how much of 1 item we have in stock which is easy, the hard part comes when this stock is sold as this stock can be sold to a number of different customers e.g.
We have 10,000 X Pens
Customer 1 buys 1,000
Customer 2 buys 6,000
Customer 3 buys 3,000
i need a way of saying that we have 10,000 pens but if we sold 1,000 then we can click a button (macro maybe) and that will automatically see that we have 10,000 for that line and we have only sold 1,000 so we need a line inserting saying that we have 9,000 remaing and so on.... The sheet needs to record who these goes to though, that the reason i was thinking of adding a row
If this doesnt make sense then i am happy to answer your questions?
i can upload an example excel sheet if required if someone can explain how i do this?
View 14 Replies
View Related
Sep 4, 2008
I have a very simple userform that has name, address, phone, etc.
I want the command button the insert the info from the user form into certain cells in my spreadsheet then clear the info out of the userform and close it.
View 13 Replies
View Related
Dec 4, 2013
So i have two sheets with user info and so on, my boss asked me if i can transfer person names from sheet1 to sheet2 but each name must be in correct place acordingly to username column
Capture6.jpgCapture7.PNG
in capture6: in F18 you see 139401arle and G18 is supposed to be his name but it's in other shhet as you can see
in capture7 his name "Ar Sveinung Leira" is in E5
is there any way to transfer names so that they go in right place?
Kopi av Computer List - 02 12 2013.xls
View 4 Replies
View Related
Sep 24, 2007
I have a workbook with a Cost Analysis sheet, a master menu sheet, and then all the sub sheets. I have coded command buttons on the master sheet, so once a category is selected, it goes to the appropriate sub sheet. On the subsheet is a list of items of varying sizes, and command buttons beside that which will allow the user to "Select" that particular size. Once the size is selected, the verbage in cell B5 plus the verbage (size) beside the selected amount, and the prices (labor and materials) in the next two columns, need to be transferred to the first available blank line, starting with line C5, to the Cost Analysis sheet. I have never done coding before for a Loop (i.e. For i = ???) and am not sure how to get it to do what I want. After they select that, they can pick a command button that takes them back to the master menu so they can continue picking various items until they are through. Then the Cost Analysis sheet will show all the items they picked, (name of item, material cost and labor cost: Columns B, C, & D). Not everything is coded yet (such as selecting a command button to go back to the main menu, because I wanted to make sure I could solve this problem before doing the easy stuff).
I read over quite a few of the previous threads and am not sure how to change them to suit my circumstance. I know some code (VB), but not much. I do not understand the concept of DIM, and how the loop works to make it happen myself, and all the websites I could find were not suited to my situation of copying three cells of data to the first blank cell on another sheet.
View 9 Replies
View Related
Nov 5, 2009
problem with Excel and I have no idea how to solve it. Hmm, how do I explain this? Someone is giving me data pulled from a server in an Excel format. I have a column that has a series of entries.
For example:
Blank
Entry 1
Entry 2
Entry 3
Entry 4
Entry 5
However, sometimes there's an entry or two missing. So it'll look like this:
Blank
Entry 1
Entry 2
Entry 4
Entry 5
Is there anyway to tell Excel to say "Hey there's an entry missing here," and have it insert a row with the missing entry value? I do not work in Excel ever but people around here do, in case someone has some advice. I already asked the guy if he could just server me the data formatted correctly, and -- of course -- he can't/won't.
View 11 Replies
View Related
Aug 9, 2002
I created a form in which I can enter data that is totaled at the end. Is there a possibility that a new row is inserted at the end of the form automatically every time I enter data in the last field?
View 9 Replies
View Related
Jul 15, 2014
I have two separate tables, one above the other, and need a way for it to automatically shift the second table down or a row between the two tables any time another row is added to the top table. Is there any way to do that?
View 2 Replies
View Related
Jan 15, 2010
I'm trying to insert pictures automatically on Excel 2000 but i still with problems to find the better solution, please see the file with a better explanation.
View 6 Replies
View Related
Mar 23, 2012
I am trying to keep my checkbook in excel and want to make a spreadsheet that inserts a row every time I hit enter. That way my most reason transaction and balance is always at the top rather than the bottom of the spreadsheet... The inserted row should have the same formulas as the row below.
View 7 Replies
View Related
Aug 21, 2013
I have an expenses sheet where I would like to add something I saw on a template...
press "tab" in the last populated cell of a table to insert a blank row. (below or above, it doesn't matter) So I can add the next expense.
View 1 Replies
View Related
May 21, 2014
Any way to have the worksheet name on a tab inserted automatically in a cell on the spreadsheet? I have a file used to record orders and I have to keep inserting new worksheets for each order. I want the name on the tab of each worksheet to show in cell A1 so when I copy in a new worksheet A1 will show Sheet 1, for example. However, when I rename the worksheet I want "Sheet 1" in A1 to change to the new name.
View 2 Replies
View Related
Mar 17, 2007
I have number of column.Say 10 columns. in Column say J5 I have word daily varience. I want a macro to check word daily varience and go 2 steps to the left and insert the column.
View 9 Replies
View Related
Feb 7, 2008
I'm unable to find VBA code to insert a blank row when the value in Column L changes. For example if cell L2 = 400 and cell L3=500 I need to insert a blank row between L2 and L3. I need the macro to search the entire sheet which will have variable numbers of rows but Column L will always have data.
View 3 Replies
View Related
May 12, 2014
I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
View 3 Replies
View Related
Aug 22, 2014
I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
View 1 Replies
View Related
Dec 16, 2008
I have a sheet that counts stock, in cell I5 i have week 4s results in k5 week 5s. what I need is in cell N5 the number in I5 if their is no number in k5 but if k5 has a number in it I want that number in N5
View 14 Replies
View Related
Jul 6, 2006
Is there a way you can copy formulas to the next line when a new entry is automatically added to a spreadsheet via a form?
View 1 Replies
View Related
Jul 28, 2014
After importing a data set into the worksheet entitled "SPACE", I am trying to find the column entitled "Variability Cpu" and then for every cell in that column that has a value in it, I would like to insert a new row beneath that cell. I thought my code made sense, but I get the "Run-time error '424': Object required" error on the line in red below so apparently I'm missing something. why I'm getting this error (doesn't the object variable shtS refer to the worksheet object "SPACE"? Why is it saying object required?). Here's what I've got so far:
[Code] .....
View 5 Replies
View Related
Dec 18, 2008
I have a column called "Unit Size," which contains data such as 200 g, 0.32 g, 15 mL, 2 mg.
I need a macro to automatically insert a space between the numbers and the letters, for example, if someone types 10g it automatically converts it to 10 g.
The strings may be of different lengths, i.e. contain different numbers of decimal places or signficant figures.
View 4 Replies
View Related
Sep 24, 2009
I have a column full of numbers e.g. 1,2,3,4,5,6,7 etc..
i need to run a program that automatically goes down the selected column and places a hyperlink based the number in EACH cell. e.g. if the cell number is 4, then the link should be
http://www.somsite.com/4
each cell has a unique number
basically i need a macro that can do the following:
for all cells selected in column
get first cells
get info from cell
insert hyperlink+info;
increment cell
end
View 5 Replies
View Related
Aug 12, 2006
I have a running worksheet to account for expenses and deposits. At the
bottom of the sheet are the total values. I have to keep "inserting" rows to
move the values further down the sheet.
View 9 Replies
View Related
Feb 1, 2013
How to make excel automatically insert a comment into a cell when a / is entered into that cell?
The comment needs to simply include the date the / was entered and nothing else.
View 8 Replies
View Related
Nov 25, 2006
Is it possible to enter a number into a cel as: 12345 and have it display as 123.45.
View 10 Replies
View Related
Dec 2, 2009
How do I automatically insert rows given the identified quantity to insert and copy the contents of the previous item on the insert rows. Does that make any sense
a1 - abc
a2 - def
a3 - ghi
I need to insert 10rows below a1, and copy a1 across the inserted rows. Now I have a ton of this case currently do it manuaaly, it might take me a lifetime to complete.
View 5 Replies
View Related
Sep 6, 2013
Is it possible with excel, to automatically insert an employees number if their name is inserted.
Example:
Column A If Smith, John is entered in Column B automatically have his employee number show 5668?
Joe, Mary entered in Column A Column B to show 12345
This would save me a huge amount of time going back and fourth.
View 3 Replies
View Related
Mar 14, 2013
I need to create a spreadsheet which will have a start date and duration on programme. Is there any way I am able to automatically insert the End dates based on the weeks on the programme?
Additionally, can a function insert a date for the reviews which should be every two weeks into seperate cells?
Name
start date
weeks on programme
End date
1st review
[Code]...
View 1 Replies
View Related
Jun 7, 2014
Basically, I am curious if I were to insert a value into say cell A1, is there any way B1 could display a picture I've saved. To be a bit more specific, A1's value would be 777, and B1's inserted picture would be 777.png saved on my PC. This would need to apply for the whole of the sheet for all the values in column A.
View 5 Replies
View Related
Sep 8, 2009
Can anyone help? I need to achieve the following involving the insertion of rows from a specified value reference within the worksheet to which the rows are being added.
The original data would look like:
ABCDEFG1PeterABC, DEF, GHI32DavidABC, DEF23SamABC, DEF, GHI, JKL44TomABC, DEF25
The number of rows to be inserted under each entry is listed in column "C" (which is a count of the separate entries in column "B".
The output data following the application of the "solution" would need to look as follows:
ABCDE1PeterABC, DEF, GHI3ABC2DEF3GHI4DavidABC, DEF2ABC5DEF6SamABC, DEF, GHI, JKL4ABC7DEF8GHI9JKL10TomABC, DEF2ABC11DEF
Where the specified number of rows have been inserted underneath the original entry and the separate values in column "B" have been listed in consequtive cells, relating to their original entry in column "D".
Can anyone suggest code to achieve this outcome?
View 9 Replies
View Related
