Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Checkbox To Copy Row To New Sheet


I have 4 sheets
Sheet 1
Sheet 2
Sheet 3
"Checkout"

What i would like:
Rows of data on Sheets 1/2/3 with a checkbox in column A of each row
I check a couple of checkboxes on sheet 1 some on sheet 2 and some on sheet 3
where i put a tick in checkbox they have copied across to next available row in sheet "checkout"

If i tick a checkbox then untick it (maybe changed mind) copied row is removed from checkout sheet.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Add New Sheet & Copy Checked CheckBox Rows
I need to copy all the cells to a "new worksheet" if the checkboxes are checked.
I have thousand of cell in here but i just narrow it down in this example.

example:
A B C D E F G
21 22 23 24 25 26 checked
31 32 33 34 35 36 unchecked
41 42 43 44 45 46 checked
51 52 53 54 55 56 unchecked

there is a command button in here that when it was click it will open a "new worksheet",
what I need to see in the new worksheet is this:

A B C D E F
21 22 23 24 25 26
41 42 43 44 45 46

View Replies!   View Related
Macro For Copy/paste Selection Of A Row To A New Row On New Sheet
I'm new to excel and VBA and I'm having problems with a copy paste macro that I’m using to transfer information from Sheet1 to sheet 3. The macro must:

On the click of a command button copy information from A5 to M5 and A6 to M6 and paste it to the next 2 free rows on sheet3 between columns A and M.

After the copy/paste the macro must clear the information from the input sheet - A5:M5 and A6:M6 - but retain the formatting.Thank You.

View Replies!   View Related
Copy Specific Range From One Sheet And Paste To Next Available Row Of Different Sheet
I would appreciate if someone can help me figure out a macro that will copy range (A3:T112) from "Step 1" sheet to next available row in "Step 2" sheet.

View Replies!   View Related
Copy A Row From One Sheet And Paste It In Another Sheet Based On A Condition
i want to copy a row from one sheet and paste it in another sheet based on a condition.

View Replies!   View Related
Copy Row From Sheet 1 To Sheet 2 When Data Entered In Cell F
I have Worksheet 1, with columns A to E. I would like a row to be copied to Worksheet 2, as soon as cell F in Worksheet 1 is populated. Also the row to be deleted from Worksheet 1.

So, as soon as F1 in worksheet 1 is populated and enter button pressed, row A1:F1 will be copied to the next empty row in worksheet 2, while being deleted from worksheet 1. So eventually all rows in worksheet 1 will be deleted and rows in worksheet 2 will be populated.

View Replies!   View Related
Copy A Row And Then Paste It On First Empty Row In Another Sheet
Have a small VBA code that simply copy a row and then paste it on first empty row in another sheet. Its working if i use a regular macro, but i have some problems to get it to work with some code. I want it as VBA since the copying is alot smoother. The problem i have in the code is the PasteSpecial.value, Since i dont want the formula to get pasted. Attachiing the worksheet. Its the macro PasteSpecial that i need alittle guiding on if possible.

View Replies!   View Related
Copy Row To Sheet With Same Name As Value Of Cell In Row
I have a workbook that has about 300 different sheets- each the name of a different chapter of a fraternity. I get new lists of members daily and have to manually sort them into the 300 different sheets.

Is there any way I can automate this? For example, if column "E" contained the chapter name- in this case cell E38 contained "Oklahoma Kappa" , the macro would automatically copy row 38 to the first empty row in sheet "Oklahoma Kappa".

View Replies!   View Related
Copy From One Sheet And Paste In Another Sheet As A New Row
I need to write a simple macro to copy the last row in a spreadsheet and paste it as a new row in the other sheet.

View Replies!   View Related
Copy Last Row To Next Available Row On Other Sheet
i am trying to make a spreedsheet to help me organize some stuff here at work. we have a bunch of overlays stored in several different locations. on top of that, they are all customer specific. there is also 8-10 cells worth of info describing each one.

in my book, i have several sheets, one for each customer along with one contaning everything.

i wrote a macro trying to copy a line from one sheet and pasting it into the all sheet. the problem is, its copying from the same line every time and pasting into the same line every time.

i want it to take the last line added into a customer specific sheet, and then add it on to a new line in the ALL sheet.

then at the end, i want it to re-sort all rows in order.

View Replies!   View Related
Copy Row To Next Available Row On Another Sheet
I have the following code. I select a row in sheet one, run the code (which will eventually be attached to a button, but right now, is not], and it moves that row to another sheet. The problem is, it overwrites the code on the other sheet. I want it to either be added to the second sheet on the first available row.

View Replies!   View Related
Copy Row From Sheet If Value = Something
I have two sheets in a workbook. One has data, let's call it "data", one is blank, let's call it "apples".

"Data" sheet has column headers on A1 to H1 and then data running on each row A to H (i.e. the 1st row of data is A2 to H2) There are 200 rows of data.

In "Data" column D contains types of fruit. What I would like to achieve: if a cell in column D contains "apple" then that row's entire data A to H is copied to the "apples" sheet in the first availble row. If a cell doesn't contain "apple" then it ignores it and checks the next row.

View Replies!   View Related
Copy Row To A New Sheet
I have data in Sheet1 and I want to copy all rows where in field 15 and 23 are numbers bigger then 0 in Sheet2 in first row with no data.

View Replies!   View Related
Copy Row With Data To Second Sheet
i need to have a macro that searches columns C and E (on sheet1) for any cell with data.
if finds data in either C or E, it copies that entire row to sheet2 in the next avilable row, and adds a date stamp to column F ...

View Replies!   View Related
Copy Range To Last Row On Another Sheet
Sheet 1 has a Invoice template in which i need few cells like Invoice no, Date, Client name and amount to be copied into sheet 2 in a single row on click of a button. Again when i change the data and click the same button the data should go to sheet 2 and next available empty row.

I will print the invoices once its done i keep changing the same again. Basically, I want to make a log of invoices in the sheet 2.


View Replies!   View Related
Copy Entire Row To Next Sheet
with VBA on below mentioned data names in column A on that some names are repeated . That repeated names with amount & doc number should be cuted & and paste in the next sheet ie sheet2 help with VBA ....

View Replies!   View Related
Copy Row From One Sheet To Another If Cell Value
What i want to do with attached example is add a macro to the button which copies each of the rows where there is a value in column C and then paste these rows into the next available row in the 'settled' worksheet.

Once pasted into 'settled' then each o the rows with values in column C of 'unsettled' want deleting.

View Replies!   View Related
Copy Row And Paste To New Sheet
In case column C starting from row 3 to end, if any cell contain number ie numeric value then copy the entire row to a new sheet named "stmt" starting from row 2 ie start pasting from row 2 of "stmt" sheet.

View Replies!   View Related
Copy Down Last Row On Protected Sheet
I am looking for VBA code that will unprotect the Workbook, prompt the user for the number of rows to be added, find the last row in the Worksheet, insert the requested number and reprotect the Worksheet. I would like the location where the rows are inserted to NOT be dependent on the "active" cell.

View Replies!   View Related
Copy Sequentially Down List To Every Other Row In Another Sheet
I'd like to do is to use loops to copy each value in "Sheet1" into every other row in column B of "Sheet2" starting on row 16. I realize that this is a simple task, but I'd like to know how to do this for the purposes of learning the correct VBA coding.

View Replies!   View Related
Rows Copy Over To A Different Sheet And Place The Next Available Row
I have is 3 seperate jobs listed, what i want to do is have each one of these rows copy over to a different sheet, and place the next available row. What I would like to drive this is the number in column "n", for example, "n3" is 1, so I would like that row to copy to the sheet named "1", and entered in the next available row under any previous lines that have been copied over.

******** ******************** ************************************************************************>Microsoft Excel - BETA SCHEDULE.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCDEFGHIJKLMNOP1Date EnteredTime Ent'dCUSTOMERJOB #LINE #MATERIALMATERIALMAT'L   QTYPAPERPAPER QTYFinish QNTYSIZEMach.RUN DATEDue Date233/318:58 AMCUST. A2585271HSS5260 15 SH  15 / 1530X65 .02013/313/3143/318:58 AMCUST. B2585241PC 8256 7 FT   3 / 624X26 .01023/313/3153/318:58 AMCUST. C2585161TFS1010 3178 FT  615 / 61532X61.5 .00833/314/1MASTER [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View Replies!   View Related
Copy Cells In Selected Row To New Sheet
I would like some code to allow the user to select any row in Sheet1
and then the populated cells (10 in every case) in that row will copy across to various locations in Sheet2.

eg,
The user selects Row header for Row 12 which has 10 cells ( A12 to J12) populated.
A12 will go to C3 on Sheet 2, B12 to D5, C12 to D9, etc, etc.


View Replies!   View Related
Copy Rows From One Sheet To Another Is Skipping Every Other Row
On the attached example there is a button called 'unsettled hedges', click this and it loads a userform. In this example, there are 10 rows of data that want a value entering into the 'returns' textboxes.

If you try to enter a value into all of the 'returns' textboxes and click the 'settle hedges' button then all the values from the textboxes should against the relevant row in column L of the 'unsettled hedges' worksheet and then each of these rows should be copied to the next available row in the 'settled hedges' worksheet.

This isn't happening though, instead, it is copying across every other row from the 'unsettled hedges' worksheet, leaving half of the rows still on the unsettled hedges worksheet.

View Replies!   View Related
Copy Cells To The Next Blank Row In A New Sheet
I have a commandbutton and I am trying to workout the code to go into its onclick event.

I have an input worksheet (inputsheet) where i enter information into cells A1:A5
I would like to click the button and have this info then transferred into the record sheet (called: recordsheet) in columns A to E.

Each time I press the button I would like the info in inputsheet A1:A5 to be transferred to a new row in recordsheet.

View Replies!   View Related
If Cell = X, Then Copy Entire Row Into A New Sheet
I have a report that I use everyweek and split up into various sheets according to the criteria.

So if any cell in column C contains "Apple", then I want it copied into a new s/s (with the headers). I basically have to do a number of iterations on this, can someone assist please? The main problem I invisage is asking Excel to copy the row into the new sheet underneath the last one.

View Replies!   View Related
If Column Contains XXX Then Copy Row To Different Sheet
I am trying to work out a formula that states if column F contains SQ050SM or SQ075CC or SQ050CC then copy that row and paste in a second sheet.

I have attached a spreadsheet to provide a visual.

View Replies!   View Related
Copy Row To Another Sheet If Cell Not Empty
I have programmed in many languages but a noob when it comes to VBA. I can guess at the syntax but I don't really understand what I am doing. So I was wondering if the following is possible. I want to write a script that checks for a value on a different sheet (SheetA) and based on it being defined (ie not empty) copies the entire row to a different sheet (SheetB). I probably have around 120 rows in SheetA and will only expect to see 10-20 rows on SheetB based on the criteria for copying. I am also unsure if the VBA code should be for SheetA or SheetB. At first I thought I could just hide rows based on a value but I also need to export the sheet to a csv file and looks like excel exports all the rows, even the hidden ones and I don't want that.

View Replies!   View Related
Copy 2 Fixed Ranges To Another Sheet After The Last Row
I want the range B111:B167 from the hidden sheet copied to Column A of the questionnaire sheet 5 rows after the last used row on the sheet. There is text in cells C261 & S261 at the bottom of the sheet, so currently row 261 is the last row, but users could/might insert or delete rows, when answering questions. I then also want to copy the error check responses from C111:C167 to column N of the questionnaire sheet 5 rows after the last used row on the sheet, so the question # and response matchup. I then planed to delete any rows that have “Answered” in column N on the questionnaire Sheet. The Idea being the user can run the macro over and over until no questions remain.

View Replies!   View Related
VBA Macro To Copy Entire Row To Another Sheet
I have written Macro to copy every row in "sheet1" 24 times into new sheet called "NewSheet". but it keep giving me error message. Actually, I don't know why. Can any one please help.

here is my macro

Sub CopyRowsBook2()

Worksheets.Add().Name = "NewSheet"
Sheets("Sheet1").Select
' Find the last row of data
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row

' Loop through each row
For x = 2 To FinalRow
Worksheets("sheet1").Cells(x, 1).Select
ActiveCell.EntireRow.Select
Selection.Copy
' Loop to copy every row 24 times
For i = 1 To 24

Sheets("NewSheet").Select
NextRow = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(NextRow, 1).Select
ActiveSheet.Paste

Next i

Sheets("Sheet1").Select


Next x
End Sub

View Replies!   View Related
Copy And Paste And Entire Row From And To Another Excel Sheet
How do you copy and paste an entire row from and to another excel sheet, with control of where to copy and where to paste.

I have this paste sh_CIF.Cells(sh_CIF_X, "a").EntireRow.Paste

but it is wrong.

View Replies!   View Related
Copy Data To Master Sheet Next Avail Row
I am trying to write a macro that will go to one workbook after another, select a large range and paste it to a master sheet, then repeat for the second workbook but this time paste in the next available row.

View Replies!   View Related
Copy Data From Userform To Sheet, On A New Row Each Time
I have designed a userform that allows teachers to input assessment grades and calculate overall module grades based on these...

I'd like to develop a macro that would then allow the teacher to click a "save" button on the userform, triggering the transfer of the information on the userform into the next sheet and then clear the contents of the userform ready for the next calculation.

I have made an attempt; unfortunately I have very limited experience of Excel and am therefore running into difficulties; the macro is as follows: .....

View Replies!   View Related
Validation List Choice To Copy Row From Another Sheet
I need to get data copied from sheet1 to sheet2
depending on selection in a validation list.

The data is on the same row and all the same range.
So it would look something like this.
A B C
Fruit Orange Apple Pear
Veg Potato Carrot Onion
Animal Bear Cow Dog

I have the data in A in a dynamic range and validation list.
I need all the data copied from the specific rows ie
choose Animal from the validation list in Sheet2!A1 and
the entire row Bear Cow Dog get copied to Sheet2!B1, Sheet2!C1, Sheet2!D1.

The second problem I think is a lot more complex.
So the same scenario above but this time its a multi select on Sheet3.
I need to be able to select two (or more depending on Fruit and Animals to display in A1, A2 and then their valid options to appear in B, C and D

View Replies!   View Related
Copy Shells To Another Sheet, Depending On Predefined Row
My problem is that I need to get button to move information from sheet1 A5:E5 & A8:E8 & A11:E11 to sheet2 B1:P1 if Sheet1 A1=1 to B2:P2 if A1=2 etc

I can only make it by if or case macros, but it becomes so long code


View Replies!   View Related
Copy/paste Row To Another Sheet Based On Value In Column
I've two sheets: "present" and "removed". I would like to have a whole row copied and deleted and existing rows moved up in "present" when I type the word "yes" in column E. The deleted rows are to be pasted into "removed", with two extra pieces of data - date removed and name of person removing it - to be asked in pop up boxes and inserted into col F and G respectively in "removed".

View Replies!   View Related
Copy Range Of Cells To Active Row In Second Sheet
Sheet 1 has data entered into it, it is then printed out as a jobsheet, saved and the data cleared. There are certain fields on this sheet that are eventually manually replicated onto sheet 2. The row in which they must go on sheet 2 will always be the 'activerow' on that sheet from a previous operation. It would make life so much easier and save lots of time if I could incorporate copying cells C10,C12,K8,K12,M2,C27 and C29 from sheet 1 to respective cells H,I,J,M,N,R,S of the active row on sheet 2 before I carry out the clear data process.

View Replies!   View Related
Copy Range Using Row & Sheet Name Variables
I'm trying to copy multiple cells on the same row, with the row number to be copied stored in a variable (x). Right now i've been trying to use the Range method, but this copies all of the values between "A" & (x) and "H" & (x). I only want the values of the cells in "A", "F" and "H".

(copy_sht) is the name of the sheet to be copied from
(paste_sht) is the name of the sheet to paste into
(copy_row) is the name of the row to be copied from
(paste_row) is the name of the row to be copied to
(x) and (y) - I'm not sure f these are necessary, I've followed a lot of examples to get here, so i'm a bit confused.

Function copyrow(row As Long, copy_row As Long, paste_sht As String, copy_sht As String) As Boolean
'Is passed the names of the sheets, the rows, and copies the data
Dim x As Long
Dim y As Long
x = copy_row
y = row
Sheets(copy_sht).Select
Sheets(copy_sht).Range("A" & x, "F" & x, "H" & x).Copy
Sheets(paste_sht).Select
Sheets(paste_sht).row(y).Select
ActiveSheet.Paste
Application.CutCopyMode = False

End Function

To recap, this code will copy all the cells between A(x) and H(x), but i only want the values of A(x), F(x), and H(x).

View Replies!   View Related
Copy Row From Autofilter & Paste To Another Sheet
I have 2 sheets. The first sheet contains rows of data that I wish to search (Query Results) through and find matching data. The second sheet is the source of the data I want to find (Notifications). I want to take the number located in column A on sheet 2 and then use it to auto filter the rows on sheet 1. With the range that is left visible on sheet 1 I want to select the first row (can offset(1,0) to remove the headers, and paste the selected row back in to Sheet 2 ontop of the row where I sourced the original number to filter by.

Once the item is pasted I then want to pick up the next number from Sheet2 to repeat the process until all numbers have been processed in Sheet2. I have been going round the block on this for the past few days!

Sheets("Query Results").Select
With ActiveSheet.AutoFilter.Range
On Error Resume Next
Selection.AutoFilter Field:=1, Criteria1:=vFroID
Selection.AutoFilter Field:=15, Criteria1:=vReqData
Set rng2 = .Offset(1, 0).Resize(.Rows.Count - 1, 1).SpecialCells(xlCellTypeVisible)
On Error Goto 0
End With
vDestRow = "A" & vLoopCount
If rng2 Is Nothing Then
MsgBox "No data to copy"
Else
Set rng = ActiveSheet.AutoFilter.Range
rng.Offset(1, 0).Resize(rng.Rows.Count - 1).Copy _
Destination:=Worksheets("Proposed Notifications").Range(vDestRow)
End If
vLoopCount = vLoopCount + 1

View Replies!   View Related
Copy Row From Sheet1 To Sheet Based On Cell Value
i'm trying do is have information from sheet1 copy to sheet2 upon selecting a value from a DV list. Based on my attached sample, in Column J, upon selected "Yes", I would like to get the information from A6:H6 copied to sheet2 in the same row. I've tried it with the "if" formula and writing a macro for it.

View Replies!   View Related
Find Row List Box, Copy Cells To New Sheet
I have a large sheet with serial numbers of machines in one column and more or less important information in other columns.
I’m trying to write a macro that is activated by selecting a serial number from a list box. The macro should then find the right row and copy cells from that row and paste them on another sheet to create a summary of that machine.

View Replies!   View Related
Copy/Cut Entire Row To Another Sheet Based On Cell Value
Based on the example and solutions from one of our friends post
http://www.excelforum.com/excel-prog...ell-value.html.

i want to know the code with the same data as posted in THAT example,changing the data slightly like adding "TODAY" & "TOMMORROW" as other key words which will be Cut/Copied as seperate groups one beneath the other.

I had attached the worksheet with the actual data & the final Required format.

View Replies!   View Related
Copy Entire Row To New Sheet If Column Data Is Matched
i need a macro that will allow an entire row from one sheet be copied into a new sheet.

so basically here is what needs to be done:

1. from my active sheet, look in Column 'D', select all rows in in column D if it has the word "Confirmed" in it

2. create a new sheet and paste all those selected rows to this sheet

3. delete this transfered data from sheet 1

4. in the new sheet, i need to add in titles as follows in columns A - O:

Ticket
OrgCode
Event
Event Status
Project Type
Project Status
Start Date
End Date,.....................


View Replies!   View Related
Maro Or Code To Copy Row B10 To Another Sheet As A Record
a macro or code to copy row B10 To another sheet as a record but paste it down a row as i keep overwriting previous paste, tried offset etc but still stuck. I HAVE THIS SAME PROBLEM ON 2 SPREADSHEETS NOW. All i need it to clone the top row everytime data is put there, but where the data goes to paste it down a row so creating a record. Also i need another macro to search the G10 cell of the same row for the word replace and if so copy that row to another sheet as well.

View Replies!   View Related
How Copy The Data From More Cell In Sheet1 To A Row On Sheet2 (others Sheet)
I want entry the data with different row and different cells, so when I click the button, the data on sheet1 is clear and copy to empty row on sheet2 and automatic create a border and automatic insert new row, so we can entry again and next. And I attached my sample Excel File with the description too.

View Replies!   View Related
Macro To Copy Cells Beginning From A Certain Row To The End Of The Sheet
I guess this is a simple one but I am not sure of the best way to do it,
I have number of points recorded for everyday in an excel sheet where first column represents date, second column represents group third column represents line and fourth column represents point as shown in the example below

3 19 2222 4324

2223 4325

2224 4326

2225 4327

2226 4328

"3" and "4" represent the 3rd and 4th day of the month, "19" represents the group and 3rd and 4th columns rest are line and point numbers recorded (2222 is first line of day 3, group 19 and 4324 is first point of line 2222 of group 19 on 3rd day and so on....).

I need a macro (or formula) to copy the cells of the last day written in the sheet up to the last row to a new excel sheet, reformat them so that first column has the word "Date" in its first cell, second column has the word "group" third has "line" and fourth has point.

so in the example mentioned here I need it to copy the cells of day "4" including the group, line and point numbers and format them in the new sheet so that first column has "DATE" then 4 for the rest of the rows, second column has "group" and 19 in the rest of the rows, 3rd column has "Line" and all line copied up to last row, 4th column contains "point" and all points copied.

View Replies!   View Related
Find Specific Cell, Copy Row And Paste Into New Sheet
I have a excel file with two worksheets. I need to find a specific row in column g, cut the entire row, and paste it into sheet2. I have started off by using this code, that I got off of some site. It works wonderfully in finding the specific cell, but just copys and moves the specific cell into sheet2. Whereas I need it to cut and paste the entire row where it finds the cell that begins with a 3 in column G.

Sub Copy_To_Another_Sheet_1()
Dim FirstAddress As String
Dim myArr As Variant
Dim Rng As Range
Dim Rcount As Long
Dim i As Long

View Replies!   View Related
Find Text In Column, Copy Next Row And Paste In New Sheet
Essentially, I have 2 Sheets:
"SheetWSS" = data to be copied
"SheetWSD" = destination of copied data.

Below is a sample of the data in "SheetWSS"
----------A------------------------B-------------------------C
1------Trade ID -------Description---------System no.
2--------579----------------Loan ---------------------- 7
3--------580----------------Deposit---------------------22
4--------702----------------Deposit--------------------- 11
5--------703----------------Loan ----------------------- 58
6--------732 ---------------Loan------------------------66
7--------733----------------Deposit-------------------- 99
etc...(no more than 10000)

Now, an explanation of the data:

1) I work for a small bank (CORP) that takes deposits and gives loan.

2) CORP books these trades using only system no. 7 and 11; other system nos. belong to customers.

3) When a single trade is booked, the 2 sides of the transaction is recorded (by Trade IDs) . E.g rows 2 and 3 relates to one trade. So if CORP loans money with system no.7 to CUSTB, who uses system no.22, it shows for CORP a loan and for CUSTB, a deposit.

4) Everyday, the data in "SheetWSS" is updated with a different number of rows from previous, but the number of columns remain the same.

So, here's what i'ld like the macro to do:
1) Go into Column C, find system no.7 and 11.
2) For each 7 and 11 found, Copy the next row . So if for e.g, system no.11 was found in C4, i want the ENTIRE ROW 5 to be copied.
3) Paste the entire next row in "SheetWSD" until we have a list of all opposing sides of the same transactions initiated by CORP.

View Replies!   View Related
Macro To Find Value In Cell And Copy That Row To Toher Sheet
I am working on getting a macro to find a name in column "B" and once found copy its row to another sheet. I have been working on an "IF" statement that checks for the given name and if true copies the row. I can not get it to keep checking and then stop using "loop" What i got so far:

View Replies!   View Related
Checkbox To Show A Certain Sheet.
I have a query Work sheet that has the names of my worksheets in the following format.. mmm dd, yyyy H15 has a formula that returns the sheetname as a value. What Id like to have is a checkmark that when checked it will take you to that worksheet. Ive played with it and came up with the following...but its not working...any advise??

Sub SHOW_H15()
'
Worksheets("Query").Range("H15").Text .Select
End Sub
Also id like to have the check mark named as "Would you like to see (h15) 's worksheet?"


One more thing...if a value is in H15 Id like the checkmark box to appear. If nothings in H15 dont show the checkmark Box.



View Replies!   View Related
Linking A CheckBox To A Different Sheet
I Am wondering if you can use a checkbox, to update a cell on a different sheet in the same workbook. CheckBox 1 is the box on say, Tab 2. And if it was ticked, would transfer the name to Say Sheet 2, cell B7.


View Replies!   View Related
Command Button: Copy Row Selected On Sheet2 Into Cells On Sheet 1
figuring out a code for a command button.

I have 2 sheets open with the following set up:

Sheet1
A2 = Name (chosen off sheet2)
A3 = Job Title (chosen off sheet2)
A4 = Department (chosen off sheet2)

Sheet2
Column A = List of names
Column B = Corresponding Job Title
Column C = Corresponding Department

I need to be able to choose a name off sheet2, click the command button and it send selected name, job title, and department to sheet1 to the respective cells.

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved