Search results

Hi Trice, May I suggest the following very similar to what I use 1. you enter all the transaction values in a single column with income being positive and expenses as a negative. 2. have a column for each expense category that you will link to the main column by formula 3. Have a column for...

Sorry, just checking, please send the files, that is the best way to work. Cheers Kanti

Hi Jack, By removing the VALUE, you may have deleted the formula. There are a number of ways that can be used to link, so pleas send the files, the source and the target files, or better still just the relevant formula. Cheers Kanti

Post you question on linking I am sure we can help

Hi Jack, I notice from you picture on Dropbox that you ran the software on the Link sheet, remember this sheet is not protected, you must run it on a sheet that is protected

Hi, Are you keeping the old data, if not I doubt it is possible

thanks

Jack, will run overnight, I think that despite the not responding message it is working, albeit, very slowly. The size of your file is also no help, my machine has resource problems. cheers

Hi Jack, I looked at the xml properties file of some of your sheets, the protection does not seem the conventional from Excel, did you use some other programme to protect the files? Sorry to say so far no joy.

Ok, upload you smallest on Dropbox, that is if you don't mind doing it and send me the link on my email address for security reasons and I will test

Jack, do you have a small file you are having a problem with, i can test it on my side

Jack, Did you add the Code to the Worksheet or module, I added it to the Worksheet

Hi sridhar change this line: .UsedRange.Copy Destination:=ActiveSheet.Range("A1") to .UsedRange.Copy Destination:=ActiveSheet.Range("A20") kanti

Hi Jack, It worked on a protected sheet that i tested Best of luck, I hope it works for you

Cheers Lui, glad to help

Hi Jack, Check ou this link, I have not tried it, so lets see what happens http://uknowit.uwgb.edu/page.php?id=28850 kanti

PipBoy88, I think this will work as well Cells(12,9).Select Set InfFore = Selection.CurrentRegion with this you do not have to establish the lastrow or cell, provided the range is one contiguous block Kanti

Hi Steve, I have not tested the code, but have made an important change, .Attachments.Add ActiveWorkbook.FullName .Attachments.Add wbTar.FullName wbTar is the workbook that has been created, so no it will attach that one. please test and let me know if it is OK cheers kanti

OK got it, Look at the attached file, I linked the combobox to Q1 and changed the 3 formulas to suit

Hi, I used Macro recording and got the following, that converts the sheet to a PDF, saves and closes the file ChDir "C:\Users\xxx\Desktop" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Users\xxx\Desktop\myExcelPDF.pdf", Quality:=xlQualityStandard, _...

Hi Lui, I am not sure, when I select 3 for mandays, i get: SM = 1200 SDD 900 and SD 1350 is this not correct?

Hi Lui, sorry i do not understand what you want, please give an example of what your input is and your expected result.

Hi, You just copy/paste the range after you have filtered it. Only the visible data will get copied

Hi Jeet, Did you post these before?

I think you need another = sign in you statement Me.cmbMandaysAll.ListFillRange = "=ServiceDelivery!A2:A13" try this