asked on

Port V2

I had this question after viewing Port v1.
Hi Experts,

Please help me with one piece of code which perform following task.
1 In attached WB there is one sheet Single Entry i need to post only those entries where "Cash" is mention in column D to sheet Cash.

2. After posting this Cash entries to sheet cash sort column B .

Portfolio.xlsm

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Naresh Patel

ASKER

Perfect

Naresh Patel

ASKER

Macro done task perfect but when i open WB it prompt to some message which is not there is my original attached file.

Thanks

Jacques Geday

It did for me too when I opened your attached workbook !!!
gowflow

Naresh Patel

ASKER

do you know where do i find links?

Thanks

Jacques Geday

yes I removed it it was maybe from your original workbook by an other user.
chk this version
Portfolio-V01.xlsm

Jacques Geday

When you open the file click File Menu at the bottom right you see Edit links and there you see it I press Break Links.
gowflow

Jacques Geday

Hv to step out will attend the other one when back. Hv send u a mesg.
gowlfow

Naresh Patel

ASKER

i did it but still after saving and open it again same message.

Naresh Patel

ASKER

May i ask follow Up Question ?

Thanks

Jacques Geday

Sorry I took time to comeback but was working intensively on your file as seems when you created the sheet Cash it was previously linked to an external workbook. I had to check each and every worksheet to see what sheet was pointing to an external workbook and could not find any it is only after that I discovered that sheet Cash was the culprit. I deleted the sheet and reconstruct it and now it is fine.

Please check this version of the file and use this version in your project from now on or else you will endup with the same link issue.

Please go ahead and let me know if you need more help.

gowflow
Portfolio-V01.xlsm

Naresh Patel

ASKER

Hmmmm in attached no issue...Thanks...after 10 min will shoot new question.

Jacques Geday

ok but if you need my assistance I will be back in 2 hours as need to go to hospital chk my father.
gowlfow

Naresh Patel

ASKER

ok i am preparing will post after 2 Hours.

thanks

Jacques Geday

As soon as I am back I will let you know in here. Thank you
gowflow

Naresh Patel

ASKER

FollowUp....Thanks