Search results

Hi, emmatm! At last somebody asked something for improving usefulness; target worksheets in the same workbork isn't the best & handy idea. Let us do something,: a) while I adjust the code for a generic workbook, you upload the additional one just to check worksheet's structure and format. b)...

Hi Somendra Misra! Same as Marc L, but better later than ever. Regards!

Hi, YasserKhalil! You're welcome. It includes a link to another project that maybe some find useful or at least interesting to read. Regards! PS: In fact there are a lot of threads that got their URL modified -so unreachable from searchs and links at other posts) when Chandoo moved from the...

Hi, emmatm! So let us negotiate the last point. Hidden columns. Any suggestions that will make me work as little as possible and that don't make you suffer a lot (a bit is acceptable!)? Regards!

@YasserKhalil Hi! Yes :(... Neither mine :DD Long time ago when I used to work a bit more than today I developed this: http://chandoo.org/forum/threads/folders-files-matching.6312/#post-35692 It contains recursive file and folder search, but Monty asked for quick code and actually this isn't...

Hi, J.Ulmer! Welcome to Chandoo forums! Formally, since you seem to have been around for a while. Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, output in 3rd worksheet with format of 2nd one? Regards! <Edited: arrived late, John Jairo...

Hi, Monty! Would it be possible to move them to the same folder? That will make much easier the required code. Regards!

@YasserKhalil! Hi! With how many decimal places? o_O Regards!

Hi, emmatm! Firstly 2 answers. 1) This code Const ksWSSource = ",Projects,Small Works,Tech & Crate,Tech Only" Const ksWSTarget = ",All,Scheduled,Completed,Progress" holds the list of source worksheets (1st line) and the list of target worksheets (2nd line). I assumed that target...

There!

Hi, jb! This is your uploaded file with blank rows and columns inserted between every used rectangle of 2x1 cells. 8 rows by 17 columns = 126 blocks. 36 of them with incomplete borders, almost 30%, 28.57%. Regards!

Hi, Chanduraj! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards

Hi, Kathybug1964! Gone yet thru this? Just advise if any issue. Regards!

@dan_l Hi! Neither one of them. Regards!

@Marc L Hi, buddy! Maybe you can use Option Explicit and define variables once in a blue moon... For a couple of coldfusioned Carlsberg update it for both x86 & x64? Regards!

Hi, Eloise T! I'm struggling to refrain suggesting my top-10 best place list... :mad::confused::eek::oops: Regards!

Hi, emmatm! Give a look at the uploaded file. I didn't touch anything of the VBA code (only in Module1), except for 2 lines in worksheet Progress, and added the following code to Módulo1. Option Explicit Sub DifferenceBetweenEngineersAndArchiects() ' ' constants Const ksWSSource =...

Hi, emmatm! Transfer means move, not copy, isn't it? Because of the topic title... That means: a) you don't want the headers to be copied b) you don't want to manually copy the headers You tried to mean column P, right? And one thing more: Will the target worksheets contain data at move/copy...

Hi, Eloise T! Removing data validation... select cells, Data tab, Data Validation, Allow any data (or something alike). Regards!

Hi, Katybug1964! Cheating was allowed? As I edited all my previous posts to remove the mute "h"... ;) Regards!

Hi, Eloise T! Try a little one and a normal on another machine with Excel 2016. Regards!

<Thread closed as required, duplicated in VBA Macros with answers yet there>

Hi, Katybug1964! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards PS: In Spanish aitch (h) is mute :p PS2: Where do you see it in your name? :rolleyes:

Hi, Eloise T! A few comments: Would you describe your experimentation step by step leading to the crash? Does this crash always happen under the same conditions? Tried uninstalling and reinstalling Excel/Office? Tried experimenting on another machine with Excel 2016? Regards!

Hi, ThrottleWorks! Coldfusion... Coldfusion... o_O Ah, I remember it now! :rolleyes: That of The Saint, with Val Kilmer and Elizabeth Shue... :DD Regards!