Search:

Sorry...I want to loop from top to bottom actually and not bottom to top.. i also tried something like below but it's not working...


Sub Test()
Dim x As Integer
Dim y As Integer

y = 1
...

ok. I am selecting the end row in column A now... and i have removed the do loop but it's not running now..


Sub AddBlankRows()
'
Dim iRow As Integer, iCol As Integer
Dim oRng As Range
Dim i...

Ok. I tried below but it's taking very long...and got stuck...I believe something is going wrong...so is there a easy way to find non-blank cells in column A first and if it finds a non-blank cell...

I have column A populated with some text in cells after regular intervals.. for e.g. it starts from row A4 where i have company name and after 16 or 17 blank rows I again have one more company name...

It cuts the data correctly but keeps pasting the data in the same cell in column D which means it's overwriting previously pasted data, it's suppose to select the last blank cell in Column D...

I have set of data which I want to transpose from columns to rows.. the data has same 17 headers and 25 rows of data for different companies one after another in columns and I want the same to be...

Ok. But it's an internal email and I get it daily for some reporting...and manually downloading it takes some time...so I am trying to automate...please help me...

I partially agree with your comment since company don't want us to send some data through emails automatically since there could be a scenario where incorrect info gets delivered to someone and hence...

ok. It seems to be working but I get the outlook warning message .i.e. "A program is trying to access email information stored in outlook. If this is unexpected, click deny and verify your antivirus...

ok. It seems to be working but I get the outlook warning message .i.e. "A program is trying to access email information stored in outlook. If this is unexpected, click deny and verify your antivirus...

I want to copy the URL/Hyperlink from an outlook email which is received daily and consists of a 2 URL/hyperlinks and I want the second URL that starts with certain text like:...

I have the below macro which I use to download the email attachments from out with specific subject lines which are listed in an excel now i want to apply a filter on date .i.e. it should download...

Ok. I have added the folder reference below. Now I have the subject line in Cell B2 in the Sheet1 and Received Date in the Cell B3 of Sheet1, how do I refer to the same in the restrict condition.

...

My code is in excel 2010, how can filter it for a specific subject line and to search in specific outlook folder

I have email which I receive daily consisting of a hyperlink/URL, when i click on that link it gives me the option in internet explorer to open, save or save as, the file link is something like...

Hi westconn1 / vbfbryce, Any luck with the above macro code

yes they can be, but the price would be different so the sum total of Qty of Trade Alloc and Trade Exec line items should always match for a particular price and client name.

may be we can try...

Nope, I have pasted the desired result in second tab .i.e. Sample Filtered Data and if you look at the first example below. Now if you see the sum Total of Qty column for Trade Alloc row items is 9...

I have worksheet which consists of multiple columns of data, in this worksheet I have below 4 columns on which I need to apply following filter logic and if the filter logic matches then I need to...

Just one last thing, it creates the duplicates sheet, even when there are zero duplicates sometimes in the sheet. can we avoid created the duplicates sheet when there are no duplicates and show a...

Got it. It works now. Thanks a lot. Appreciate it :)

Now it shows Runtime error '1004' you cannot part of a pivot table report. or insert worksheet cells, rows, columns inside a pivot table report....

highlighted error line in blue...


Dim r As...

Now it shows Run time error '424' Object required on the line highlighted in blue.


Option Explicit

Sub IdentifyDuplicatesandmovenew()

Dim ws1 As Worksheet
Dim Row1 As Range
Dim Col1 As...

This works great. Only issue is that in the last column it starts as Match2, Match3, Match4 and so on. so basically even when it finds the first match and pastes it in the newsheet, it will tag it in...

Now it shows syntax error on the updated line (highlighted in blue)



Option Explicit

Sub IdentifyDuplicatesandmovenew()

Dim ws1 As Worksheet
Dim Row1 As Range

On more thing, though, Is it possible to add a last column in the end after copying the data to newsheet, with the text "Match 1", "Match 2" and so on, as shown in the below snapshot.


Also can...

Ok. I have updated the code by defining variables, but it seems something is going wrong. It shows compile error on the line highlighted in blue. Can you please help.


Option Explicit

Sub...

Thanks a lot. It works as expected :)


Sub ShowPivotDetailsmacro()
Application.DisplayAlerts = False
Dim r As Range, s As Worksheet
Set s = Sheets("Pivot")
cnt = Sheets.Count
For rw = 5 To...

Ok. I have tried below with combine sheets but it gets stuck on the line which is highlighted in Blue and Bold. shows "runtime error '1004' the operation cannot be completed for one of the following...

I tried the below but it shows errors on the lines which are highlighted in bold and blue. instead I can use the combine sheets method post running the entire macro, but I think we don't need to use...

Great. It works. thanks a lot :)

I have got the below macro to delete all worksheets in a workbook except few specified ones, but it shows type mismatch error on the line highlighted in bold. I am using excel 2010 version.


Sub...

Ok. This works. I have made a minor tweak for the row count. another thing, is it possible to move showdetail data of each matching item into one worksheet with the same macro, instead of separate...

It's working but it moves each original and duplicate set of rows into a separate sheet but I want all the original and duplicate set of rows to be moved into one worksheet and name it as "Filtered...

There were no attachments in this thread. I have a data in which I have some duplicate rows items (spanning across multiple colums) and I want to identify those duplicate row items along with...

can someone help with the above code.

can someone help with the above code.

Ok. Since the pivot table would have multiple such matching rows, scrolling through it and clicking on each of it, is not viable option, hence i want macro to do it for me. I can apply formula to...

Ok. Color coding is not important, I thought it makes it easy to identify the data using colors. I just need same original set of rows and same duplicate set of rows to be identified first and then...

Ok. got it. in that case how do i filter for both blue and red rows at one go from base data and also I don't want to hard code the filter range (highlighted in bold). can you help



Option...