Hi
I have a task of collating data from 20 or 22 text files in excel however, 99%of time I will have data in text delimited format but 1%chance that out of the 20odd text files 1 file will have the data formatted using text to column function when u test check it while opening the text files...
Hi Guys,
I have shared the link for my Workbook"Sample_NS", please see the below link.
https://drive.google.com/file/d/0BwN-9A9jHDNcXzU4R0ZQVFZOVnM/view?usp=sharing
In the "Sample_NS" workbook there are two worksheets "Ashok" and "Shruti"
both Sheet contains Task Owner and Team Member where...
Hi everybody,
I am new to Macros and VBA in excel and just know few basics.
Please anyone kindly help me with this query.
I have workbook in which there are 3 sheets named as Summary(sheet1), Detail(sheet2), Data(sheet3)
No my query is how to copy values from Data i.e Sheet 3 (B12, D12, E12...
I am trying to move a whole row(B thru K of the row) to a different sheet when in column (B) on worksheet named Promises, you put either; PAID which would move the row to worksheet named Kept; BROKEN to worksheet named Broken; FOLLOW UP to worksheet named Followup.
On the next blank line in...
Hi All-
I am trying to create Master List (sheet) that will merge all other sheets in the workbook. At same time I need it do following, i got first one to work.
Exclude several sheets from showing up in Master list - Done :smile:
Exclude Heading rows from all these sheets when i bring it into...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.