Is it possible to send me the excel file itself?you can send it directly to my
email (schreiner_p...@att.net) rather than posting it to the group.
Your first question is a bit confusing.Copying values from one cell to another
is as simple as:
Range("I7").Value = Range("D8").Value
Range("J7").Valu
Thanks Paul!!!
it works perfectly fine.
This is the code that I have so far. first time working with a pivot table
macro. the final result should like the screen shot below.
the problem is
1) how do I copy the data highlighted in blue and yellow to the right table
in green? I tried using the
Yes, this is much easier to understand.Did I miss where you mentioned your VBA
code before?I TOTALLY didn't understand that you were working with VBA.I
thought you were using Excel functions.
So, now that we're on the same page, let's take a look at your code:
When the macro first runs, colLast i
I am a bit confused with your question.
This is what I am able to come up with so far.
maybe you might be able to understand what I am trying to do from the code.
So I was able to come up with this but it is not placing the value in same
come as the word type
Dim colLast As Long
Dim Rng
I'm sorry, I STILL do not understand.
How does the value in column "J" determine the value to display in column "O"?
as for "empty" rows.How can a row be empty if it has a value or something in
it?If it has something in it, it is not empty.If it is empty, it doesn't have
anything in it!?
I suspec
I am using 2010 excel.
I have attached a file. The value in column J will determine what will go
into o. So I don't have the value for column o stored any where.
what I mean by delete row. Is to clean up the rows after the last row with
data. Sometimes some rows might be empty but have in val
It would be helpful to provide a sample file.But:What version of Excel are you
using?
Where do you get the values for column "O"? Your example has entering "utility"
when something other than "fuel" is in column J.Are there other values?
And, what so you mean by "Delete any extra line after the l
Hello All,
Please I need help with the below macro.
I have a worksheet with lots of data.
1.
I want to go through each cell in column J.
To find data and put the answer in column O.
2.
Then left and Right trim spaces
3.
Delete any extra line after the l
