Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add new order
Hi,
I'm on a massive learning curve at the minute!! Lots of people want lots of Excel sheets making and because I understand slightly more than basics they are ocming my way. Here's my problem, I want to record orders that come in. I've set it all up so that if an order has not been passed on within a set amount of time from the day recieved it is highlighted as overdue. There is an Auto Filter to allow people to search. My problem is adding new orders. This is likely to only be done by one person. I dont want to copy the three formulas in the sheet down a couple of thousand rows as that makes it unnecessarily large and also finite. I was thinking of adding a dummy row at the top of the sheet, like a form if you will with a box for each column that will be added. I would then have a button with a macro attached that copied and pasted this information (inlcuding the formulas) to the next empty row. I am happy with making the macro to copy and paste but I dont know how to tell it to paste to the next empty row. Is this possible/is there any easier way? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add new order
Try DataFormNew option
When pressing Enter on the last field Excel places new data in the next available empty row. Regards, Stefi €˛Pyrite€¯ ezt Ć*rta: Hi, I'm on a massive learning curve at the minute!! Lots of people want lots of Excel sheets making and because I understand slightly more than basics they are ocming my way. Here's my problem, I want to record orders that come in. I've set it all up so that if an order has not been passed on within a set amount of time from the day recieved it is highlighted as overdue. There is an Auto Filter to allow people to search. My problem is adding new orders. This is likely to only be done by one person. I dont want to copy the three formulas in the sheet down a couple of thousand rows as that makes it unnecessarily large and also finite. I was thinking of adding a dummy row at the top of the sheet, like a form if you will with a box for each column that will be added. I would then have a button with a macro attached that copied and pasted this information (inlcuding the formulas) to the next empty row. I am happy with making the macro to copy and paste but I dont know how to tell it to paste to the next empty row. Is this possible/is there any easier way? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add new order
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell ).Row + 1 will give you
the row after the last one containing data. -- Ian -- "Pyrite" wrote in message ... Hi, I'm on a massive learning curve at the minute!! Lots of people want lots of Excel sheets making and because I understand slightly more than basics they are ocming my way. Here's my problem, I want to record orders that come in. I've set it all up so that if an order has not been passed on within a set amount of time from the day recieved it is highlighted as overdue. There is an Auto Filter to allow people to search. My problem is adding new orders. This is likely to only be done by one person. I dont want to copy the three formulas in the sheet down a couple of thousand rows as that makes it unnecessarily large and also finite. I was thinking of adding a dummy row at the top of the sheet, like a form if you will with a box for each column that will be added. I would then have a button with a macro attached that copied and pasted this information (inlcuding the formulas) to the next empty row. I am happy with making the macro to copy and paste but I dont know how to tell it to paste to the next empty row. Is this possible/is there any easier way? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a feeling the order of my formula is out of order....HELP! | Excel Discussion (Misc queries) | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |