data entry

I have a Workbook that contains 7 works sheets, when the data is entered into one of these worksheets I would like the Data to be automatically entered into a monthly summary worksheet, i do not want to just to be a copy and paste though just case data in one of the seven have to changed it...

Hi, I have a database and have made a form that can be used to fill it in. However, some of the columns of my database use formula's to create their entries but when I press ok on my form it inserts my data on a new line as intended but the formula does not automatically be inserted to the new...

i need a data entry form that adds records to another sheet <TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448><COLGROUP><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 5741" width=157><COL style="WIDTH: 218pt...

Hi all, I'm trying to design a table for data entry. Line items (outputs) are pre-populated, and it is up to the user to specify which, if any, function they perform by choosing selection objects from various columns. Depending on other data, I want to control what the user is able to...

When I run the following userform code, it will run once. After that I receive a Run-Time error '-2147417848 (80010108)': Method 'Value' of object 'Range' failed. After clicking end on the prompt, Excel locks up and I have to end the process. Upon opening the document, the data for the second...

Hello, I am using Excel to manage the sales data and inventory for a restaurant. I know that a database would be a more appropriate tool, but the owner is cheep and that won't happen. The problem I am running into is that what is easy for data entry is not ideal for creating pivot tables...

Hi fellas, I am trying to accomplish a warehouse data entry, where at the end of the row a macro can be activated to send the data entered to a preset label tamplate. This preset label, along with its cells, is to be re-usable for the next row of information; which again would be sent by the...

I am hesitant to post this, but my searches on the forum/web are coming up fruitless... I am trying to create a Whiskey/Wine/Beer journal. I have created a spreadsheet that will allow me to enter the info/rating/attributes to each drink and develop a visual (radar graph, color scale...

I'm trying to calculate the average of B2:B12, minus any cells that do not equal 100 or more. For example: 34 (does not meet requirements for this formula) 114 156 158 153 160 132 152 153 159 136 What formula can I enter into the specific cell that would return the average of 147.3? I know how...

I have created a graph in excel. Sheet one contains the information and sheet 2 the graph. I have the potential to have 10 data entries to be graphed; however, it will take 10 weeks to get all 10 data entries. The graph will be printed periodically within the 10 weeks. If I only have 4 data...

Hello, I'm new here and have only been using Excel for a short time, I have however taught myself quite a bit about it, but I'm stuck when it comes to macros and codes. Here's my situation, can you help me? I'm trying to create a database to store and sort sports statistics, ie football stats...

Hi All, I've only recently started working with Excel VBA, and am still a bit green behind the ears. I'm modifying a spreadsheet Data Entry for sales staff users to enter data via spreadsheet form. The form contains 107 data rows of numeric, string and date/time data. When a user runs the...

Is there a way to have a Cell drop down limit to a list of Taxt Values, but still allow any number input? I've got cells in one column that I use to track the amount of product left. I use text like Full, Empty, need to order, on back order alot so I thought to add those as Date Validiation to...

I have a data entry sheet which takes the input values from one sheet and dumps them onto another sheet using the following macro: Sub UpdateLogWorksheet() Dim historyWks As Worksheet Dim inputWks As Worksheet Dim nextRow As Long Dim oCol As Long Dim myRng As Range...

hi guys, I have a database of products (car parts) with description price, quantity etc. I am writing the descriptions, howveer need to include the compatability of the products. I am looking for a macro that will: Open a window with a drop down list of car types, followed by a tick box list...

I was wondering if it was possible to extract contact info from website and merge to a excel sheet. Now I have researched and played around with it and I found I can go to excel/data/import external data/new web query and I can merge a messed up group of info into couple cells, after deleting...

Hi everybody I have two cells A1: Birthday) and A2: Age) Using VBA I want A2 to display the age if i type the birthday in A1 using a formula like this one...

Ok, I think I am looking at this the wrong way, so I need some guidance from the more knowledgeable. I created a data collection workbook. Page 1 of the workbook is data entry, where a data entry person can enter about 50 cells of information. This data then fills in several formulas, and...