Thanks a lot admin. I noticed that it only the data on the second table is being copied on succeeding clicks and no dup checking if data for the day has already has already been exported. Could be...
Type: Posts; User: jeremiah_j2k
Thanks a lot admin. I noticed that it only the data on the second table is being copied on succeeding clicks and no dup checking if data for the day has already has already been exported. Could be...
Can anyone help on this pls? Thanks
Hello Team,
I'm having some challenges on how to copy the data from my 2 tables on PivotDaily sheet to tables on DataSummary sheet. PivotDaily tables can have as much data as possible and I need...
Thanks admin for immediate response. its working fine now. I appreciate your help :)
Hello guys,
Need a little help to modify the below codes. Currently it copies data from the the source workbook if its column label matches what we have in...
Hello Admin,
Can I re-open this thread pls.. or should i create a new one? I'm re-visiting this thread for a similar project and now having challenges on how to revise the code to capture the...
Thanks Admin and snb for your feedback. I appreciate you help :)
here's the snippet of my code:
Dim strFileSelected As String
Application.ScreenUpdating = False
With...
Thanks for your feedback.. :) is it possible to capture the "Last Save Time" of the file selected from the FilePicker and put its value in a cell?
Hello All,
Has anyone tried to capture the last date modified of the file selected from FilePicker? I'm trying to figure out how to insert the its value to a cell but getting an error using the...
Hello Guys,
I would like to ask your advise on how can we restructure the table from the attached spreadsheet. Can this be done using v/hlookup command or a macro? Below is the format that i need...
Thanks so much for the code Admin Excel Fox. Its working perfectly as needed. Thank you :) :) :)
Hello All,
I'm trying to make my workbook more flexible and trying not to depend on a fixed file path that's why i'm trying to use a combination of msoFileDialogFilePicker and lookup function but...
Thanks for the code admin... its working perfectly as needed and i really appreciate it.. thanks :)
I have uploaded the wrong file in post #1 but already changed it with the correct one.
Hello Admin,
Sorry for the confusion because I guess I did not explain the problem clearly. From the attached file in post #1, the button and code will run in the "Main" tab. B2 is a dropdown list...
Hi All,
I need a help to make my code work. I'm trying to rename worksheet one at a time but i'm having problem in using cell reference. see my code below and thanks in advanced for your help
...
Hello Admin... Thanks so much for the help... Your code works as awesomely cool.. thank you thank you thank you!! :)
Thanks Admin... file has been attached
Hello alansidman,
Thanks for the advise. Below are the files that might help you determine a suitable solution. Thanks in advanced :)
Excel File:
BLver10-Test
File snippet:
Hello LalitPandey87,
I will upload the file shortly... thanks :)
Hi All,
I would like to ask assistance in exporting data from several worksheets to create a summary report on a daily basis. Data are from xlsm files and they have a common name (Part of...
we can put a dropdown list to a cell reference and declare its position in the VBA code... for example
With OutMail
.To = Range("I5")
Hello snb,
sorry for the confusion. I used the code that you have provided and it worked perfectly as needed. However, I need to send out the worksheet that contains the data from the rows that...
Hello snb,
Thanks for your immediate response. Can you help me modify my code? As of now, it can split the data from rows into multiple worksheet but is it possible for that new worksheet to be...
Hello Admin... thanks for the suggested forum topic... I already have a vba code to send out worksheet via email on my tracker.. but thank you for the reply :)