Hi Need help to link excel file which will be place in individual desk tops of the employees to one database which is placed in Shared drive.
Thanks
Raghava Sharma
Hi Team,
I need help to get VBA code to Check if the Value in Cell A5 is not less than -10 and Greater than 10 then the Value in A5 should be copied and pasted in column E.
if A5 Value is -6 it should not paste any value in column E
if A5 Value is 16 it should paste the value in column...
Hi ,
I am actually creating an copy of an existing sheet (A) when the copy is created the name of the same should be changed to X. once the name of the copy sheet is changed to X i need to hide it . and code should work when the work book is in shared mode.
Thanks in advance for help
Hi
the Value are not selected through List in DATA Validation, it by macro i am adding them to the Combobox list .so that the user cann select the value . but now i want the user to able to select the more than one value from the list.
Hi There,
I Have An combo box in which i have 9 Values , Currently i am able to select only one value in the Drop list , i want to know if we can Select more than one value.
In detail: if i select Value " a " from list , next i should be able to select B as well, and list should show both...
Hi
I have three different text which needs to find in entire row 16 and set that colummn as variable.
Exmaple: TEXT "RecAmount" is in cell (C16) the i need code to identify the column # which is 3 in this case column c is Third column Set the same as = X
TEXT "DocAmount" is in cell (G16) the...
Hi Thanks for your quick response....
i also want to know incase if my text value is also changing then do i need set C for = "recamount" and SET C1 as = "DocValue" Set C2 as = "Doccurr"
Thanks
Hi ,
I have an text as heading (RECAmount) in each file which might change its location , example in file A that heading is in Cell F16 and in file B it is in Cell G16.
Can i have a code which finds the Text in row 16 of all columns and also activate the cell in which the text is found...