Software

Ask Software Development Questions and Get Answers ASAp

Ask a Computer Expert,
Get an Answer ASAP!

Software

I have a simple live excel report that I add notes to in

Customer Question
columns that are not part...
I have a simple live excel report that I add notes to in columns that are not part of the "refresh" cells. However I want the notes to follow the row it is beside once it is refreshed. I can describe what cells the notes need to follow to make it work.
Submitted: 11 months ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Answered in 5 minutes by:
11/25/2016
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago
Bhavik Joshi
Bhavik Joshi, Software Engineer
Category: Software
Satisfied Customers: 626
Experience: Product Developer at Computer Science Corporation
Verified

Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.

Ask Your Own Software Question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Please give me few examples to understand this problem in a better way.

Ask Your Own Software Question
Customer reply replied 11 months ago
Hi
I add notes in column K. When refreshed, sometimes the rows are removed completely and sometimes they jump up or jump down. The notes would have to follow column B (work order) AND H (Op Code) to stay in the right row. i need you to write a macro.
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Okay. How you are refreshing the Excel ?

Ask Your Own Software Question
Customer reply replied 11 months ago
go to DATA, then REFRESH ALL
Customer reply replied 11 months ago
enter * if it asks you a question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Ok. I can see it now. When I refreshed it . My Comments were gone from column K

Ask Your Own Software Question
Customer reply replied 11 months ago
then make a macro for the comment to look for the correct work order (in column B, and then the operation in column H). If for some reason that particular work order was closed and disappears, I dont need the note anymore anyway so I dont care, however if the work order (or ROW) still exists, then I want the note to follow it.
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

I got your requirement. I have started working on it.

Ask Your Own Software Question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

I think, I found the trick.

Ask Your Own Software Question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Please check this excel .

Ask Your Own Software Question
Customer reply replied 11 months ago
When I click on the link I get an error report. is there another way to transfer files?
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Please try this.

Ask Your Own Software Question
Customer reply replied 11 months ago
I am trying to "close out" some line items to see if when I refresh and the lines disappear the notes follow the ones remaining in proper sequence but I am having issues. I will work with someone in my office tomorrow to confirm all is OK. If it works I will pay you double. Its well worth it to me.
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

That's great !! I would be waiting for your reply.

Ask Your Own Software Question
Customer reply replied 11 months ago
I manually took out a few rows then refreshed and it appears the comments do not follow the row it belongs to as it repopulates (they just stay where they are), but I will check it with the system removing the lines rather than me moving them in the AM.
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Sure .

Ask Your Own Software Question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Is this is working fine ?

Ask Your Own Software Question
Customer reply replied 11 months ago
Good Morning Bhavik. I didnt get a chance to work on it on Friday but will make sure to check it on Monday.
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Okay !!

Ask Your Own Software Question
Customer reply replied 11 months ago
Hi Bhavik
When I refresh, the note does not follow with the updated version. Try entering something in Column K where your note is or edit your note around line item 872. Then refresh. Your note stays at line item 872 but the work order moves up to line item 808
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Okay, I will look into it.

Ask Your Own Software Question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

I have added a macro code in it . Please try downloading it from below website :-

https://www.dropbox.com/s/dkm0qngonuku0n9/shop%2Bload%2Binquiry%20-Bhavik.xlsm?dl=0

Ask Your Own Software Question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

No, I think it is still not working. Please discard above message.

Ask Your Own Software Question
Software technician: Bhavik Joshi, Software Engineer replied 11 months ago

Hi David,

I have been trying different resolution but nothing seems to be working in this case.

I think I should opt out and allow other expert to look into it to see if they have any solution for this problem.

Please let me know if you have anything else for me and I am really sorry that I could not help you in it.

Thanks,

Bhavik Joshi

Ask Your Own Software Question
Software technician: Richard, Software Specialist replied 11 months ago
Richard
Richard, Software Specialist
Category: Software
Satisfied Customers: 39,402
Experience: Over 15 year experience in Computers, Mobile devices and Networks
Verified

Hi there

As I do not have access to the underlining query that is performing the refresh I cannot edit it for you but if you look at the connection (Via Data / Connections) and click on connection you see the location only extends to J, this is why you have the issue. Recreate the connection (as it needs to point to your Query) make sure the location includes K and then K will remain

Let me know please how you go

Ask Your Own Software Question
Customer reply replied 11 months ago
Hi Richard
The data that is being pulled from A column to J column is from a CRM 3rd party software. Once I get the report, I manually add notes that relate to the work orders on different rows in Column K. What i was hoping to do was create a macro that is smart enough to know what work order (column B) and Op Code (column H) the note (K) belongs to and follow it after it is refreshed. If for whatever reason the work order no longer exists then the note in column K would be gone as well.
Ask Richard Your Own Question
Richard
Richard
Richard, Software Specialist
Category: Software
Satisfied Customers: 39,402
39,402 Satisfied Customers
Experience: Over 15 year experience in Computers, Mobile devices and Networks

Richard is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

658 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

500 satisfied customers

Certified Software expert with over 10 years experience.

IT Miro

IT Miro

Computer Scientist

497 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Jins M. N.

Jins M. N.

Computer Hardware Engineer

460 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Kamil Anwar

Software Specialist

447 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

160 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I am running Win10 1607 and have recently had an IT guru
I am running Win10 1607 and have recently had an IT guru working on my PC. She used Administrator:X:\windows\system32\ and now the PC will not run Win10. I am currently in CMD at X:\Sources> How do… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I have CS4. resently it has slowed to a crawl even blanked
I have CS4. resently it has slowed to a crawl even blanked the screen. … read more
Kris R
Kris R
IT Manager
Computing
2,257 satisfied customers
I have a laptop and desktop. On the laptop the latest 2018
I have a laptop and desktop. On the laptop the latest 2018 versions of Photoshop and LR have been installed. On the desktop I cannot seem to update to the latest versions of cc. I pay the monthly fee … read more
Kris R
Kris R
IT Manager
Computing
2,257 satisfied customers
I found out that you drew A$ 35. from my account on Nov 13,
I found out that you drew A$ 35.69 from my account on Nov 13, without myself ever given you this permission. So far I have not received any activation code or order number … read more
Josh
Josh
It Support Specialist
Associate Degree
5,125 satisfied customers
Yesterday, when I tried to scan something and attach it to
yesterday, when I tried to scan something and attach it to an e-mail, it wouldn't allow it anymore. the window said something of re-setting settings on outlook.. … read more
Sudipto
Sudipto
Computer Hardware Engineer
High School or GED
3,937 satisfied customers
Does Kaspersky have doenwload to clear up a freezing curser.
does Kaspersky have doenwload to clear up a freezing curser. Norton had one pop when I asked … read more
Kamil Anwar
Kamil Anwar
Software Specialist
Bachelor's Degree
447 satisfied customers
I have just purchased the ability to convert a PDF to a word
Good Morning I have just purchased the ability to convert a PDF to a word document. What is the best way to do this. Are there any documents that can not convert? … read more
Josh
Josh
It Support Specialist
Associate Degree
5,125 satisfied customers
I am not receiving any aol mail on my phone and have not for
I am not receiving any aol mail on my phone and have not for weeks. What is the problem? getting on computer … read more
Suhasini Velu
Suhasini Velu
Bachelor of Engineering
37 satisfied customers
Desktop icon missing when I try to do an email attachment
Desktop icon missing when I try to do an email attachment MacBook Pro in Finder Mac OS Sierra… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I purchased winzip 22 a couple of days ago and am trying to
I purchased winzip 22 a couple of days ago and am trying to download it. It keeps offering me a free trial. I have a registration number and Ref number but it is requesting a password ***** I don't ha… read more
Kris R
Kris R
IT Manager
Computing
2,257 satisfied customers
I need to reset computer password, lenovo laptop- up6024ra
i need to reset computer password JA: Just to clarify, what's the make and model of your machine, and what operating system are you running? Customer: lenovo laptop- up6024ra windows 10 JA: Have you i… read more
Bryan
Bryan
IT Consultant
8,745 satisfied customers
I am getting hit with an update system that won't go away.
I am getting hit with an update system that won't go away. "They" , you're contractor screwed with my computer about six months ago and basically extorted me into a $200. "fix it" process and then ass… read more
Chris L.
Chris L.
Support Specialist
Vocational, Technical or Trade Scho
500 satisfied customers
Can I ask about Adobe Lightroom here? IMac. Not sure. I just
Can I ask about Adobe Lightroom here? JA: What kind of computer do you have? Customer: iMac JA: Have you installed any updates recently? Customer: not sure JA: Anything else you want the Software Expe… read more
Ricky Kresslein
Ricky Kresslein
Bachelor\u0027s Degree
450 satisfied customers
When i up graded from ftm 2014 to 2017 some new people
when i up graded from ftm 2014 to 2017 some new people appeared in my tree. … read more
Kris R
Kris R
IT Manager
Computing
2,257 satisfied customers
At one time I had the ability to ad dimensions on my adobe
at one time I had the ability to ad dimensions on my adobe illustrator documents. Architectural symbols, etc. What happened to them? HELP! … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I am trying to recreate Cabinet Cards to give to family
I am trying to recreate Cabinet Cards to give to family members for birthdays, etc. What Adobe software do I use to create/decorate photos for this purpose? … read more
Kris R
Kris R
IT Manager
Computing
2,257 satisfied customers
I can't install my elements that i recently purchased. My
I can't install my elements that i recently purchased. My old version no longer works. I don't know my password. Nothing on your support has helped and I've been waiting on the phone for 40 minutes an… read more
Bryan
Bryan
IT Consultant
8,745 satisfied customers
I have downloaded all the programs and each time i try to
I have downloaded all the programs and each time i try to sign on it says Goodby … read more
Aparna Indresh
Aparna Indresh
Engineer
Electronics & communication engineering
14 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x