Editing In One Tab And Placing Edited Data In Queue In Another Tab?

Jun 24, 2014

I have a simple Excel file composed of three tabs:

-EDIT
-QUEUE
-RESOLVED

On each tab, line 1 has the same headers: Status, Name, Surname, Issue, Details, Last Update

In the EDIT tab, line 2 is dedicated to editing the relevant information under the headers, and once done is validated with a "Done Editing" button: This button would cut line 2, and place it in line 2 of the QUEUE tab, moving down all the others in the list

The QUEUE tab lists all the issues keyed into line 2 of the EDIT tab. An "Edit Selected" button would cut the selected line (or the line in which a cell is selected), and copy it to line 2 of the EDIT tab for further editing, after which it would be placed on top of the queue once again as above.

The RESOLVED tab lists all of the issues marked "Resolved" on the Status column.

What I can't figure out are the macros for the two buttons:

- "Done editing" in EDIT tab adds today's date in the "Last Update" column, then cuts line 2, and pastes it in line 2 of the QUEUE tab pushing down all the lines in the list, and keeping any existing conditional formatting if possible (colours in the "Last Update" column, for ex.). If the status is set to "Resolved" before clicking the button, it does the same, but pastes it to line 2 of the RESOLVED tab instead of QUEUE.

- "Edit selected" in the QUEUE tab just cuts the selected line from the QUEUE tab and pastes it in line 2 of the EDIT tab.

View 2 Replies


ADVERTISEMENT

Restrict Editing To Certain Columns/Rows And Allow Some To Be Edited By Users

Oct 29, 2007

how do I restrict editing to certain columns/Rows and allow some to be edited by users?

View 2 Replies View Related

Check The Queue Number From Column H In Sheet1 And Change It To Queue Name

Jun 25, 2014

In the following code, in select statement Type & Type1 & Type2 defines queue number. And now in sheet2 , there is a list of Queue names and corresponding queue numbers. So When the data gets copied from Access to Excel using the code below then i want the code that will check the queue number and replace it with queue name in Sheet1.

[Code] .....

View 4 Replies View Related

Allow Data To Be Edited But Not Format To Be Edited

May 5, 2006

I have a cell that I am needing to allow users to edit the data but not the format.

The users edit the data by copying & pasting from their own personal spreadsheet. The source spreadsheet formatting can be varied. Is there a way to allow them to be able to edit the data inserted but not the format?

View 3 Replies View Related

Popup When Data Has Been Edited But Not After VBA Run

Apr 8, 2013

I've got a data sheet (called "data") which contain a bunch of data, if someone edits the data manually then a msg boxpopups. which i've done using the code below in the code on that tab. However, I also have vba that places data on the tab that also triggers the popup message.

So how do i make it such that if the vba is run then the popup doesnt appear but if they edit the data manually then it does?

VB:
Sub Worksheet_Change(ByVal Target As Range)
Dim WatchRange As Range
Dim IntersectRange As Range

[Code].....

View 3 Replies View Related

Userform Button To Update Edited Data?

Sep 13, 2013

I have been working on a userform for entering in and editing data in a spreadsheet, but I'm stuck with the code for updating the edited data.

I have two pages on the Userform, one for adding a new entry, and one for editing an existing entry.

On the page for editing an existing entry, I have a combobox that displays information in the text boxes based the selection. What I need to be able to do is click save once I have made changes to the information in the text boxes and then have that information saved in the spreadsheet.

I have figured out all of the other buttons in the userform, but I am struggling with this last one. Here is my spreadsheet with some sample information entered in : ExcelFile.xls

View 9 Replies View Related

Searching And Replacing Edited Data Back Into A Table

Jan 10, 2014

Basically I've got a back end worksheet with a huge table full of data (hundreds of rows, tens of columns) containing the data for a load of different contracts (each contract is on a different row).

I have all the information I want displayed on a front sheet by means of very simple lookups which looks for one contract at a time to display that information. What I would like to do is to be able to alter that information on the front sheet which will then go back and lookup that entry in the big table and overwrite the old data with the new. Effectively I want the excel sheet to act as a user form, but without actually using a form (a requirement from the people I'm doing this for). I'm struggling to find out how to do this as I don't know which VB functions I would need to use.

Each contract has its own unique reference number, so really what I need is some sort of code that will look for that reference number in the back end table, then look for any differences between what's on the front sheet and on the back end, and then replace anything that's changed.

View 4 Replies View Related

VBA - Distinguishing When Cell Is Edited By Data Validation List Or Free Format Text

Mar 20, 2014

VBA code which can distinguish whether a cell has been edited by:

selecting an option from a data validation list (DVL)
or
manually editing the text in a cell?

The ""Show error alert after invalid data is entered"" option is unticked to allow both selection from the DVL as well as free format text entries.

The problem arises when using the code below which makes an edited cell within a range display the new value as well as the prior value(s). This works well when using the DVL but not when editing the cell.

Is there any code which can distinguish between the 2?

[Code] ....

View 5 Replies View Related

Macro - Placing Data In Next Row

Mar 14, 2012

I have an excel file which I run every week. I am capturing the data from my last run onto a separate worksheet. I have a total of 5 columns.

Here's an example:

Date RunNumberValidNot ValidPending 3/2/20122723133/9/201224 0024

I want to leave the data already there static and move my formula to the next row when I run my macro. How can I do this?

View 1 Replies View Related

Placing Data Into Blank Cells

Jul 6, 2006

I know this is basic but I'm having a hard time here. I'm trying to insert certain data into a column of blank cells. I just need the fields to be on there once. As of right now it is pasting the first field multiple times.

Private Sub AA_Click()

If PS = True Then
Range("A61:A70").SpecialCells(xlCellTypeBlanks) = "Pull Stations"
On Error Goto 0
End If

If CS = True Then
Range("A61:A70").SpecialCells(xlCellTypeBlanks) = "C-F-A Switch"
On Error Goto 0
End If

View 3 Replies View Related

Creating Queue System In Excel

Oct 21, 2013

Any way to create a queue system in excel.

Here is what I would like to do:

Pull emails from outlook into a spreadsheet and click an add button that would add the From and Subject of the email to the bottom of the list with a timestamp showing the time the add button was pressed for that email. I would like the list to have the oldest timestamps stay at the top of the list, if possible.

View 2 Replies View Related

Matching Data From Several Worksheets And Placing In One Worksheet

Feb 24, 2010

I have rankings from several different sources all with different rankings for different people with a different number of people in each set of rankings.

I would like to match the names from each ranking set and place the corresponding ranking into one worksheet. I have done this without the code but over the course of the next couple of months the rankings will be changing.

I have them importing from the web so when they update I would also like for my rankings to update. Attached is the rankings each in their own worksheet.
The final sheet is what the end product looks like.

View 4 Replies View Related

Priority Queue - Ability To Delete Row / Entry?

Oct 29, 2011

I'm trying to get one more feature added to this priority queue tool that a forum member created. Essentially, this attached spreadsheet is a dynamic task/priority list that will change on the fly. See the original thread here: [URL]

The only missing feature is the ability to delete an entry and have all other entries below it change up a rank.

The attached spreadsheet is the almost completed solution

Example:

Original
-----------
Item D - 1
Item B - 2
Item E - 3
Item A - 4
Item C - 5

Remove item B
-----------
Item D - 1
Item E - 2
Item A - 3
Item C - 4

View 4 Replies View Related

Advanced Filter Placing The Result (the Filtered Data) In Another Sheet

May 29, 2006

Is there any way to use Advanced Filter placing the result (the filtered data) in another sheet??? I have tried but with no success... An error message is displayed (something like "It's not possible copy filtered data from a sheet to another").

View 4 Replies View Related

Macro To Create And Rename Multiple Worksheet And Then Placing Relevant Data

Feb 24, 2014

I want to find a way to create multiple worksheets and matching data to be placed on appropriate sheets.

Here are more details (Please check the attached sheet screenshot as well):

Excel_Macro_Requirement.jpg

In a workbook, there is a "Master-Sheet". This master sheet contains 8 columns.

I want to create as many new worksheets after master sheet as the values are there in column B (Column 2 i.e. Ad Group). In above attached screenshot, there are 8 values (B2:B9 or A-H). So, I would like to create 8 new worksheets after the master sheet. Also, I want to rename them based on their value from Ad Group column.

Each newly created worksheet should have same columns as the master sheet . Same 8 columns with their name intact.

Finally, I want all matching data of the Ad Group values to be placed on their respective newly created worksheet. For example, worksheet A should have A2:H2 data. Worksheet B should have A3:H3 data, and so on.

Please note that same ad group may have more than one row data. But I don't want to create multiple worksheet of same name ad group. The worksheet should be just one, but all matching data should be placed in that one sheet.

I know it is a bit complex task, but I am sure there would be a way to perform this automatically - probably a macro.

View 1 Replies View Related

VBA For Editing In Store Data

Jul 29, 2014

Currently We enclosed a Workbook (with exiting VBA code) In this workbook 3 sheet exit (Edit, Details, Summary)

In Details Sheet store Detail Entry of Invoice & in Summary Sheet we store all generated Invoice details in summary form

We want new VBA or correction in existing VBA.

My Exiting VBA work following..

When Enter Invoice Number in Edit Sheet (Cell B2) then Display Entered Invoice Data

First Code Find Invoice Number in Summery Sheet if Invoice Number found then Record Display of Selected Invoice

Here we Edit As per our requirement then We Press Y in Edit Sheet Cell C30

If Found C30 "Y" & "Data ok" in E30 then DELETE Selected Invoice Data From SUMMERY & DETAILS SHEETS & COPY THIS EDITED DATA (RANGE A33 TO G33 In Summery Sheet & Range A35 to A60 in Details Sheet)

My Exiting code work perfectly as per above

We want only following thing

Currently when we copy edited data that move to end of sheet We want to Change & same place where data exit previously before edited. Because serial number disturb.

NOTE : in Editing Time is it possible Few Item Delete or Few Item Add

View 12 Replies View Related

Form For Data Editing

Jan 29, 2008

I have 5 columns Data sheet in Excel and >5000 Rows. Time to time I have to change data parameter of some certain item (complete Row). I want to Database form (Userform) which can add new item, find and can modify, or delete from sheet. I Shown userform format in attachment without macro

View 3 Replies View Related

Editing Refreshable Data Tables From Web

Dec 4, 2013

I have multiple data tables that are linked to a site. My issue is that there are breaks in the data every 15 cells with a row that shows the column categories. I locked my top row so I don't need the recurring column categories at all, but when I delete them and refresh the data they reappear.

How to delete these rows? Could I possibly run a macro that deletes the rows upon hitting refresh? Or is there a simpler way?

View 1 Replies View Related

Editing Data Connections In 2003

Oct 20, 2009

I have a workbook with multiple worksheets and over 25 Data Connections using MS Query to connect to different tables in an SQL Server database.

The problem is that the SQL Server database is now being moved to a different server. The database name and the schema of the tables will be unchanged. Only the server name needs to be changed from XXXXX to YYYYY.

I have been unable to find a way to successfully edit the data connections in Excel 2003. A web search produced one potential option. However, that did not work for me very well. Thought the code is designed to cycle through all tablequeries and pivotqueries, the change is only made to one of the data connections. Here is the option I tried:

http://support.microsoft.com/kb/816562

Note that it is very easy to edit data connections in Excel 2007. So I also tried opening the .xls file in Excel 2007. I used the Data Connections button under the Data tab in the ribbon and was successful in editing the connections to point to the new server. However, the graphs used to display the queried data behave weird. The "format axis" settings and chart sizes change. In general, default display settings for charts seems to differ between Excel 2003 and 2007.

I used Excel 2007 to only edit the data connections and saved the workbook in the original .xls format

View 3 Replies View Related

Editing Data And Comparing Lists

Jun 17, 2009

I'm currently working on sorting a column of data from a PDF file into separate columns to later compare to another sheet. I'm having a few problems getting the data into a workable format, and also don't know how to compare to the other file.

Ultimately, I want the data in columns that look like this:
Name, City, State, Zip, $123.00, mm/dd/yy

Currently it looks like this:

A
1 Name
2 City State Zip
3 $123.00 mm/dd/yy

The sheets I'm working with are thousands of rows long, with these three rows of data repeating for every person. I have two problems with them, however:

1. I ultimately need each of those pieces of information into a seperate cell, in separate columns. I've been transposing the data then doing "Text to Columns" to get it from three separate rows in Column A to one row in Columns A, B, C etc.

The problem with this is the names aren't always uniform. Sometimes there's Mr. or Mrs. in front of them, sometimes they have a middle initial, or an "esq." behind them, which completely messes up the "Text to Columns." Is there a better way to break them up into separate cells?

2. Secondly, not all of the names are individuals- some are businesses or charities. I want to remove all of these (and the two lines of data that go with each of them), so I only have individual people. Do you have any idea of how to make excel know the difference between, for example, "Mr. John Smith" and "Smith and Sons Realty"?

3. Lastly Once I have all of this data spread out into the different columns
(Last Name, First Name, City, State, Zip, Date, Amount), I need to compare it to another list. Basically, I've got one list of data configured in a similar way, and I want to identify any repeats between the two lists. I know that excel has a way to delete repeats, but what I need is a way to delete everything BUT repeats.

View 9 Replies View Related

Data Entry And Editing Using A Form

Apr 12, 2006

I am trying to figure out how to enter and edit data using a form for stock traceability.

I have created the form with the headings etc and everything works well at data entry.
However, I am trying to create a search and edit form that searches and edits existing entries.
A third form displays the data in form format when the user types in the appropriate ID.

View 9 Replies View Related

Enable Editing Chart But Not Source Data?

Mar 18, 2014

is it possible to unlock a chart but then disabling to change the source data?

Background: I want the user to be able to add numbers etc. but he shouldn't see the underlying table...

View 2 Replies View Related

Editing Previously Encoded Data In Userform

Apr 10, 2007

i want my userform to operate like this:
>each time the user opens the userform, he has to choose from the 1st combo box which AREA will he worked on (e.g., Math, English, History). upon selecting, the AREA chosen will populate the choices in the 2nd combo box (e.g. if Math, 2nd combo box will show: Algebra, Calculus, Trigonometry).

**thru some posts, this part is already solved. thanks. but this will lead me to my questions.

>1st and 2nd combobox selections (e.g., MATH, CALCULUS) serve as a match. Unique from the other matches.

>upon choosing the match, the user can encode in the succeeding textboxes (he would encode numbers).
**this is in another Userform Which Saves Data To Two Different Worksheets DATA TO TWO DIFFERENT WORKSHEETS

>my userform has an EDIT command button.

***what VBA codes can i use so that when I click EDIT, the userform will display all the matches that I encoded. If I choose the match from such display, all that i encoded which are related to that match will be reverted to the userform so that i can edit it right at the userform?

View 9 Replies View Related

Lock Data Validation And Yet Permit Cell Editing?

Apr 22, 2009

What I'm trying to achieve is to be able to lock the text length of a column so that users can enter text data into that column but not exceed the allowable length for our purposes. I've found a way to use auto loading macros to make a popup if they exceed the set length.

However, that is useless for our purposes because 1) pasting data into the cells as opposed to manually entering data overrides the validation just as it does when you set it with the data validation menus, 2) it requires that macros be activated in the end user's computer which we cannot guarantee will happen. If you lock in the data validation by protecting the worksheet, the end user can't enter data. Do you know of a way to lock in the data validation without using active controls like macros, and yet allow the end user to enter data into the cells. (Perhaps a solution would be to somehow prevent the pasting of data into a cell forcing the data validation to be utilized?)

View 3 Replies View Related

Font Color Of A Cell Will Change Upon Editing Data

Nov 12, 2013

I have a database which I want to send to my peers. I want to set a rule which will enable me to keep track of the data which are changed. For instance, in a cell if someone edit that number, the color will change from black to red.

View 7 Replies View Related

Searching And Editing - Add Information To Specific Rows Of Data In Worksheet

Jun 11, 2014

I am working on a project that I feel should be relatively simple but I seem to be stuck. My Goal: To add information to specific rows of data in the worksheet. I want to use a user form, and eliminate as much typing for the user as possible. I have already designed my user form, and written the code to identify the row in which I want to edit. Nonetheless, I do not know how to code the insertion of the new data. The data I want to add will be in empty cells at the end(right) of the data table.

I have attached a portion of my data set.InsertQuote.jpg

Here is where I am. The words in red are just colloquial words that I cannot seem to put into code.

Private Sub CmdInsert_Click()
Dim Company As String
Dim PartNumber As Variant
Dim Condition As String

[Code] .....

View 1 Replies View Related

Error Message When Editing XY Chart Dynamic Source Data?

Feb 9, 2012

I am trying to create a simple xy graph in Excel 2010 using dynamic source data.

I have data in three columns.

There are headings on line 2 and the data starts on line 3.

A B C
1.
2. dp ss ff
3 .1 .2 .3
4 .3 .4 .4
5 .4 .8 .7
6 .1 .6 .8
7 .3 .5 .1
8 .5 .4 .4

I want to create an XY chart with C3 to C8 as the X axis (or dynamic to what ever the last data point is) with A3 to A8 as the Y axis (or dynamic to what ever the last data point is).

I have Defined names for C3 to C8 (myXvalues) and A3 to A8 (myYvalues).

I have created a simple XY graph and selected the ranges as normal.

This is =DATA(,Data!$C$3:$C$9,Data!$A$3:$A$9,1)

The page is named DATA

What I am trying to do now is to edit this range to make the range dynamic.Unfortunately I get error messages which ever way I try to edit the range.

I have tried:-

=SERIES('Data'!$c$3,'Data'!myXvalues,'Data'!$A$3,'Data'!myYvalues,1)
=SERIES('Data','Data'!myXvalues, 'Data'!myYvalues,1)
=SERIES(,Data!myXvalues,Data!$myYvalues,1)
=SERIES(Data!,Data!myXvalues,Data!myYvalues,1)

The data range can go from 8 to 30000 hence the need for a dynamic range!

PS: Also, is there any way to create this graph and dynamic source data in VBA. I have tried this with no success.

View 2 Replies View Related

Edited Cell Always On Top?

Feb 9, 2013

In long worksheets where I have to edit each cell, I would like it if the cell that is being edited is always on top of the screen. That way I wouldn't have to scroll as much.

View 1 Replies View Related

Worksheet Protection From Editing And At The Same Time Allow All Data Source Links Within The Sheet To Be Refreshed

Mar 16, 2007

how to protect a worksheet from editing and at the same time allow all data source links within the sheet to be refreshed? I need my users to be able to refresh all data links as required but not be able to change the worksheet in any other way.

View 2 Replies View Related

Finding Last Edited Cell

Oct 25, 2013

Is it possible to find the unsaved data in a spreadhseet/workbook? Or the last cell was edited?

After working on multiple workbooks when I try closing them excel confirms if the changes should be saved or not. I was wondering if there was a way to check what those changes were. If there was a way to find address of the cell that was edited last.

View 3 Replies View Related







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