with code that will Cut and Paste a Range (Row) based on choosing "Done" from a Validation list. So, as a task is completed it is deleted from the "Summary" worksheet and then pasted to the "Done" worksheet. I am new to writing Code and have been piecing together bits and pieces. Here is what I have so far:
View 14 RepliesI have a frame (Frame1) on a userform added using Microsoft Forms 2.0 Frame. I have added option buttons to the frame named OptionButton1 thru OptionButton4. I am trying to add code where certain cells are copied and pasted depending on which optbutton is selected. I tried the following code but because the option button is a frame object it doesn't seem to trigger the event.
Private Sub OptionButton1_Click()
'copy level 1
If Me.OptionButton1 = True Then
Worksheets("Sheet1").Range("G10:G32").Copy
Worksheets("Sheet1").Select
Worksheets("Sheet1").Range("C10:C32").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End If
End Sub
For some reason I only have the option of "keep text only (T)" in the paste options and cannot copy and paste formulas. Can you tell me how to change this and why this happened?
View 5 Replies View RelatedI have workbook having 3 sheets out of them 1 sheet name "report". I want vba to disable copy /past option to sheet Report only with msg " copy not allowed" if key clt+c or copy option selected
View 1 Replies View RelatedHere i am attaching the excel sheet where macro is enabled. I have added macros in last spread sheet (Consolidated) everything is working fine. Whats messing is i have copied a macro for the entire workbook, which will disable Copy/Pase/Cut option to all engineers. But problem is its disabled for me as well, every time i have to delete the code for copy/cut options. I just want cut/copy option in the last worksheet (Consolidated) where i can get all the result with out touching the rest of the sheets.
View 3 Replies View RelatedBelow is the macro code in which the code is segregating the data page wise i want the below changes:
> macro should copy and paste only values with the option skip blanks.
Private Sub CommandButton1_Click()
Dim j As Long
'Setup the loop to loop through the Areas
For j = 1 To Columns(1).SpecialCells(2).Areas.Count
'Add a new WorkSheet
[Code] .....
I want to restrict users to just read or print a word document. Document is very confidential so we dont want them to copy or manipulate the document.
I thought of giving password to restrict to read only option but that still lets users to copy and paste on to a new document.
I'm trying to use option buttons to create a text entry in an adjacent cell.
Selecting Option Button 1 puts "GPM" in cell F23. Selecting Option Button 1 puts "lbm/hr" in cell F23 (The option buttons are from the control toolbox)
I receive ""Run-time error '424': Object Required"" and first line is highlighted- here is copy of
Sub FlowUnits()
If OptionButton1.Value = True Then
Sheets("Main Screen").Range("F23") = "GPM"
End If
If OptionButton2.Value = True Then
Sheets("Main Screen").Range("F23") = "lbm/hr"
End If
End Sub
I have several option groups (Y & N in each) linked to cells to display TRUE / FALSE depending on which option is selected in each group. I have another cell which I want to apply conditional formatting to if EITHER Y or N is selected in all groups. At present I use COUNTIF to check for FALSE=0 in the linked cells which works if all the answers are Y. How do I apply CF if there is a mixture of Y & N (TRUE / FALSE) in all groups (I'm not sure if I've explained that well or not).
Excel 2013
IF I enter 01-09 in B10 or B11 or B12 want autofill FIRST in C10, C11, C12
11-19 in B10 or B11 or B12 want autofill SECOND in C10, C11, C12
20-29 in B10 or B11 or B12 want autofill THIRD in C10, C11, C12
HOW TO DO THIS ?
i have a user form in my spreadsheet that uses option buttons and text boxes for user entry. i need to take the values and true false entries from the option buttons and place them in cells. i am alittle lost with this.
View 6 Replies View RelatedI attached a sample spreadsheet but I was wondering if there was a code that could display a range based on an option selected in a dropdown box.
excel help.xlsm
see the attached below.
A few things to sort if I may
How do I get the listboxes to pre-populate based on the Userid and Option Button selection? Furthermore, write back to the correct cell once the selection has been made?
How can I get the combobox to remove blanks in the Userid? (if each cell in row2 has to be populated then so be it)
ToolMatrix3.xlsm
I need an action to allow for the random selection of a predetermined series of number codes which represent a given letter.
It is probably easier to look at the attached sheet and the previous discussion to see what I mean.
Previous discussion:
http://www.excelforum.com/excel-work...-of-cells.html
I would like to set up some option buttons so that the will be become visible and enabled when a check box is checked, and the opposite when the same checkbox is not check. This is my problem
Private Sub cbpDiscAlum_Click()
Dim myOption As Control
Dim myValue As Boolean
myValue = cbpDiscAlum.Value = True
If myValue = True Then
For Each myOption In pDiscounts.Controls
myOption.Visble = True
myOption.Enabled = True
Next myOption
Else
For Each myOption In pDiscounts.Controls
myOption.Visible = False
myOption.Enabled = False
Next myOption
End If
End Sub
It is the 5th command where it gets hung up: For Each myOption In pDiscounts.Controls. I am sure I am spelling both of the names correctly: the checkbox, and the group name.
I have set up a combolist box, and wish to run different VBA subroutines depending on what the user has selected from the combolist. How do I do this? Apologies in advance if this sounds like a silly question.
View 2 Replies View RelatedIs there a way to set up a "watch" on a cell so that if you type in a different number on a cell, OptionButton1_Click() gets activated? Example:
A9 = 12.0104
OptionButton2 is active.
In Cell A9 you type "25.0508". OPtionButton2 becomes inactive and OptionButton1 becomes active. I already have the buttons linked, i just do not know how to make the button get triggered if A9 changes.
I have a survey template with several options buttons (made from Form toolbar and grouped by Group Box).I would like to have a check box that would activate these option buttons for specific question if unchecked and vice versa.
I have copy & paste below formula in VB, but is shows 'Run time error 424' & when I Debug it shows 2nd line highlighted by yellow colour.
VB:
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then [code]....
I'm creating a form with drop downs, and I'd like the answer choice someone makes for one question (ie- what county they're in) to affect the answer choices for a secondary question (ie- what city they're in).
I'd like to avoid using names, at least for the second dropdown (since there would be too many names, and in some of the questions in the data set things change too much for names to be a good option). I would also like to avoid using VBA to keep it simple and maintainable. Here is a simplified version of a small subset of the data.
Drop Down 1:
County (options: Santa Clara County, Napa County)
Drop Down 2:
Cities/Towns (options: the cities/towns that relate to the above county selection, without using names)
County
Cities/Towns
Santa Clara County
San Jose
[Code] ........
I have some data in sheet1 with 10 columns and 5000 rows.
I want to filter the data with 2 criterios.
When I go to 4th column and Click custom filter, I will give one criteria and select "or" and give another criteria. SO I will get the result in sheet1, I need to copy the data and paste the same in sheet 2 with the header.
The problem is, I need to filter more than 20 times giving the criteria and copy the result and paste in sheet 2 one after the other.
So i need a macro to solve this time consuming work.
I just paste the two criteria either in a text box or some cells and run the macro. the macro has to filter the data in sheet1 based on my input.( that is criteria1 or criteria 2) and the result should be pasted in sheet2 with the headers.
Again I delete the values in my input cell, and paste the new values, and run the macro, that result should be pasted after the first result, with the header. (would be great if that is pasted leaving one row above, that is if the first result is pasted in sheet 2 till 10th Row, then the send result should be pasted in 12th row and so on..
the similar kind of question with some changes, I posted in the below link with
http://www.excelforum.com/excel-prog...in-sheet2.html
Is there an option to have row heights set automatically based on the content of the text in the row, and given a specific column width?
I can right click, and set each row height individually.
I can select serveral rows stacked one on top of the other, each with limited text, and change all of those rows at the same time.
But when I select all rows, and try to change row height, the row height option is not there.
My very large document uses the CHOOSE function in many places to paste content based on the value of a COMBOBOX at the beginning of the document.
My problem is that I now need to paste an entire table for a certain CHOOSE function value. Documentation for the CHOOSE function allows reference to a range of cells such as A1:B12, however, I cannot get it to paste the table in the document.
I have a spreadsheet with two tabs Line Crew and Master Log. I have a macro that searches the Master Log Column H for a value "Line Crew" and if it finds it, it will copy that row (Specified range) to the Line Crew tab. My problem with the macro is that it keeps copying the same row. I would like it to move down to the next row search for "Line Crew" , copy and paste until it gets to the end of Master Log Sheet. I have attached a sample of the spreadsheet. Here is my code:
[Code] ..........
Attached File : Book1.xlsm
I have a spreadsheet that I need to cut and paste data from one tab to another but only from columns B:K (as the spreadsheet has formulas that can not be alterred after column K. It must also paste that data for the hidden columns.
The condition on the data to be pasted in based on the tabs along the bottom.
So for example, anything that says Corn Products needs to be cut from the "standard customers" tab and moved to the Corn Products tab, and so on for the additional tabs.
I then need to un-check (hide) Blanks from the filter on the Standard Customers tab.
If possible, I would like run the Subtotals function in this same macro; the conditions for that are as follows
For each change in Shipper, Subtotal Billing for <<month>> (Column S)
Page break inbetween each Change in Shipper, then I would also like each subtotal figure bolded.
Also, this is something I must do every month, and each customer may have more or less lines or no lines at all in any particular month.
[URL]
I have run into a problem which is quite unique. I have data for 40000 football matches. The Sheet "Raw data" has the raw format of the data.
Sheet "Goal Difference (Home - Away)" is pretty important. This sheet is the goal difference between the home team and the away team. "A5:A95" has the number of minutes in a football match and we are trying to track the way a team progresses throughout the match. Lets assume the score is 0-2 for the 1st match and the goals were scored in "39, 76," minute by the away team. So the data will read 0 from 0-38, -1 from 39-75 and -2 from 76-90.
Sheet "Red Cards conceeded_Home" tracks the number of red cards as the match progresses through 0-90 minutes for the home team. The catch here is if the score reads Red Cards : "1 - 2" and the Red Cards Time reads "26, 15, 18". The red card was issued to the home team at 26th minute, The away team received it at the 15th and 18th minute. So the data will read 0 from 0-25, 1 from 26-90.
The same applies to the other tabs.
I have a problem and I hope that it can be solved using a macro. Basically, I have a set of data in column A and B in sheet(1):
A
B
1NameDate
2JOY12/09/11
3MAR12/12/11
4DAVID12/12/11
5
I have another set of data in Sheet(2):
A
B
C
D
E
1NameDatesalary
CHARACTERRATINGS
[code].....
basically, I would take into consideration the names and dates in sheet(1) and if it matches sheet(2) then it would then paste their salaries, characters and ratings into sheet(1).
I have an excel sheet with over 10,000 rows. Some of the rows are colored. (Light Green). I want a macro which starts from 1st colored row, cut or copy all the rows (including the colored row) before next colored row comes and paste it in the same workbook but different tab. It would also be good if macro creates the tab itself.
View 9 Replies View RelatedI have tried to write some VBA to copy and paste rows based on the condition in cells A:A in sheet one. So far I have managed to put something together which will paste the first row and insert a new row below but keeps on pasting the same row. But not much else! Not sure I have tried to make it more difficult than what is it.
I would like it to copy a row based on a certain condition ("WRW") in A:A sheet one and paste it to sheet2.
VB:
Function DoOne(RowIndex As Integer) As Boolean
Dim Key
Dim Target
[Code].....
I have an Excel Spread Sheet that lists all of the people who have been issued Keys in your workplace, so the row has multiple information columns (Name, Department, Key Code, etc). One row is titled "Left Workplace" and you can select either a Yes or a No. Based on that selction I want it to copy and paste into a different spreadsheet (Either Inactive - if "No" is selected or Active - if "Yes" is selected) What is the best way to go about this?
View 2 Replies View RelatedThis code basically copies data from one worksheet to another worksheet based on the date and works great.
However, I have been asked to changed the format of the spreadsheet and the code needs to be changed. The code is in "This workbook".
The code takes the data from the summary tab and copies it to the archive tab. I now need it to take it from the summary tab and copy it to the archive 2 tab.
I have attached a copy of the spreadsheet. Data and Archive2.xlsm