You both ROCK the forum.
Type: Posts; User: carmine; Keyword(s):
You both ROCK the forum.
Thanks RG, I have attached the sample file along with results, Please have a look.
This codes Displays Message Box from Row (B2) onwards in Sheet2 (named :Level2)
Dim Rng As Range
Dim c As Range
Set Rng =...
Below codes works fine for me, In Column C if it has a value of '2' then set cell color to Red.
Dim ChkRange As Range
Set ChkRange = Range("C2:C200")
I have attached the sample text file and excel workbook.
I will import single text file and Column B will be the name of sheet. The data to be sorted on column B and then transferred to...
I have 4 text files in a folder & format, structure of files are same.
I want to import all 4 files simultaneously to a workbook with each text file having their own sheets.
Any one, a...
AWESOME kweaver & Maud.
Exactly thats what i was looking for.
One thing if the number is increased in thousand than it does not give the output.
Like starting 17500 Points 2000 How to do that.
No, if its greater than 100 than split it into 100 each. if Col D points are 150 then split 100 & second one 50.
In the same sheet in descending row order.
Thanks in advance
I have points in Column D wherein if the value is greater than 100 then divide it into group.
Col A---------- Col B---------- Col C---------- Col D----------Col E---------- Col F...
Thanks Paul T.
Thanks R.G. Thanks a lot.
I very new to powershell and i need help to achive this.
At one stage of my poweshell script i want to define that if start time is 11:40 P.M. then hold this running script till 12:01...
Thank you, Paul Edstein for your help.
I have attached the sample file wherein i have mentioned the Employeed ID in the very first line,
Once the letter is printed i will mark Employee ID on very first line.
Now onwards the document with a 'Employee Code' on the very first line of the document.
Well, I agree with it and if i flag Employee Code or ID on the very first line than that would be more sensible. What's your advise.
I have uploaded the sample file.
Nicely written codes it works like a charm.
I want to name the splitted pfd files from the word document which is located on the 6th line for the next 8 characters instead of ascending...
The below codes splits the files and creates a word document and its perfectly working to me desire, I want this files to be saved as pdf files instead of .doc file and want to add addin...
This is making me crazy, at end of data rows it appends zero's '0' .Please have look to image uploaded.
Thanks Steve for supporting.
Well, it gives Run-time error : No cells were found on this .SpecialCells(xlCellTypeConstants, 16).ClearContents.
On sheet1 2471 rows and on sheet2 2467 rows are...
Thanks kweaver for solution, is it possible to automate the process of filling the formula thru macro, why because it will set values instead of formula in the cells and i don't have to drag it to...
On sheet1 i have the complete data and on sheet2 in Column 'C' & 'F' have values in them. I want these two cells conditions to lookup in Sheet1 and get values for Column 'A','B' & 'D','E' ...
Thanks Kweaver for the response, the formula is perfect, 1 more request i want to convert the formula to macro which will fill down the column A with ONLY VALUE.
It means it will not have formula in...
I am trying to vlookup the value e.g. 005 from a table but the column that i want to vlookup will have the format 800021005.
There are 9 fields but i want to have only the last 3 fields,...