Dear Check this file ;)
Regards,
Mandeep
On Thursday, March 5, 2015 at 8:39:29 PM UTC+5:30, Prabhu Pinky wrote:
>
> Hi experts,
> I have around 10-15 excel file in a folder and updated every week.
> I need macro in master file which will open each file from folder and copy
> in master file.
>
send me your file and steps you want to achieve
Regards,
Mandeep
On Thursday, March 5, 2015 at 9:46:12 PM UTC+5:30, Mike B wrote:
>
>
>
> I try it works but goes back to what I just did even though I moved my
> cursor down 11 rows. I would appreciate any help how to get it to advance
> to the n
Dear Friedns,
Kindly help me in creating a conditional formating calander just like
goole calander.
My basis needs are as follows:-
1. Start Date
2. End Date
3. Days of Week( Could be Sunday to Monday any)
4. Start time of Class
5. End time of Class
This could be for many teachers.
Depending
I know the way to colorize a font in a vba for excel listview but to
colorize the background of cell in a listview?
For example the cell in row 3, column 4??
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of
Hi,
Hope you are doing great...
Please let me know your interest along with your updated resume
(If you are not available please refer this Position)
*[Please send resumes to r...@technotalent.com ]*
*Title: Senior OBIEE Analyst *
*Duration: 6 months*
*Location: Fond Du Lac, WI*
Are the file names always the same? or do they change when they are updated?
Do you open ALL the files in the folder? or just specific files?
To start designing your macro,
open the Master file, then begin recording a macro.
Then, open one of the data files in the folder
and do whatever you wou
I try it works but goes back to what I just did even though I moved my
cursor down 11 rows. I would appreciate any help how to get it to advance
to the next block that I am trying to copy and paste. I have about 7,000
rows of data to do.
Thank you
Mike B
Sub just_dates2()
'
' just_dates2 Ma
Hi paul, thanks for your response. Since i have some basic knowledge in vba
macro..if you share any macro related to my query i can modify that and
develop for my requirement.. That will help for me..
On 05-Mar-2015 8:51 PM, "Paul Schreiner" wrote:
> try searching in the user group.
> There shoul
try searching in the user group.
There should be several projects similar to this recently.
since your question wasn't specific, it sounds like you're able to modify the
vba code yourself, so the previous examples should be sufficient to get you
started.
If you need additional help, please pr
Hi experts,
I have around 10-15 excel file in a folder and updated every week.
I need macro in master file which will open each file from folder and copy
in master file.
Please help me on this.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Jo
Thank you Mandeep !!!
Now i got it.
Regards
Eugene
On Thu, Mar 5, 2015 at 4:49 PM, Mandeep baluja
wrote:
> giving correct results which is going in g7 and g8 what else do you want
>
> Sub test()
> ThisWorkbook.Activate
> mynum = "dw*"
> Cells(1, 25).Value = (mynum)
> ActiveSheet.ListObjects("T
You can use Data Validation to ensure "accurate" data entry,
but in order to have something execute when you open the file,
or check for complete entries when exiting the file would require
a VBA "event" macro.
These are macros that run when specific "events" take place, like:
Open
Save
Exit
Chang
giving correct results which is going in g7 and g8 what else do you want
Sub test()
ThisWorkbook.Activate
mynum = "dw*"
Cells(1, 25).Value = (mynum)
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1,
Criteria1:=mynum
lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To lr
Dear Expearts,
I have an excel file for which user will enter data, how ever I want to add
some Opening and Closing messages for the file for alerting users ensuring
of accurate and complete data entry. Is this can be possible through with
out using VBA Macro if not please can some one make the re
Mandeep,
Thanks for the reply. But this is not my requirement.
Please see the below macro.
Sub test()
ThisWorkbook.Activate
mynum = Application.InputBox("Enter a Code")
Cells(1, 25).Value = (mynum)
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1,
Criteria1:=mynum
End Sub
The user in
15 matches
Mail list logo