-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
numerical value
-
S
Pivot tables using an external CSV file is pulling numerical data through as text
Good afternoon, I have to run large reports from a system so I generate the output in csv format. In the past I would run a pivot in excel using SQL to pull in the data from the CSV. Recently the source system has been upgraded. Since then, if I open the pivot I can see numerical data as...- scanavan10
- Thread
- numerical value pivot sql text
- Replies: 2
- Forum: Excel Questions
-
Numerical value of a colour
Hello all I'm looking for a function/formula to get the numerical value of the background colour of a cell.:confused: Thanks Catalin- cata2200
- Thread
- cata2200 color colour numerical value
- Replies: 4
- Forum: Excel Questions
-
D
How do I make my Macro stop copying the title row too??
Hi, In my macro, I am copying and pasting a value, this is the code: If Cells(i, 7).value > 0 Then With Cells(i, 7).Select Selection.Copy Cells(i, 9).Select Selection.pastespecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...- dig475
- Thread
- macro numerical value
- Replies: 2
- Forum: Excel Questions
This Week's Hot Topics
-
separating multiple Proper names (uppercase letters) from a list
- Started by Keebler
- Replies: 35
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into... -
'for' Loop
- Started by RAJESH1960
- Replies: 29
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to... -
Open specific pdf in folder with vba
- Started by ipbr21054
- Replies: 34
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it... -
What is wrong with this For Loop code?
- Started by thardin
- Replies: 20
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a... -
Data to match
- Started by dinkss
- Replies: 20
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I... -
Shifting Columns
- Started by Andresleo47
- Replies: 19
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...
