#excel

I am trying to copy data dynamically from Cell C1:G till the last row in any of the column in the Range. Attached is the snapshot in which the highlighted area is something I want to copy. Could any one please help me out? Sub TEST1_1() Dim lrc As Long lrc = Cells.Find(What:="*", _...

I am trying to create a macro which copies and pastes filtered data from all sheets of another workbook. The below code does the job but lacks accuracy in filtering data. Please note the database range is same across all sheets of another workbook (Headers on Row no.7) Accuracy Problem: It...

Hi, I have a list of IDs from range A1, A2 and so on (Including Header in range A1) which I want the code to exclude while filtering the data from another workbook. My criteria range is B25:G26. I tried using <>*ID* by the pasting this in Range B26 (B25 as the header), which ran fine just for...

The below code tries to copy the filtered data from another workbook and pastes it into this workbook. Problem: Expected end of statement error is shown by highlighting the word ACTION. I have no clue why is this error appearing. Could anyone please help me? Sub Import_Data() Dim FileToOpen...

I have 7 sheets in total and want to make save as for the first 5 sheets with time stamp and password. The below code gives an error msg "wrong number of arguments or invalid property assignment" highlighting the word FORMAT. This code used to work perfectly before adding the the 7th sheet...

Hello. I am trying to find the correct formula to count duplicate entries with multiple criteria's. See example below. I need a formula to count all Orders in a spreadsheet that has certain words in that column as well is certain words in another column. I need to find out how many Orders I...

About the code: It copies sheet7.RangeB11 till the last used column when the word MAPPED is found in sheet7.RangeA11 and so on; paste them in the said destination. Problem: I have large data set (around 2,00,000 lines) and this code consumes a lot of time when compared to the task implemented...

Expectation: I want to copy data from sheet7.Range G10 till the last row and paste in sheet4, Row No.10, last column available. Problem: The below code does not copy or paste (no error is shown by the debugger). I dont understand where I am going wrong. Could anyone please help me? Sub cf()...

Expectation: Apply formatting to all sheets in one go. Problem: The Below code applies borders to the active sheet only instead of all the sheets (Except DASHBOARD sheet). I dont understand where I am going wrong. Sub Format_all_sheets() Dim sht As Object Dim lcol, lrow As Long For Each...

I want to check if the ID in sheet No.2, column B (Refer attached) is present in sheet No. 3, column B and copy the difference to sheet No.5, Range B11 along with NAME, COUNTRY, REGION & SECTOR. The below code only copies the ID to sheet No.5, Range B11. I want to edit the code that copies...

I have total 6 sheets in my excel workbook from which I want to make a save as of first 5 sheets whose sheet names are based on cell value of sheet(6) E17,F17,G17,H17.I17 [Sheet Name is DASHBOARD]. So if the value in the cell changes the names of the sheets also changes. Please find below the...

The code dynamically hides rows & columns. I want to apply this code in one go to multiple sheets. Sheets Names are based on cell value which means if the value in the cell changes, sheet name also changes. I am new to VBA coding, would be thankful if anyone could help me out with this...

Ok, so I'm working on a macro to automate data entry into a website. I've gotten stuck at the point of trying to click on a new link within and iframe. After a lot of googling I found that there is a handling issue with IE and tried to employee a work around someone suggested. The problem is...

I am using excel 365. I have a drop down box as an input parameter to a query. I need to be able to check is that input parameter is null. State: <drop down of available states> Report showing city, zip code and other data For the drop down box, I am using the following query: Select...

Hi i am beginner plz help me i have row like this +359 89 225 0572, +66 88 395 9003, +966 50 028 4406, +966 50 079 9716, want to convert in column like +359 89 225 0572, +66 88 395 9003, +966 50 028 4406, +966 50 079 9716, how can i do in excel?

Hi there! I've been trying to figure this out for long but i cant, and hence i need help with this. My objective is to calculate YTD numbers from a set of MTD numbers. So example i have this set of data: I will need to sum the figures based on these five categories AND obtain the YTD...

Hi Everyone, New to the forum and really appreciate anyone who can assist. Below is a simple version of a much more complex data set that I am working on. I am trying to get excel to identify numbers within a contiguous number range in a single cell and place an "X" in the corresponding...

Hello, I am working with commissions and %'s and I have a rounding issue I cannot get "around" (pun intended)…. The formula I am working on is: =45.90*15% =6.885 Should = 6.88 =77.70*15% =11.655 Should =11.66 I've used ROUND, CEILING, FLOOR and MROUND but no matter what combination, cannot...

Hello, I have excel with two columns: one is a city, the seconde one is a name of river. I need to find a intersection and get an unique value for each group. Each group is created from the same river and particular cities. If city has two rivers, this should be in the same group. But also the...