Task To Automatically Move To Another Worksheet For The Relevant Month
Nov 19, 2008
I have created a spreadsheet for internal use in my workplace that logs task by members of staff, What I am trying to achieve is when someone selects from a drop down box that a task has been complete I want the task to automatically move to another worksheet for the relevant month, as I will have worksheets for every month logging all the past tasks that have been assigned. I believe an IF statement should do the trick, but I am having no luck so far.
Is there a way to make the attached worksheet automatically shade out all the Saturdays & Sundays in any given month everytime you change the Month/Year cell at the top of the worksheet, as example? I've tried using the weekday/Weekend formula, but can't quite get it right.
I'm looking to automatically move data from my working worksheet, when a particular column states "Won" or "Lost". I'm hoping the entire row of data can be cut, and added to the appropriate sheet, determined by "Won" or "Lost".
I have been trying for the past four months now to get my workbook to automatically open a new worksheet every 1st of the month.
but I have failed each and every month. I have asked others to assist but to no avail.
this is the code in my workbook as it looks now.
Dim strValue As String Dim Sht As Worksheets, foundSheet As Boolean, TEMPLATE As String Dim rng As Range Dim irow As Long Dim myDate As Date, newDate As Date, oldSheet As String, newSheet As String Dim ws As Worksheet Dim strName As String Dim wsh As Worksheet
i keep getting an error on the activesheet=newsheet.
I have to complete information providing dates and names for a long number of individuals. Is it possible to set up the spreadsheet so that if you enter a date next a persons details in on worksheet their information is automatically updated in the relevant ones?
What I do know is how to set up a task in Task Scheduler and I have it set to open my Excel file: Workbook1.xlsm. This task is set to run at 7am each morning. Workbook1.xlsm has a bunch of different macros in it.
What I'd like to do is to have each of those macros to run automatically when the file is automatically opened by Task Scheduler.
I have two worksheets and need to consolidate the relevant data into one worksheet.
On both worksheets there is one column that I can relate to the other worksheet, called "TKR", which contains a code in each field, such as "000210 K", or "004170KS". Both worksheets have this column. In the first worksheet, called POS, each "TKR" code tells me that this is a relevant "TKR" code in the DB worksheet. I am not interested in the data in POS, just the code to tell me which records are relevant in DB.
In DB is the information I need to extract. But in this worksheet, there are many irrelevant records, which I need to ignore. I need to reference the data in the TKR column in the POS worksheet with the data in the TKR column of the DB worksheet, then extract the record from the DB worksheet and place it in a new worksheet, along with each other extracted record, compiling a consolodated list. I could do this by cut and paste, but I have 30 different databases, both POS and DB, each containing up to 6000 records.
In the POS worksheet there is more than one record for each "TKR" code. I can run an Advanced Filter to extract a consolidated list of "TKR" codes. I am stumped however on how to then use that list to reference the same codes in the DB worksheet and extract the records to a new sheet.
I have a multi worskheet document and i want to be able to create a macro that will search individual cells in a range on each sheet and if it locates a 3 letter mneumonic (STK in this case), it will then copy that data for the whole row and paste on an additional worksheet. I also need the data pasted on the new worksheet to be protected ie not overwritten when the macro runs again. So this mneumonic could exist anywhere in column A (A1,A500).
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.
... in A1 a year (say 2012) ... in A2 a month, formatting as "MMM" (JAN, FEB, MAR etc.)
How to automatically get in column A (say from A3) all the dates of the month entered, formatting as "D/M/YYYY" (e.g. 1/1/2012, 2/1/2012/ 3/1/2012, etc.)?
I have a spreadsheet for monthly supplies. In row 1 is Jan – Dec and in the row 2 below are empty cells where there will be a total for that month’s purchases. I want a conditional format formula to automatically bold and highlight the current month’s total and month name.
Also, when I enter February totals next month and that number is input into February’s total, I want that month and total to bold and highlight BUT I also want the previous month’s bold and highlight to vanish at the same time. Is this possible?
I am working on automating a report via vba code where the range of the chart needs to be changed every time the macro is run. Basically the chart is a snapshot of performance of 6 months .
For example : if the chart is already displaying Jan - Jun data , when the information for July is added and report updated the chart should be updated to reflect Feb - Jul data .
There are many graphs but have added 2 sample here for ref .
Is there a way to automatically move cells down after I entered data in it? This way I do not have to scroll all the way to the bottom of the list to add new data.
Is it possible to create a cell in one sheet, where after data is entered, will move it to another sheet. Additionally, the data in the cell, after the transfer to another sheet is made would delete itself. Once the data is entered, sent to another sheet and deleted, next time data is entered into the same cell, it would be sent into a row below the cell that the first piece of data would be in. Therefore, after I enter data, [for example] press enter, then go back to input some more data, after a while there would be a long list in another sheet. The last feature of the problem (it would be something extra really) is that the function/macro is to be time dependent - during one month the data would stack up in one column, after the next one begins, the next column will automatically start all over.
The idea is to create a budget book - where on the main page I would only have to enter the value in a specific box, the value then would be automatically sorted into the right row and column in another sheet, after the month/week ends, data would start to stack up in a column devoted to a new month/week.
Of course the data could be entered manually in different sheets, but it proved to be too complex to be useful.
I have Excel 2003. I need a formula that will automatically move data in a row to another sheet, in the same workbook, based on either a two digit department code or possibly a date. I enter information on a master sheet, (8 columns of data: Text/$/digits) and I need that information to separate out to the other sheets when that department's two digit number is entered on this sheet. There are a total of 6 sheets in this workbook, counting the master. The data I am entering will be about 40-50 rows down of information, 8 columns across. Will this take a macro? Loop?
Every day we receive a text report via email (only way it can be received), so we take this text report print it out and manually type it into an excell sheet.
I believe this is a waste of time. Is there any way I could take this info and automatically place in the the excell?? Until know I found a text to excell converter and was gonna create a macro to automatically convert this info into the excell report.
i've got a worksheet with a column of unique numbers that i sort from smallest to largest; colA. these numbers are asset #'s of all items that i should have in inventory and all are barcoded.
using a scanner i scan the barcode # into colB however these items are on the shelf in random order.
as it stands i place my cursor in the first empty cell of colB (B2) the scanned # is entered into B2 and the cursor moves down to B3.
What i'd like is to have the randomly scanned number automatically move to the cell in colB that is beside the corresponding # in colA regardless of where the cursor is prior to the scan.
e.g.: 16 is in A16, cursor is in B2 waiting for first scan, first randomly scanned # is 16; so 16 is automatically entered into B16 instead of B2.
I have a spreadsheet that contains large amounts of data. I've looked through the forums and tried to adapt other VB code to work for me all to no avail.
I would like a macro to automatically cut a row from sheet1 and paste it on to a new line in sheet2 when data is input into column 'X'. (The data input in to column X is a date the specific case is resolved)
I have a excel file Sheet 1 is active data Sheet 2 is complete data, How can I make the column move automatic from one sheet to another with out cut/pasting?
I have a simple projectlist on sheet1 formatted like this: Column A=Projectname, B=Description, C=Owner, D=Deadline and E=Status. On sheet2 I have the same columnheaders.
What I would like to do, is that if Status changes to "Done", * the entire row should be copied to a free row on sheet2, or just inserted on sheet2.row2 without overwriting anything * the now empty row on sheet1 should be deleted (so there're no empty rows) * the data on sheet2, should be sorted with D as first key and C as second.
Then, if Status on sheet2 changes to "Reopened", the same procedure should happen but from sheet2 to sheet1.
My first choice was to create a checkbox on each row in the Status column,but I noticed it didn't seem to follow with cut/paste even though I changed the property Locked to false. Anyone knows if it's possible to change this behaviour?
I only know small bits of VBA but my idea is this: ...
We have a worksheet that contains twelve different charts. Once a month, we load data into anotheer worksheet and run a macro and it produces the twelve charts. The problem is that we have to manually update/change the month name in each chart title every time we run the macro to produce the charts. Is there a way to automatically update the month name so that we do not have to manually do it? For example, the current chart title is "xxxxxx - March 2014"....when we run the charts for April, we have to manually change March to April in each of the charts. Can this be done automatically?
In cell A1, I have the month number (eg, 1, 2, 3,). The month number reflects current month and will automatically change with every month. For example, right now it’s 6, next month it will automatically change to 7. Each two columns in Range A10:X20 represents the data from January to December. I want to use a worksheet event to change the background of the current month two columns in the range to yellow color and the two columns in the range will be visible when I activate this sheet.
I have a Excel workbook with two sheets - 'MainDataSheet' and 'ArchiveSheet' .
The 'MainDataSheet' has 5 columns and one of the column is 'status'.
The 'MainDataSheet' will have a command button 'MoveData' which will trigger the VBA macro to move data rows from 'MainDataSheet' to 'ArchiveSheet' . Only the rows having value set to "MOVE" in the 'status' column have to be moved.
I want to make a spreadsheet that has codes that make items show up on another sheet but how to do this.
For example I would start on sheet 1 and on cell A2 I would type the amount $100. Then in cell B2 I would type in F (I will call this a code).
Now on sheet two I want the amount on cell A2 to show up in a column of items designated for F items. If I had typed in G instead I would have wanted it to go to a column for G items. All the values under the given code will show up in the column that is represented by them.
I need to transfer data from a table dynamically updated every 10 minutes to a table that never changes and maintains data, how can this be done using a macro?
I am trying to use visual basic editor in excel. I have all ready set up my user form where information can be entered, but I ave having trouble getting the information that is entered in the user form into the correct cells in excel.
I am wanting my information to enter the tables and then automatically move into the next available cells below.
Private Sub cmdadd_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("details of cars in stock") iRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).Row If Trim(Me.txtreg.Value) = "" Then Me.txtreg.SetFocus MsgBox "please enter a registraion number" Exit Sub End If ws.Cells(iRow, 1).Value = Me.txtreg.Value Me.txtreg.Value = ""