Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

i posted this question 15 minutes ago...no expert assigned…

Customer Question
i posted this question 15...
i posted this question 15 minutes ago...no expert assigned as far as i can tell...this was before i saw your feedback about adding for John D...this continues the process with same excel 2003 sheet with 5 pages. Now that I applied filter and made some edits to one page/ how do i save and create a new one page spreadsheet that contains these filtered/edited results only...AND....keep the edited filtered results in the main underlying spreadsheet... Then....After sending the filtered one page spreadsheet to someone who will make further edits, I will need to merge the one page results back into the main spreadsheet
Submitted: 8 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 12 hours by:
6/25/2010
Programmer: Bill Sprouse, Computer Software Engineer replied 8 years ago
Bill Sprouse
Bill Sprouse, Computer Software Engineer
Category: Programming
Satisfied Customers: 60
Experience: 28 years experience in software and hardware design. Expert with VB, C++, Excel and database design.
Verified

You right click on the tab for the particular sheet you want to copy. Select Move or Copy from the pop-up menu that appears. You will get a pop-up box that has a To book: field and a Before sheet: selection list. Click on the arrow to the right of the To book: field and select (new book) and this will copy just the selected sheet to a new workbook.

 

To merge results back, you do the same on the one sheet workbook that has been edited. First open the 5 sheet workbook, then open the new edited one sheet workbook, you need both open. Right click on the one sheet tab and select Move or Copy. Select the other workbook in the To book: field and select where you want the sheet inserted from the Before sheet: list. After the edited sheet is moved into the 5 sheet workbook, you can now delete the original filtered sheet and rename the one just moved if needed. Or you may also delete the original filtered sheet before copying the edited version. In either case, please make a copy of your 5 sheet original just in case something goes wrong. This type of edit should never be done without a backup.

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Bill Sprouse Your Own Question
Bill Sprouse
Bill Sprouse
Bill Sprouse, Computer Software Engineer
Category: Programming
Satisfied Customers: 60
60 Satisfied Customers
Experience: 28 years experience in software and hardware design. Expert with VB, C++, Excel and database design.

Bill Sprouse 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:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I'm trying to make a simple spreadsheet on excel that allows
i'm trying to make a simple spreadsheet on excel that allows me to do an IF THEN type of formula where if the cells in B14 to D14 = cells in a different tab, AND if E14 in that different tab is NOT blank, THEN F14 in the first tab will equal E14 minus 1. and i dont know how to do that. can you help? … read more
George Sibiya
George Sibiya
PhD
313 satisfied customers
Customer Question I am a teacher. I have 3 worksheets in a
Customer Question I am a teacher. I have 3 worksheets in a workbook, in Sheet1 on row13 I have the following headings: colA=Unique Identifier, colB=forename, colC=surname, colD=gender, colE=FSM, colF=… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
I am looking to have John D write another report type macro
I am looking to have John D write another report type macro for me using data in an excel spreadsheet file.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Looking to see if an Excel macro can be made to transpose the
Looking to see if an Excel macro can be made to transpose the contents of column A and B based upon criteria set for column A. For example if column A contains MISC then transpose the data in columns … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
At CSATF prision, I have a bloated Excel spreadsheet. I was
At CSATF prision, I have a bloated Excel spreadsheet. I was working with John D Tuesday evening. The program is ready at sendspace with the link .../file/nu826s. Can John take over? Is this a stumper,… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have an EXCEL 2007 spreadsheet I am using as a gradebook.
I have an EXCEL 2007 spreadsheet I am using as a gradebook. There is a set of merged cells that I use to hold comments sent to the student. Sometimes I copy a merged cell from an older version of the … read more
Ruben G.
Ruben G.
Vocational, Technical or Trade Scho
69 satisfied customers
Hi John, hopefully this will be the last request to you. The
Hi John, hopefully this will be the last request to you. The spreadsheet you completed for me is excellent. All line managers are really pleased with it. However I carnt set the Auto-Filter, it disapp… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
in an excel 2003 sheet with 5 pages. i applied filter and
in an excel 2003 sheet with 5 pages. i applied filter and made some edits to one page/ how do i save and create a new one page spreadsheet that contains these filtered/edited results only...AND....kee… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
after making updates to the filtered .xls (2003, but I also
after making updates to the filtered .xls (2003, but I also have 2007) spreadsheet, how do insure that the main spreadsheet is save with the changes (rather than replaced by the filtered results) obvi… read more
Ansh P.
Ansh P.
System Analyst
Bachelor\u0027s Degree
6,393 satisfied customers
Im trying to design a survey for our graduates using Excel.
I'm trying to design a survey for our graduates using Excel. The end state or ideal outcome is as follows: --I design then send an Excel Survey with appropriate likert Scales etc as an email attachmen… read more
John Holland
John Holland
Bachelor\u0027s Degree
20 satisfied customers
I maintain a database of members of an association on Excel
I maintain a database of members of an association on 'Excel X for Mac'. When a person dies or leaves I transfer the record to another spreadsheet and delete the original record. However, I have now d… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hello, I am compiling student interviews for my daughters
Hello, I am compiling student interviews for my daughter's 5th grade yearbook. Each student has received various interview question sheets throughout the year. (ex. What is your favorite...) I would l… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
MS EXCEL installed in my new Pavilion p6257-b Can I create
MS EXCEL installed in my new Pavilion p6257-b: Can I create equations across two spread sheets? I am a long time Lotus 123 user(over thirty Years).… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
To change an Excel charts layout means to do which of the
To change an Excel chart's layout means to do which of the following? A) Modify the plot area B) Remove gridlines C) Add a data series D) All of the above 6. To enter the months January through Decemb… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I use Excel 2003 and currently have this formula SUM(IF($A$16 $
I use Excel 2003 and currently have this formula: =SUM(IF($A$16:$A$9999="BH",IF(AH16:AH9999>=500,1,0),0)) But I want to use this inconjuction with the SUBTOTAL function. Can you help me on this for… read more
John The Geek
John The Geek
Senior Software Developer
Bachelor\u0027s Degree
65 satisfied customers
I need help with Excel...I am looking to merge data in a spreadsheet...Heres
I need help with Excel...I am looking to merge data in a spreadsheet...Here's where things stand. I need to prepare a list of all of our customers, along with the number of employees at each customer.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Desperate need of help taking information from 2 separate ex
Desperate need of help taking information from 2 separate excel spreadsheets and combining them (one sheet has multiple WS with info) and having data filtered and sorted within needed areas. I've been… read more
Steven Caliendo
Steven Caliendo
Vocational, Technical or Trade Scho
99 satisfied customers
I have Excel 2007 - I am trying to write a Report, have done
I have Excel 2007 - I am trying to write a Report, have done the basic calculations and formulas but I am now at the point where I have added all the info I just need to get my head around Macros. I h… read more
John D
John D
Bachelor Degree in Engineering
342 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