Search results

This inserts at a 1:1 ratio. That is, whatever I enter on Sheet1, in any cell, is inserted in the same cell address on Sheet2. That is, if I enter 'hello' in Sheet1 cell D3, 'hello' is copied to Sheet2 cell D3. I need the last string, written in any cell in column A Sheet1, to be copied to cell...

I’m not certain how to ask my question, so I’ll state where I need help, give an example and follow with the question. I enter data into rows on Sheet 1, with each following row (2, 3, 4, etc.) representing a new line of data. I’d like each new line of data to be auto-inserted , over-written in...

Thank you Atlas Johnson and NARAYANK991! You both are fantastic!

Thank you both for your replies. What I failed to mention is that I would like the fill color, in column A, to stop when both cells B and C, beside it, are filled.

Could someone please help me with conditional formatting? I’ve been trying to figure this out with the help of videos and web pages but I could really use an expert. We send samples out for micro and heavy metals testing. A sample can be tested for micro, heavy metals, or both. An X is placed...

Hi Hui, I followed the instructions and copied Print_Control to the front of one of my workbooks. I then pressed the magic 'Setup Print Control Named Formula' button but nothing happened. I've got 143 worksheets in this particular workbook so I'm not sure if it will work. Is there a way to...

Thank you Hui. I just downloaded the sample file and will be trying it out shortly. I'll get back to you in a bit to see if it is what I need. Thank you again. Bob

Hello all, I have found (and tweaked) a wonderful macro that creates a hyperlinked table of contents (TOC): Sub Create_TOC() Dim wbBook As Workbook Dim wsActive As Worksheet Dim wsSheet As Worksheet Dim lnRow As Long Dim lnPages As Long Dim lnCount As Long Set wbBook = ActiveWorkbook With...

Hi Luke, Ya, I tried that and it worked...ok. I will have many different variations so I'm not sure I will be able to do that. I'm just surprised that the only relationships available are one-to-many and not many-to-one.

I am trying to build a hierarchy using excel 2010 SmartArt. I'll give a verbal example of what I am trying to do. My first represents a holding tank that is full of water. Out of this tank are two separate water lines (line1 & line2), with each line using its own pump (pump1 & pump2). Pumps 1...

Hi Luke, I figured this all out on my own, thanks to your code. Check this out. I am so excited! Sub Set_All_Sheets() Dim wkbktodo As Workbook Dim ws As Worksheet Dim DeptCode As String Set wkbktodo = ActiveWorkbook 'Gather's user input Craft = InputBox("What is the Craft?&#34...

Hey there Luke, You have inspired me to customize my coding to exactly what I want, however, I've run into a little snag. I don't know enough VBA to set the line of code to fill my header with the results from the input boxes (HeaderCraft and HeaderInterval). I've played around with different...

I'm sorry but I do not know how to mark this thread as solved...but it is...solved.

Thank you all so much for your help. I was able to get the code I need form another site. This was exactly what I needed: Sub Set_All_Sheets() Const StartNum As Long = 7510001 Dim wkbktodo As Workbook Dim wsIndex As Long Set wkbktodo = ActiveWorkbook For wsIndex = 1 To...

I appreciate both answers above. Hui, one challenge I face is that there are many different forms of equally differing sizes, so having a dedicated cell is not possible. xld, I played around with your code, trying to make it fit my situation but am unfamiliar enough to not be able to work out...

I'm sorry if this has been discussed elsewhere but I have been looking all over for this answer. I feel like this is my last resort; I hope you can help. I am in charge of developing forms on Excel. With ONE worksheet containing only ONE form, each workbook will have any number of worksheets...