pls share the data with us
Regards
Gawli Anil
On Fri, Jul 27, 2012 at 11:55 AM, David Grugeon wrote:
> Yes I would use Vlookups. The issue is to get the formulas to use the
> different sourcebooks. Probably your best bet is to cut and paste all the
> lines from the 10 source workbooks onto one
Yes I would use Vlookups. The issue is to get the formulas to use the
different sourcebooks. Probably your best bet is to cut and paste all the
lines from the 10 source workbooks onto one sheet so that it is easy to use
a simple vlookup. If you don't do this you will find you are using
Indirect
Hi Kevin
Add a hidden blank sheet called "Link" to your WB (or it may need to be
called "Linknothing" depending on what is actually in col J
Change the line
Sheets.Add After:=Sheets(Sheets.Count) '
to
sheets("Link" & MyCell.offset(0,7).value).copy After:=Sheets(Sheets.Count)
Regards
David Grug
Hi Rashid,
I worked from the first workbook of your query and made the code easier to
change to whatever you need. There is a main sub and a function. Actually
the function does most of the copy paste but I use it to return the row
number of merged cells. As for now, the code works fine with th
SOLVED!!!
wasted some 5 hours to get the answers in right cells,
used the following formulaes
=INDEX(OFFSET($A$2:$A$22,0,(MATCH(A53,$B$1:$V$1,0)+1)),MATCH(A54,OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1,0)),1)+1)
=INDEX(OFFSET($A$2:$A$22,0,0),MATCH(A54,OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1,0)),
I have created a budgeting process as follows:
I have a master workbook. My macro creates x workbooks for each of the
managers that I want to fill out their part of the budget.
Once the managers have filled out their items in their workbook I want to
know the best way to update the master work
Use the special cells offering for this but if you wanted to find something
else you could use data>filter>autofilter.
or to loop to delete start from the bottom up
sub delblanks()
for I =cells(rows.count,end(xlup).row to 2 step –1
if len(application.trim(cells(I, “a”)))<1 then rows(i).delete
next
A couple of observations:
-In your loop, you're never "activating" a cell, so ActiveCell never changes.
When you delete a row, the NEXT row becomes the CURRENT row.
That means that when you go from Row 1 to 1000,
if, in the first loop, row 2, column A is blank,
then row 2 is deleted, and row 3 mo
Dear Experts,
Sorry I send a wrong filesending the right one.
I need your help to storing data which generating from web. Details is in
attached file.
Please help
Thanks in advance.
--
Kalyan Chattopadhyay
Executive Sales Coordinator
R. S. H. Pvt. Ltd.
On Thu, Jul 26, 2012 at 5:19 P
Hello friend,
you have a circular Reference in D6 check it. than try.
anil
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not g
Dear Experts,
I need your help to storing data which generating from web. Details is in
attached file.
Please help
Thanks in advance.
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, a
Hi,
I could see that. David is helping on this. I can't look at it now. I see
this code or this task to be split into different modules. Each module
should take one or two loops. It'll be easier to work from that then.I'll
start again from this.The main loop for each column loops as many time as
12 matches
Mail list logo