Search results

thank you for response. I have already used the mentioned example for other things but it would not work in this case.

hiya, did you tried recording macro? (sorry I don't know how to paste code properly here) then if you create new file with the same name, macro will pull info from this file >>> use code - tags <<< Sub pull_data() ' ' pull_data Macro ' ' Workbooks.Open Filename:= _ "your...

hello, I have problem with saving filtered data as separate file. I recorded macro and that works however it is saving everything as "book1" when I changed it to range the code tripped. the aim of this file is to compare extracts from fin programme to find new transactions, highlight them...

thanks a lot that works magic! genius! i'm still failing to understand why some codes may be adjusted and some can't

hi guys! I'm not good with VBA so I need help amending this code. I was trying to create macro to send form to specific email. this code works but I'm struggling to find a way to send only one sheet instead of full workbook. I tried replacing thisWorkbook with ThisWorkbook.worksheets("Form")...

thanks a lot for help guys! got it sorted!

hello, I'm struggling with changing my excel VBA code to word (don't hate me i'm a beginner :) ) that's my code it works in excel but not in word. can anybody please help me to fix it? it's tripping on filename=textbox1.text original excel code: Private Sub CommandButton1_click() Dim path...

that's amazing thank you!

hi, here's the example for one country, i'm trying to do it for the entire list

hello, I'm looking for help with analysing addresses. I have very messy list and my aim is to highlight every cell in columns A B C & D which contains country from list in column F. I tried conditional formatting but it works only on one country at a time. is there better way to do it...

hi Kenneth, sorry you lost me. where do I find the code? I know that could be done better but I'm a self thought VBA user so I'm lacking of the core skills with coding, that's the best I could do really XD

sorry here it is. I had to strip it of some info so may not work properly now

hello good people, I'm looking for help with my code. I managed to add code for "search" (so fetch back the entries from table to form) however I can't get it to update and I believe the issue is caused by listbox. can anybody help me to get this to work? here's the code for entire form, the...

sure, I had to delete most of info so drop downs wont be visible, but I test it several times and everything works except from list boxes multi choice and I can't find out how to code it properly because it keeps rejecting it. can you please help?

hello experts, can you please help me with VBA code for list boxes? everything is running fine until I try to implement code for list boxes 1 & 2. the data is just not feeding through to the spreadsheet table. can you please help? see my code below. I'll appreciate any help! Private Sub...

hello experts! I have probably trivial problem with my code. trying to present my dashboard in PowerPoint and link it to excel for automatic updates, unfortunately my code is tripping. Is that because I have more than one tab? please see the code attached. I'll appreciate any help. cheers! Mike

the better sheet which you sent pops up with this error. is it possible that different versions or excel may cause this?

hello again, just a quick question: is there any reason why those forms would work on some computers but not the others(tried them both)? seems like for some people code is tripping on date picker for others on iRow. That puzzles me because I checked that with 5 different users (same machines...

that works way better! I was struggling to find a clever way to protect it and hide buttons you made it just perfect! thanks so much

genius! thank you so much that works!!!!

hi gyus! i'm a beginner with VBA and I would really appreciate your help with my code. I have created form which was supposed to send data to the hidden, password protected tab. when the tab is hidden the form would send data to first sheet under the banner... and that's wrong ;/ is there...

see that's the s/s i'm creating. so it should allow to add new data all the time as new invoice will arrive and then be added to totals. Your code is brilliant just the only problem I have with it is that I have to have all the data in place before i run it. when i added new line after the data...

thanks a million! you are truly a excel Ninja ^^ can I bother you with one more thing? there was a bit of code which I was working on for my friend. It does similar thing but every time i run the macro it copies everything. i was trying to add If function to it so it will check all the values...

Genius! that's exactly what I was trying to do. would it still work if new items will be added or I would have to change the range? sorry for lack of proper explanation just couldn't really express what I need to do. ^^

1. yes, you are right the rows should be intact in "dane" tab only copy to other tabs for summary 2. this is the template for one year 3. formulas don't need to work in other tabs. 4. all the data for one month in "dane" tab has to be exactly represented in each month tab so no duplicates.