Based on seeing your file(s) I offer this macro to be run from the master
file to add a line on each sheet in the master file
Sub getdailydata()
Workbooks.Open Filename:=InputBox(name of file)
For Each ws In Workbooks(Master.xls).Sheets
lr = ws.Cells(Rows.Count, 2).End(xlUp).Row
Set mf =
Hi Everyone,
I need a code for the following steps to be enacted
1. Save a backup file with the name counts - date.xls (this will be a
daily file)
2. remove rows with name (column B) matching with name in to be
removed sheet
3. copy value in name field and open the corusponding sheet in the
Best to ATTACH your file. Code could be simplified. ie:
last = Cells(Rows.Count, B).End(xlUp).Row
For i = last To 1 Step -1
If (Cells(i, B).Value) = ABC Then
Cells(i, A).EntireRow.Delete
End If
If (Cells(i, B).Value) = XYZ Then
Cells(i, A).EntireRow.Delete
Sorry, but i could not find any way of attaching excel in my mails
here. Could some one please let me know how I should go abot that.
Many thanks.
Varun
On Oct 23, 6:24 pm, dguillett1 dguille...@gmail.com wrote:
Best to ATTACH your file. Code could be simplified. ie:
last = Cells(Rows.Count,
Click on reply to this post via your gmail account. And then upload the file
as you would normally in any mail.
Sam
On Mon, Oct 24, 2011 at 9:28 AM, Varun vijvaru...@gmail.com wrote:
Sorry, but i could not find any way of attaching excel in my mails
here. Could some one please let me know how