Hello Friends,
I'm encountering an issue when copying records from a database and pasting them into Excel. Excel appears to automatically remove leading and trailing spaces from the data, as well as trim leading zeros, which alters the original format of the data.
I need to preserve the data...
@Marc L, with the new set of data in #7, I have added all the possibilities. Apologies for missing it out for the first time. Could you please help me with the VBA code?
Thumb rule is if the Sheet1(Raw) has 9 rows then the results sheet "Expected" should also only contain 9 rows with the...
@Marc L, I see a problem with the above logic. Could you please help me in fixing the same?
Please check the attached file "Book2" if there is a space after the first date and if there are two sentences. Then it copies it to two cells in the second sheet. For example, please look at the cell A1...
@Marc L, the attached workbook in #1 contains two sheets (Raw & Expected).
Raw:
It contains 3 rows (in Column A), actual data is around 15000 rows in Column A. What i wanted to do is to extract information out of these cells and put the resulted [extracted] information in another Sheet...
Hello Excel Gurus,
I would like to extract specific details from every cell [around 20000] in Column A using regex or any other possible/easiest way. I have attached the sample file with this message which contains 2 sheets. Sheet "Raw" contains the raw contents and the Sheet "Expected" has the...
I have an excel sheet containing some information in rows (around 6 Lakh) and columns (around 20) and the file size is of around 150 MB. When I open the file the memory utilization of the system (Windows 10) reaches upto 640 MB. Is this normal? Is there a way to reduce the memory utilization for...
@Marc L, the new one helps. But is there a quick way to cross verify whether all those data's are unique? And how many maximum unique combinations can be made from the given data?
I have tried to increase the loop by 600000 but not able to populate the data more than 16384. I have attached the workbook for your reference and also the error message which occurs during the execution.
Can you please guide, on what I have missed?
Run-time error '1004':
Application-defined...
Hello Excel Gurus,
I see this is one of the fantastic and active forum for all excel queries and issues. Thank you for the good work. I would like to get some help in populating some data using a VBA. Below are the details for the same. Any help would be appreciated.
060657-295X
DDMMYY-295X...