Search results

Thanks, Luke.

That might be possible by adding more complex functions to the rules, but it would take a lot of reprogramming, and I'm not terribly facile at using functions within conditional formatting. The spreadsheet's functionality really does depend on their order. Lame that this is a bug that hasn't...

I'm copying sheets by right-clicking on the tab and selecting Move or Copy.

Hmmm... Just tried to add "a1" to the beginning of each of my conditional formatting rules. Did that, then copied the sheet. The rules got all mixed up, just like before. Bummer, but it didn't work.

Luke - Thanks for posting this! Yes, it's a clunky solution, but if it works, it works. Thanks! David

I have a sheet in a workbook with 15 conditional formatting rules. When I copy the sheet within the same workbook, the copied sheet only has all of the rules, but they'be been re-ordered. Thoughts on how to fix this? Thanks, David

Thank you for your response, Luke. I'm creating the pie chart as an icon to use in a document in order to designate the percentage of time spent on certain activities. The numbers themselves are all black. Creating a VB script sounds very complicated, especially since I'm creating about 200...

I have a pie chart that references a set of data. I would like each wedge in the chart to automatically take on the color of the cell that it pulls from. E.g. If my data series is 1,4,3,5,8, and each wedge corresponds to one of those numbers, if the cell with "3" in it is green, I want the...

Did some research as Narayank991 suggested. Looks like global names can be referenced on any other sheet and local names can only be referenced on the sheet where the name is. I also learned that when you name a range on a table, that name will propagate when you copy sheets. So I updated my...

I downloaded the http://www.jkp-ads.com/officemarketplacenm-en.asp name manager. Very cool application! HOWEVER, when I used the button that looks up all references to the name, it showed no references to the name when the name was actually referenced in VBA code. Strange. I ended up deleting a...

...And is there a way to easily find out where a named range is being used (equations, VBA, etc.)? I know I can do a CTRL-F to search for the name. Is that the only way? I want to delete some names that I think aren't being used any more, but I don't want to mess things up.

I take it back. I'm having difficulty changing the scope in my names that are currently scoped as "Workbook." When I edit the name under Name Manager, Scope is grayed out. And when I go to the range that it refers to and click Define Name, it looks like it wants me to set up a new name. And...

Looks like others have this issue, too... All of my worksheets are in the same workbook. I see where I can change the scope (if I go to the range, highlight it, and click on Define Name, I'm able to change the scope). But what impact does that have? -- if I change the cope from Workbook to...

I'm using named ranges within my workbook. One of my sheets (Sheet 1) has about 5 named ranges. Other sheets in my workbook refer to those ranges. But when I copy sheets that have nothing to do with the named ranges (e.g. sheets that do not refer to the ranges), I get a bunch of messages that...

Thank you all for replying. I figured out a workaround using search and replace within the selected range. It may not be as elegant as the solution I was hoping for, but it works.

Thank you both. I will try to put together a sample file. Where does one upload such files?

I am creating an invoicing function in a table of sales (SalesTable). The code currently allows me to select multiple rows in SalesTable and then it takes the data from those rows (each row representing a line item sale) and creates an invoice. The code creates an invoice number. I'd like to be...

Thank you, Narayan! Works like charm (I used the selection.entirerow code).

Thank you both for your help on this. I tried Jeff's code and it works like a charm!

I think I figured out the error. But now I have the problem that it pastes the row at the bottom of the table, but the table doesn't automatically accept it as another row of data. So it's pasted below the table, but not part of the table. Hmmm... thoughts?

Luke - I tried the code with the following modifications: Worksheet("Entry").Range("2:2").Copy _ Worksheet("Sales").Range("A65536").End(xlUp).Offset(1, 0) Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False The idea here is that I'm...

Narayan - You are correct. I meant A1, A2, A3 -- three cells in three different rows. It could also be A1, B5, and E99. So, if I select cells A1, A2, and A3, I'd like the macro to automatically activate the rows for those three cells. From there, the code will copy the rows and paste them into...

Thanks, Luke. Great idea. To do that, though, I'd need to make sure that every cell in column A in the table has data in it, right? Otherwise I'm pasting into a row that already has data in it.

I would like to create a macro that copies a row of data on one sheet and appends it to the bottom of a table on another sheet. The only way I can figure out how to do it is to insert the copied row above the first row of data in the table (because I know that will always be row 2 of the...

shrivallabha - Thank you for these shortcuts. I use them all the time! David