These links doesn't work to me.. Please share updated links... Check out my new web site.
Posts by Hanes109
-
-
-
That works royUK... !!!! Thank you so much!!! I have few more request. I will create new issue.. Thanks!!!
-
-
Hi All,
I'm looking for macro which will help me to copy all the sheets that contain "sheet name- Cart_" in active workbook and get separated into new workbooks with the file name same as sheet name.
Sample 1 File contains 5 sheets (including hidden)
Only 3 sheets contain "Cart_1"
Sheets That contain "cart_" should be exported into 3 new workbooks and saved in the specific folder.
Any help would be highly appreciated.
Thanks!!!
-
RoyUK, Yes. I need help. Creating a new issue shortly.
-
-
Thank you, Carim and RoyUK for your suggestions..!
-
Hi All,
I'm an Absolute nutshell in vba, looking for a macro that can combine all the workbooks present in the folder into a new workbook named "Final Data".
Below is the code
Code
Display MoreSub ConslidateWorkbooks() Dim FolderPath As String Dim Filename As String Dim Sheet As Worksheet Application.ScreenUpdating = False ''' highlighted part ''' FolderPath = Environ("userprofile") & "\Desktop\Test\" Filename = Dir(FolderPath & "*.xls*") Do While Filename <> "" Workbooks.Open Filename:=FolderPath & Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets Sheet.Copy After:=ThisWorkbook.Sheets(1) Next Sheet Workbooks(Filename).Close Filename = Dir() Loop Application.ScreenUpdating = True End Sub
The highlighted part is where the error occurs. Please share your suggestions.
-
Also if you take online classes, please let me know..
-
You're absolutely brilliant, Carim. Please send me your paypal link , I will pay you with what I can.
-
Carim, Is it difficult to build it ?
-
Thank you Carim
-
-
I'm sorry for confusing you.
This is the actual data.
Please view the new attachment.
-
So Sorry Carim, This is not what I was looking for.
I want Amount and currency to be edited from Edit sheet. and Base data should get updated accordingly.
I want to filter Coloumn A i.e Menu- Big Burger , Find the exact coloum (20043) & (20043C), Clear the contents of "coloum (20043) & (20043C)" matching to Big Burger. and update the new Data. i.e "44" Should be changed to "54" & "EUR" should be updated as "USD"
(All this should be done through VBA)
Please help sir!
-
-
As you can see in the attachment file, I have to edit my base data from "Edit sheet"
For eg:
I have to edit Big Burger data from Menu and update its price as per the Charge Number and it should be dragged down.
Please view the attachment and update your suggestions..
-
You're the best, Carim!!! I just have 1 more query. I will open new thread.. See you there..
-
Here is my new attachment. Please view this you will understand it clearly. Please!!