Search results

hello Friends and Ninja Friends, Writing after a long on Chandoo Forum with a lot of hope. Especially after Chandoo moved on and has also taken to a lot of HR Data issues.....!! I have in one table about 80 Work locations named W1, W2, W3......so on. Against each location I have a set of...

uploading files....

Hello GraH, Thank you for your reply on Power query that is very much an interesting possibility and perhaps the way forward for me. I am attaching 3 data files and 1 consolidation file, that I am now using with a Macro. I am interested in using Power query option on consolidation. Requesting...

Attached please find consolidated data file.

hi Macro Ninjas, I am using the below macro to consolidate data from 3 different files Source files into a Single Consolidated file. Each source file has variable number of sheets with a standard number of Data columns. In column B of each file in each sheet, there appears name of the...

I tried part (a) of my question in macro and it works fine, adds cc e mail address with a semi colon as separator.

Hey this is working beautifully. Have 2 questions (no hurry for response....) a) can I add "cc" e mail address here in the program: With OutMail .to = SendTo .CC = "" If multiple cc, then hope its ok to separate e mails with a semi-colon or a coma b) it opens outlook windows...

Hey much appreciated. Thank you.... will use this and revert.

Yes, you are right. Whatever size the Pivot table is on each sheet (row, column & value fields only) needs to be cut and e mailed. I have about 150 such Pivot Reports Sheets and each mail should be sent to the e mail ID sitting in the Report field of respective sheet... This needs to work for...

Hello all, I have created Pivot Reports that contain an e mail ID in Report Field of each report followed by a List of Data. I need help to create a macro that will open the workbook, read e mail Address from each report sheet, cut the List of Data ( with formatting intact ), paste it in...

Consolidation Macro Program you helped me with is working file... I have to know date/time when the users are edit of enter data. Is there a way? Sorry if i got carried away by my French ! :)

Bonjour M. Costa ! J'espere que ca vous trouve en tres bonne santee!! oui j'hazard pratiquer mon francais un peu !! j'ai besoin d'une tres petite aide...... Est ce possible de mettre-a-jour la date et l'heure sur chaque ligne ou l'utilisateur aura change ou ajoute des donnees...... ...

Hello Folks, For those who cared to understand this thread, apologies for posting almost a full time a software project.....but to update you, i managed to put together a report that automatically captures monthly and quarterly data and automatically shows trends of Quarterly Approvals V/s...

Hi, Is there some file to share on progression of this analysis. I have already managed a data consolidation tracker for similar data and would be interested to know more on Analysis and presentation ideas....

Hi all Dashboard Enthusiasts / Experts - Friends, Have a challenging Database cum Dashboard problem....will try my best to explain.... I DO NOT EXPECT A COMPLETE SOLUTION...... Any type of Conceptual help like giving Model formulas that can be adopted or Ideas to create a better data model will...

Wow.....You are damn good at this. This was fast. Will have a look and revert and let you know how it goes..... Thanks and have a nice evening !!

Sheet Add1 with new integer lrow1a will have a code as below: (the above is wrong) lrow1a = .Sheets("Add1").Columns("A").Cells(Rows.Count).End(xlUp).Row If lrow1a > 1 Then .Sheets("Add1").Range("A2:n" & lrow1a).Copy ThisWrkbk.ActiveSheet.[Table2].PasteSpecial xlPasteValues .Close savechanges...

Hi am sorry for the Password slip up....I did not save !! Now it should be OK.... This Macro is working well ..... What I mean to say is....up till now I had been consolidating Data from 10 files. Each file had a SINGLE sheet named ADD. Data in all 10 files (from 10 sheets) got consolidated...

Hi and Bonjour PCosta87 ! Hope you are doing very well ! In my consolidation model I collect data into Consolidation file Sheet1 from Datafile 1 - Sheet 1, Datafile 2 - Sheet 2, Datafile 3 - Sheet 3, ..... Datafile n - Sheet n I would like to now collect Data into a Consolidation File...

Sorry for delayed response...Actually I am helping someone else with this and solution looks fine....in case any variation is needed will request your help with a sample file. For now, thanks a lot for helping quickly !! Cheers!

hi all, ....finally I am here for this ! Column A contents = 1,2,3 in rows 1,2,3 Column B contents = 100, 200, 300 in rows 1,2,3 I want a formula that multiplies contents of Column A by Column B in Column C....but also would like a macro or a tiny vba script to be able to make all references in...

Hi and Bonjour !! I adopted the macro in creating data consolidation for trainings held at 10 different locations. Work around for insertion of blank row and titles in case there was no data is working fine....I like it a lot ! Compliments! Final file uploaded...

@ PCosta87, Hi your code works fine....now if the sheet is blank we do not get the headers..... It took time for me to replicate the code you gave for sheet "add" to the other 2 sheets viz.....Del and Trf_Mob..... Thanks to this code I was able to collect data last month by keeping all files...

ooops ! sorry for not providing PW...will look at this. thanks a lot !! Good Day!

@Costa, Greetings! No Problem for delayed response!! I have decided to keep the code as it is and run it only to collect monthly data.... I don't want to upgrade this anymore as it brings in more programing, validation and network complexities which currently I am unable to handle at the moment...