No announcements
Found 1587330 threads
-
2 VotesAuto Filtering With Sheet Protect
Given the effort Microsoft obviously went to give creators/managers options with respect to cell and sheet features under protection it is definitely surprising.Answered | 4 Replies | 3885 Views | Created by AtlBo - Friday, January 27, 2012 7:28 AM | Last reply by AtlBo - Friday, January 27, 2012 8:46 PM
-
0 Votes
MsgBox Error Creating a Work Sheet with Auto Locking Individual Cells
Hi everyone, I am having a little bit of an issue with my auto locking cells and a message box that pops up when you move out of the cell.Answered | 3 Replies | 459 Views | Created by Green Shirt - Tuesday, August 11, 2015 3:15 PM | Last reply by David_JunFeng - Wednesday, August 12, 2015 8:42 AM -
0 Votes
Copy different cell value match the sheet name
On sheet AAA, put this formula into cell ...Answered | 3 Replies | 6305 Views | Created by Trade Student - Monday, June 13, 2011 6:20 AM | Last reply by CharAbeuh - Saturday, December 10, 2011 10:49 AM -
0 Votes
Insert image in specific cells in different sheet
You may try it by yourself, then you will learn more about it, after that I think you can deal with different requirement.Answered | 5 Replies | 500 Views | Created by QWERTYU - Tuesday, June 9, 2015 9:20 AM | Last reply by Starian chen - Thursday, June 11, 2015 1:50 AM -
0 Votes
Macro to Link Cells between two sheets
Thanks everyone for the different methods.Answered | 8 Replies | 451 Views | Created by tuchellis - Thursday, August 17, 2017 7:19 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Saturday, August 19, 2017 4:16 AM -
0 Votes
MsgBox Error Creating a Work Sheet with Auto Locking Individual Cells
Hi everyone, I am having a little bit of an issue with my auto locking cells and a message box that pops up when you move out of the ...Answered | 2 Replies | 717 Views | Created by Green Shirt - Tuesday, August 11, 2015 3:44 PM | Last reply by Green Shirt - Tuesday, August 11, 2015 4:21 PM -
0 Votes
Consolidating / linking sheets
Here's some code that will create links to multiple files that share a common sheet name.Answered | 2 Replies | 404 Views | Created by Pete198 - Wednesday, February 1, 2017 3:50 AM | Last reply by Pete198 - Thursday, February 2, 2017 2:38 AM -
1 Votes
Excel 2007 Linking Cells
Try something like this (Change as applicable) Sheets("Sheet1").Range("A1").Value = ...Answered | 1 Replies | 1374 Views | Created by Lelia Diane - Tuesday, September 10, 2013 5:45 PM | Last reply by Siddharth Rout - Tuesday, September 10, 2013 5:48 PM -
0 Votes
link or update large excel sheets
This is an Excel file created by Oracle via the program Discoverer, and contains one tab [Sheet 1] with 14K rows and 32 columns.Answered | 5 Replies | 1247 Views | Created by Mark Matzke - Thursday, November 6, 2014 1:03 PM | Last reply by Cliff Anderson - Wednesday, June 22, 2016 4:01 PM -
0 Votes
Lookup and change Data in cell on Lock Sheet with code..
I have made a change because ny sheets are Lock by Password.Answered | 4 Replies | 611 Views | Created by Henrik-1 - Wednesday, November 26, 2014 8:10 PM | Last reply by Henrik-1 - Monday, December 1, 2014 4:19 PM -
2 Votes
Is there a way to auto-replace a part of a formula based on a cell value?
Worksheet_Change is according to worksheet, if your cell change between sheets, this event would not fire.Answered | 3 Replies | 491 Views | Created by K1NJO - Monday, November 2, 2015 7:27 PM | Last reply by Edward8520 - Friday, November 6, 2015 6:16 AM -
0 Votes
CREAT 30 CELLS SHEET IN 2007
HOW TO CREAT 30 CELLS SHEET IN 2007 Hi RABADIYA, Could you please elaborate a bit on your question?Answered | 2 Replies | 3940 Views | Created by RABADIYA - Saturday, January 7, 2012 8:58 AM | Last reply by Papy Normand - Monday, January 9, 2012 7:52 AM -
0 Votes
Insert a number in the locked cell and in locked sheet
You could enter a formula in the cell before the sheet is protected.Answered | 4 Replies | 1706 Views | Created by VALL2 - Thursday, August 30, 2012 11:09 AM | Last reply by VALL2 - Thursday, August 30, 2012 1:19 PM -
0 Votes
Read a List of Cells in an Excel Sheet
private void GetExcelValue() { string sInputFilePath = sFilePath + sInputFilename; ...Answered | 4 Replies | 931 Views | Created by Shayaan - Tuesday, October 21, 2014 12:52 AM | Last reply by Kareninstructor - Friday, October 24, 2014 10:30 AM -
2 Votes
Auto-linking cells in different sheets
But VLOOKUP doesn't help me to make a form to insert data into this sheet.Answered | 11 Replies | 495 Views | Created by Daniel Joachim - Friday, February 6, 2015 11:44 AM | Last reply by Daniel Joachim - Thursday, February 12, 2015 3:48 PM -
0 Votes
Read cell comments , cell number and the associated sheet using c++
You can get all the cells of sheet by Worksheets(1).usedRange.SpecialCells(xlCellTypeComments).Answered | 1 Replies | 1324 Views | Created by SAI KALYAN - Tuesday, August 28, 2012 6:35 AM | Last reply by Asadulla Javed - Tuesday, August 28, 2012 7:08 AM -
0 Votes
Macro to clear content of cells in one sheet that matches cells content of another
Private Sub CommandButton1_Click() Call demo End Sub Sub demo() Dim rng, rng1 As Range Dim row, row1 ...Answered | 4 Replies | 558 Views | Created by RCSmart01 - Saturday, September 9, 2017 4:58 PM | Last reply by Herbert Seidenberg - Friday, September 15, 2017 2:20 PM -
1 Votes
Table Cells Auto Highlighted
ML, Yes, that is what change cell highlighting does.Answered | 6 Replies | 15849 Views | Created by MLCinc - Monday, September 19, 2011 12:37 AM | Last reply by Mxaxrxyx - Friday, September 30, 2011 12:53 PM -
4 Votes
Copy indivisual Cell from one Sheet to Another Sheet
Since you're copying non-adjacent cells to non-adjacent cells, I'd use Offset.Answered | 12 Replies | 1789 Views | Created by Kahn-Cann - Tuesday, September 18, 2012 9:17 PM | Last reply by Hans Vogelaar MVP - Wednesday, August 21, 2013 12:54 PM -
1 Votes
Copy/Paste Columns from Sheet 1 to Sheet based on cell dropdown change on sheet 1
I would like to copy various column ranges from the "Input" sheet and paste them (values&formats) ONLY onto the "Report" sheet each time ...Answered | 3 Replies | 816 Views | Created by shahji786 - Thursday, August 14, 2014 5:24 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Thursday, August 14, 2014 7:46 PM - Items 1 to 20 of 1587330 Next ›
No announcements
