Tracking Spreadsheet - Pop Up Window Entry

Oct 28, 2013

I am currently producing a work number tracking spreadsheet for the people I work with and wanted to know if there was a way to generate a pop up window that created fields to enter the data for the job being inputted.

I currently have it just a simple macro (below) that enters a new line, adds a sequential number and adds both the date entered, as well as an expected finishing date. It does what I want it to do, however I am looking for it to be fool-proof as the last system was broken as people didn't fill it in fully.

Code:
Sub New_Line()
Range("A4").EntireRow.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
Range("A4").Value = Range("A5").Value + 1
Range("C4").Value = Now()
Range("D4").Value = DateSerial(Year(Now()), Month(Now()) + 1, Day(Now() - 10))
End Sub

On the previous system it used a worksheet that did similar, with dropdown menus that auto-filled the sheet as well as inputted into the spreadsheet. That was produced by an old employee that isn't working on it any more.

View 7 Replies


ADVERTISEMENT

Tracking Who Opens Spreadsheet

Dec 19, 2007

I have a spreadsheet that can't be password protected but this doesn't mean just anyone should be accessing it. Is there a way to record who opens it and when? Ideally I could place some code into the spreadsheet that recorded on a sheet who has opened it and when. This will detract certain nosy people from accessing it!

View 9 Replies View Related

Inventory Tracking Spreadsheet

Jun 28, 2007

A friend of mines wife has decided to get into MaryKay and he is wanting to create a spread sheet to keep track of the product she has.

He wants to be able to enter the product in and at the end of a show subtract whatever product she sold with a sheet showing what she has in stock.

View 6 Replies View Related

Call And Sales Tracking Spreadsheet

Apr 5, 2011

I am in sales and we currently have a excel spreadsheet with call tracking and a sales tracking on it. I would like something a little more inviting. We have quotas that we have to meet. 100 calls a month, 20 quotes to put out, $11k is sales.

I was thinking maybe something that was broke down by week for calls. The sales and quotes, have a graph associated with them. When we type in the dollar amount it will raise the graph that much. I think this will make it easier to manage. I have attached what our call tracking looks like now.

View 3 Replies View Related

Formulas For Baseball Tracking Spreadsheet

Jul 3, 2007

My spread sheet reads column A teamname, B games played, C wins, D Losses, E Ties, F winning % and G GAMES BACK

I'm looking for a formula to determine games back based on wins, losses, ties and also based on the number of games played.

example, team 1 played 9 games and is 8-0-1. Team 2 has played 9 games and is 8-1-0. Team 2 is would be a 1/2 game back. Team three is 8-0-0 also a 1/2 game behind team 1 but tied with team 2.

So in column G it would read team1 "-", Team 2 ".5" and team 3 ".5"

View 9 Replies View Related

Count Formula- Spreadsheet That Is Being Used For Tracking Work Completed Each Day In A Week

Apr 9, 2009

I have a spreadsheet that is being used for tracking work completed each day in a week. Each day has 5 columns and 10 rows of data to potentially be entered, some of the data is text and some is numerical. Can anyone help me come up with a formula that will count the text and the numerical entries for each day? I tried to use a nested if statement but it exceeded the number of nestings available. The range of cells for the first group is B6:F16.

As a side question, will count work for a range of data or only one column or row at a time?

View 9 Replies View Related

Filtering For Summary: Produce A Spreadsheet For Tracking Pupil's Progress Through A Year At School

Oct 6, 2008

I'm trying to produce a spreadsheet for tracking pupil's progress through a year at school (Targets/Predictions etc) but am having some problems with creating a summary of data gathered for each pupil. I have attached the file for your perusal; On the data entry sheet staff will fill in the appropriate data, and on the summary sheet I am looking to generate summaries for each pupil (I have set up how I want it to look). This may sound easy, (and probably is); the issue is that there are around 30 subjects in total, but pupils will only have be doing 5 of them, I need the summary sheet to show the information for subjects they are taking only (It should come up with the subject name under the headings subject1/2 etc and the appropriate grades to go with them, missing the blanks out. Obviously I could do this by cutting and pasting for each pupil...But there will be almost 2000 pupils in the list!!!

View 4 Replies View Related

Add Entry To Spreadsheet

May 28, 2006

I have an Excel VBA interface, with buttons and list boxes. I have been trying, with little joy to create the code to copy the content of the text box into a field on an Excel spreadsheet.

View 4 Replies View Related

Automatically Create New Row With New Entry From Different Tab / Spreadsheet?

Mar 24, 2014

I've got a master spreadsheet grabbing data from 12-13 different tabs/spreadsheets.

One of those has a table, and I was wondering:

Is it possible for the master spreadsheet to automatically add a new line every time someone adds a new line and creates a new entry in a different spreadsheet?

In other words,

If there is a table in the master spreadsheet, and someone adds a new line, is there a formula which allows the master spreadsheet to add a new line in order to autopopulate?

View 7 Replies View Related

Reverse The Order Of Entry Into The Spreadsheet?

Oct 4, 2013

I have a user form and in my code I am using the Erow function

EROW = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

the form works fine and is loading the data to the spreadsheet and inserting it into the first empty row. I need to reverse the order of entry into the spreadsheet. So instead of the data from the form going into the first empty row down the spreadsheet, I need to insert the data in a common fixed row at the top of the sheet, every time and then shift the older data out of the row and down the sheet. Essentially putting the oldest data at the bottom and the newest at the top, which is reverse of the EROW entry process, Last row command would essentially do the same thing and I don't know what command would do what I want.

View 6 Replies View Related

Data Entry Order Spreadsheet

Sep 23, 2009

I am building Food Stand Orders Record Table, which I would like to automate and reduce the data entry process as much as possible so that it will take as long to enter all 400 orders into the spreadsheet and mitigate errors and calculate totals. I am looking for ideas as to how to make this easier to update. Also, I am not set on the concept of the spreadsheet, if there is a better way to capture this data.

Below is a list of columns in my Order Record Spreadsheet: My spreadsheet start on A5. The Header row is A5:N5

No. = record input number
Order # = The number of the order taken (i.e. 35306 – 11, 35306 – 12)
Item = The Items sold from each order #
Item Category = Was the item sold a special order or standard order
Date = The date the items and orders were sold
Time = The time the order was taken
Quantity = how many of the item was sold for that order #
Order Taker = record of who (order taker) took the order #
Item Price = What is the price of one unit x the quantity of the item sold
Total Order = What is the total cost of each item price associated with the same order #
Cash Received = We only accept cash, what was the cash tendered with the order#
Change = What is the change amount given to back to the customer associated with the order #
Donation Received = Is the change amount, When customer associated with order# did not accept the Change.
Notes = special notes related to the order#

View 15 Replies View Related

Excel 2010 :: Who Saved Last Entry Into Spreadsheet

Jul 14, 2014

We have a spreadsheet on a server.Without using code is there a way to show who saved the workbook last?

using 2010

View 1 Replies View Related

Use Data Entry / Search / Edit For Spreadsheet On Excel

Aug 9, 2012

I have created an example of a "Waiting List" for the college, everything I had done seemed to be working before I left for my holiday (apart from the search facility as I was still doing some problem solving, compiling and coding for it).

The Idea is to : Open Excel Document and be greeted by the "Hello" Userform

[Problem #1: This does not automatically show since I have returned from holiday, though there seemed to be no problem with it prior my escape.]Choose from three options;"Save and Exit" saves any changes on/in the database and closes the document"Insert Data" opens "Userform1" to allow users to enter a new row under the exsisting rows of data.

[Problem #2: The data in the sheet was all entered using this feature, but yet again since I have returned from holiday it keeps adding the data only on row 2]

[Problem #3: How to do Auto Formatting i.e. Postcode in Capital Letters]"Search" will open the "Search" userform which I hope to allow users to choose up to three column headings and enter the value to search that column with the parallel textbox value.

[Problem #4: The data which meets the criteria the most is listed into the listbox, if you select a piece of data (double click or "selected") it opens a new userformThe "Edit/Enrol" Userform allows user to Edit, Enrol or archive the row of data.the last Userform I created "Course" is for an admin of the workbook to choose a course and it be auto populated by the information in the worksheet "Code" and create a Mail Merge.

View 9 Replies View Related

Copy Data Based On Cell Entry To Different Spreadsheet

Nov 10, 2008

i am trying to find a way to automatically copy information from a worksheet on my computer([list.xls]-List of accounts) to a worksheet on a shared folder([summary.xls]- accounts that have paid)

example:[list.xls]Sheet1!A:A has account numbers, C:C has account balance and D:D has notes on account.
If D:D is "paid", copy acc# to [\foldersummary.xls]Summary!A1, balance to B1 and notes to D1.

If D:D is "payment pending" do same as above but in row 2 and so on.

View 4 Replies View Related

Make Userform Show Data From Spreadsheet And Add Delete Or Make New Entry

Jan 24, 2014

I have a spreadsheet on sheet 1 with a list of customers and their information. So on column A I have the customer number (i.e. k968, e37, p528,...), on column B i have the customer's name, on column C the street's name, on Column D the house number, on column E the zip code and finally the city on column F.

Right now there are around 600 customers in this list.

I have made a userform with a combobox in which I want to select an existing customer (pulled from the spreadsheet). On the same userform I have textboxes (customer number, name, street, number, zip, city). When I select a customer in the combobox, I want this customer's info to show up in the textboxes. I want to be able to change the info and hit Next to store the changes in the spreadsheet. When I do not select a customer from the combobox, I want to add new info in the textboxes and hit Next to store this info as a new customer. The userform also has a delete button. Then I select a customer in the combobox, this customer (and it's info) should be deleted from the spreadsheet when i hit Delete. So the spreadsheet is variable in length.

View 5 Replies View Related

Getting Entry In One Cell To Cause Entry In Another Based On Entry In 3rd

Mar 20, 2014

I have a percentage in R3.

If I make an entry in D13 then I want the R3 to be duplicated into C27 otherwise C27 should be 0.

View 4 Replies View Related

Check If Any Entry In List Older Than 7 Days - Delete Second Double Entry?

Sep 11, 2013

I am having a sheet where I keep track of when online surveys have been sent to users. The users enail address (column K) may be on the list for several times, but I need to make sure that there is at least a 7 days pause between sending the first mail and the second, depending on the visit date (column G).If there are less than 7 days between two entries with the same email address, the user is not qualified for taking another survey.

I was thinking to write an IF formula which returns either 1 or 0 and then let conditional formatting highlight and HIDE the row via a VBA loop.

View 3 Replies View Related

Formula To Look For A Number Entry On One Worksheet And Return Another Fixed Entry?

Mar 14, 2014

Is there a formula that will allow me to look for the existence of any number value in a row of one worksheet and then return a specific number value in a cell on another worksheet? For example, if the formula finds any number value it will always return the number 15 to a cell on another worksheet.

View 3 Replies View Related

Tranferring Variable Entry From Form Entry To Macro

May 1, 2009

I used a form with textboxes for data input for one of my vb macros. Currently I have the private sub from the form transfer those entries to a remote cell on the spreadsheet, (like in column "HZ"), so that the macro that will actually utilize them can retrieve them. Is there a way to pass that data directly from what is entered in the form in the textboxes to the macro that will actually use them?

View 4 Replies View Related

Tracking Changes To A Log Across Workbook

May 28, 2013

I am looking to track changes on a "Log" sheet throughout an entire workbook. The following code (found here and given below) will give me:

The cell . The date/time it was changed . What the new content in that cell is

The two points I would like it to include, in order of importance, is: The name of the worksheet that cell exists in. The user that made that change*Bonus points* a hyperlink that'll bring me to the worksheet that was edited.

VB:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim r As Long, OutSht As Worksheet
Application.EnableEvents = False
Set OutSht = Sheets("Log")

[Code] ......

View 7 Replies View Related

Inventory Tracking

Feb 12, 2007

I have a worksheet that has multiple units listed on it. Each unit has a materials used list with quantities. I want to reference this column to another sheet and get a total materials needed list and also reference it to my inventory and subtract that number from my materials on hand. how can I do this?

View 6 Replies View Related

Inventory Tracking ...

Jan 29, 2010

So far I was able to find solutions to all of my small problems with excel just by searching here but with this one I need help and ideas how can it be done differently.


We need to track inventory from when its taken, when it was installed and we need to know every month when inventory is counted how much do we have on hand in our truck....

View 7 Replies View Related

Tracking Changes In Workbook

Jun 28, 2006

I'd like to make a vba macro in excel which will be just like "Track changes" feature. I'd like to track changed cells and when and who did it. (Date, User, Cell, Last value, New value). It is important to make a report in separate worksheet and automatically fill this worksheet when the user save changes.

View 5 Replies View Related

DDE Change Tracking

Dec 2, 2006

Aaron Blood has created an excellent DDE Change Tracking.

The file is in the download area of [url]

The macro, in the xls file, archive the data from top (a1) to the End of the worksheet.

I want invert the way to file/archive the data… copying all the cells already filled, a cell down and filing the top ( A1...) with the last DDE value (In the TracK sheets).

How can I do that?

The primary code is:

Sub Change_Tracker(Watch As String, TrackOn As String)

Dim NextCell As Range, r As Double, c As Double

With Worksheets(TrackOn)
r = .Rows.Count
Set NextCell = .Cells(r, 1).End(xlUp).Offset(1, 0)
End With

View 4 Replies View Related

Reservation Tracking

Jan 3, 2007

I manage a small motel with 6 rooms and I'm trying to write a simple program to track my customer reservations including their details. All the commercial software is too elaborate and way out of my price range. I'm slowly learning excel but this has proved beyond my capabilities.

View 9 Replies View Related

Tracking Paid Transactions

Mar 25, 2014

I want to create a spreadsheet that I can export my transactions from my credit card onto -- is there a way to make it so that the transactions that haven't been covered by my most recent payment(s) are red, while the ones that are paid are green without manually going through & doing it? I know there's the IF, TRUE, FALSE formulas, but I'm confused on how to use them.

Basically, if I spend $1,000 between 5 transactions and make a $400 payment, I want the oldest transactions totalling up to $400 to turn green, while the remaining are stay red until a new payment is posted.

View 1 Replies View Related

Change Tracking Automatically

Aug 21, 2007

I have a spreadsheet i would like to have changes tracked to automatically. I know it's only a matter of clicking a few buttons to get this to happen, but i was wondering if there is a way to have excel do this by default when i open the file. I would also like to have the changes highlighted automatically.

View 9 Replies View Related

Tracking Updates And History

Feb 5, 2014

I have an actions tracker worksheet.

I want to type status update for an action - then when I press enter it should automatically as soon as I press enter:

- cut the text I typed from the cell leaving it blank
- move to the target cell (its in the same row) and "add" that text string (with a date stamp added) to the text already in the target cell.

Every day I type an update against the action in the first cell - and I press enter - it should copy that text into the target cell.

That way I have a complete history of updates against the action with date stamps.

Sounds pretty simple but I don't know where to start.

Example of a simple worksheet attached : Tracker.xls

View 2 Replies View Related

Tracking Open Trades

Feb 20, 2009

I want column J to reflect the total amount of all trades which were open at the time the trade on the row is closed.

(the data is sorted according to closed trade times).

So while the trade on row 4 is the first trade to close, there were other trades also open prior to the closing. I need to show the total amount in column E of all trades which were open during the time window that the trade on row 4 was open.

View 4 Replies View Related

Tracking My Employee's History Of Changes.

Apr 1, 2009

I am using excel as point of sale book (to record customer name, service, and total price etc.) at our hair salon. We have employees that may be there to manage alone from time to time, and enter clients into excel.
Our worry is straight forward, and involves them erasing what they wrote. I am confident that the actual service and price is entered at the beginning, but want to track their changes to their own entries.

The "track changes" would work if it "tracked changes" after entry. But it seems to track the last change from saving. For example....the employee enters $40.25 presses enter--after she knows she can get away with a change, she may erase it altogether or change it to say $16.75.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved