Over 1 million tech questions and answers.

Google Sheets Question

Q: Google Sheets Question

Hi All,
I am a secretary of a football club and I am looking to make a membership database using Google sheets which I can sync to Google drive and allow me to update while in the club office or while I am on my home PC.
As well as a database of members names and addresses, I would have column's for member type, DOB, email and a photo which I would like to open up in another page when I click on it


I was wondering if someone out there would have any ideas of how I could make this as I'm a bit of a novice.
Thanks in advance
Brianljnr

RELEVANCY SCORE 200
Preferred Solution: Google Sheets Question

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Google Sheets Question

Brian, you can probably find instructions at Google Docs \ Sheets Help.

Read other 1 answers
RELEVANCY SCORE 54

I'm trying to sort columns A, B and C alphabetically so that the correct # in Column A corresponds with columns A and B.
Thank You,
Gary
 

A:Google Sheets alpha

Well Column A are numbers in numerical order. The sort will not change because it's in order already.

What column are you looking to be in alphanumeric order?
 

Read other 1 answers
RELEVANCY SCORE 53.2

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that informat... Read more

Read other answers
RELEVANCY SCORE 53.2

As mentioned in the heading, is it in any way possible to reset several checkboxes all at once?
 

Read other answers
RELEVANCY SCORE 53.2

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that informat... Read more

Read other answers
RELEVANCY SCORE 52.4

I had a question about if theres a formula in excel that will allow you to take one total from one sheet and put that total on another sheet.

If that sounds confusing, let me try to clear it up. I have a total on sheet 1 that i want to use on sheet 2. How would i get that total onto sheet 2? Is it possible? Thanks in advance
 

A:Excel quick question concersing sheets, please help!

Read other 7 answers
RELEVANCY SCORE 52

Hi!

I'd like to get a few cells in a list from a Google Sheets.
I have the following data:
First list horizontally: 1 in C2, 2 in D2, 3 in E2
Second list vertically: 1 in C5, 2 in C6, 3 in C7
Here is the test sheet: https://goo.gl/UDooqL

I use the following script:

function onEdit(){
var tabla = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var aktivcella = tabla.getActiveCell();
if(aktivcella.getColumn() == 1 && aktivcella.getRow() > 1){
var vizszinteslista = tabla.getRange(2, 3, 1, tabla.getLastColumn()).getValues();
var fuggolegeslista = tabla.getRange(5, 3, tabla.getLastRow(), 1).getValues();
Logger.log(aktivcella.getValue());
Logger.log(vizszinteslista);
Logger.log(fuggolegeslista);
tabla.getRange("E8").setValue("a script lefutott");
}
}

This results in the log:

[<<timestamp>>] Igen
[<<timestamp>>]] [[1.0, 2.0, 3.0, , ]]
[<<timestamp>>] [[1.0], [2.0], [3.0], [], [], [], []]

Why the two list differs?

Thanks.
 

Read other answers
RELEVANCY SCORE 52

I am using conditional formatting with a custom formula in Google Sheets to fill color the minimum and maximum values in a column.

The minimum works just fine:

Code:
=$AG:$AG=min(AG:AG)
But if I change min to max nothing in the column gets highlighted.

Code:
=$AG:$AG=max(AG:AG)
The range is set to AG2:AG25
 

Read other answers
RELEVANCY SCORE 51.6

Hello Everyone,
I would like to thank Bomb 21 for the help I received with the Excel spreadsheet earlier. I have 2 other dilemmas that I need help with. I am not experienced at all with VB. I searched on the net for a basic answer but all I could find were answers that did way more than I needed. Here it goes. (Please see the attached zipped spreadsheet)

I have a spreadsheet with a VB script that mostly runs as I would like on the first sheet. I would like this script to:

1.) I would like the script to calculate the results it gives me in column D as follows, count the number entries that range in price from $0-$199,999, $200,000-$249,999, $250,000-$349,999, $350,000-$499,999, $500,000-$749,999, $750,000-$999,999, $1000000+ and place those into their corresponding place holders in column G (for each section, Active, Pending, WIthdrawn, Sold etc.)

2.) Perform this script on all of the sheets in the Spreadsheet.
Thank you in advance for your help with this.
 

A:Solved: Excel Question: How to run same script in multiple sheets

Read other 16 answers
RELEVANCY SCORE 50.4

I have a spread-sheet done in Microsoft Excel 2003, but I was wondering if it was possible to do something a bit clever with it.

What I have in the spread-sheet is two work-sheets (the tabs down the bottom of the screen). Now, one of these work-sheets is a list of DVD's that I want to buy, and the other is a list of DVD's that I already have.

What I want to do is to have something on the work-sheet of DVD's that I want to buy where I can check them off, or press a button, or something, when I buy them, and then it removes itself from that list and adds it to the bottom of the second work-sheet (with the DVD's that I already have).

I hope that makes sense! Any help would be appreciated.
 

A:Solved: Microsoft Excel 2003 Question (Connecting Work-Sheets)

Read other 10 answers
RELEVANCY SCORE 50.4

Hi!

I am trying to build a harvest data sheet for wildlife management implications and I cannot find out how to auto-populate data from the initial sheet to separate sheets based on the entry in one specific column.

Let me explain the data sheet in more detail; I have the initial sheet set with @16 columns containing harvest information for individual animals and broken up by individual properties. (Property "X", followed by date, age, weight, sex, etc. in columns for each specimen harvested).

Now what I would like to be able to do; I would like to enter the data under each property the first time and have three other sheets auto-populate, i.e. #1-total data set not divided by property, #2-all males, #3-all females, based on the entry in the "sex" column-'M' or 'F'.

I hope I have made the problem clear enough to understand. I know there must be a way to do this. Please help! Thanks!
 

A:Excel 2007 Question: How do I auto-populate data to inidividual sheets?

Read other 7 answers
RELEVANCY SCORE 46.8

Using Google Sheets. Why am I getting this error msg? "Cannot sort a range containing merges." I DON'T have any merged columns, or merged anything. No hidden columns, or at least they weren't hidden when I tried to do the sort.

I tried to attach the file as a XLSX, and CSV, and both formats gave me an error.

A:Error Msg "Cannot sort a range containing merges." in Google Sheets

Quote:
try selecting all cells, then click Format > Merge cells > Unmerge


https://productforums.google.com/for...cs/b1B5ZswXytE

A Guy

Read other 3 answers
RELEVANCY SCORE 46.8

So, I've been looking up the topic for quite a while and it's suddenly become critical to what I am doing. Everywhere I have looked, I see lots of ways to copy multiple sheets into one sheet. This doen't do me the least bit of good. I have two 70+ tab spreadsheets. One for actuals, one for forecast. I need to copy the actuals for the first 5 fiscal periods of the year into the Forecast file. As there are 70+ sheets, I would prefer not to do this one at a time. In know in the previous versions of Excel, I could simply highlight all the sheets, highlight the data I needed, hit copy, and paste the data in the new sheet. So long as the sheets were laid out the same, it was never a problem.

Do you have any idea how to do this now?

Thank you.
 

A:Excel 2010 copying multiple sheets into multiple sheets

Read other 7 answers
RELEVANCY SCORE 36.4

I've got a macro, that I want to modify so that it reads the one worksheet, then makes global changes to all the other worksheets. I only know how to get it to update the single sheet specified sheets(2), but don't know how to get it to do updates to all the sheets.

Code:

Sub test()
Dim lrow As Long, i As Long
With Sheets(1): .Activate: Application.ScreenUpdating = False
lrow = Cells(Rows.Count, 1).End(xlUp).Row
For i = lrow To 2 Step -1
If Cells(i, 1) <> "" Then
Sheets(2).[b:z].Replace What:=.Cells(i, 1), Replacement:=.Cells(i, 2), LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True: With Cells(i, 1): .Value = Cells(i, 2)
.Interior.ColorIndex = 35: End With: End If
Next: End With: End Sub

 

A:How to look through sheets in Excel

Hi welcome to the board:
you can loop through all the sheets

Code:

Dim ws as worksheet
For Each wS In ActiveWorkbook.Worksheets
< your code here>
next ws

You will probably have to include a check to see if its the sheet you nedd but since you can code some thing I imagine you'll be able to work with the code above?
 

Read other 1 answers
RELEVANCY SCORE 36.4

In Excel I am trying to have sheets copied from one workbook (The Template) to another (The report) with VBa. The first sheet is copied to a new workbook, this workbook is than saved temporarely as report.xls, the 2nd 3rd etc... sheet is added to this new workbook.

For adding the sheets this is the code I use:

Windows("Template.xls").Activate
Sheets("Samples_Charts").Select
Sheets("Samples_Charts").Copy Before:=Workbooks("Report.xls").Sheets(1)
'
Windows("Template.xls").Activate
Sheets("Yearly Average").Select
Sheets("Yearly Average").Copy Before:=Workbooks("Report.xls").Sheets(1)
'
Etc.. this code is simply copied 50 times. It works fine for approx. 20 sheets but it won't add anymore sheets! Is there a maximum to the number of sheets that can be added to a workbook in a row?? I have workbooks with more then 50 sheets! Am I overlooking something? why is it performing well for 20 times or so and then quit?

Goosemark.
 

A:copy sheets

Hi there, welcome to the board!

The only limit in Excel as to the number of sheets is your memory available. If you're going to copy all sheets, why not just copy the workbook as another file (SaveAs)?
 

Read other 3 answers
RELEVANCY SCORE 36.4

Is there a formula or macro I can use to add all the cells C4 in each of the several sheets? I am thinking of something like in the old Lotus 123 Release 3. A simple syntax might be "Sum(Sheet1!C4:SheetN!C4"). Does anyone know how to use Excel as a true 3D spreadsheet?
 

A:MS Excel Sheets

Read other 8 answers
RELEVANCY SCORE 36.4

Hello,
i've a problem when i open browsers (Firefox, Internet Explorer, Chrome). Randomly, after 1 or 5 or 10 minutes the browser open these pages:
http://2080.hit.buy-targeted-traffic.com/load/hit_1.php?source_id=2080&sub_id=&source_mk=1d0d9744
or
http://oziris.zerohorizon.net/
or
http://ptp24.com/promote.php?id=fb9a9b909e237b49be76aaa30d95d33a
I'm on Windows 10 Pro x64, i scanned with Roguekiller, Adwcleaner, Malwarebytes, ZHPCleaner, TDSS Killer, Hitman Pro, etc. (removing suspicious items) but nothing has changed.
Obviously i couldn't launch Combofix because it's incompatible. I also tried to reset all browsers, but the problem remained.
Can you help me to remove this annoying problem?
Thank in advance
 
Nicco

A:Pop up sheets in all browsers.

I post the results:  Results of screen317's Security Check version 1.008     x64 (UAC is enabled)   Internet Explorer 11  ``````````````Antivirus/Firewall Check:``````````````Windows Defender    WMI entry may not exist for antivirus; attempting automatic update.`````````Anti-malware/Other Utilities Check:````````` Java 8 Update 60   Adobe Flash Player     18.0.0.232   Mozilla Firefox (40.0.3) Google Chrome (44.0.2403.130) Google Chrome (44.0.2403.157)````````Process Check: objlist.exe by Laurent````````   Windows Defender MSMpEng.exe`````````````````System Health check````````````````` Total Fragmentation on Drive C:  %````````````````````End of Log``````````````````````

 Farbar Service Scanner Version: 26-07-2015Ran by NiccoloM (administrator) on 01-09-2015 at 12:00:14Running from "C:\Users\ross03\Downloads"Microsoft Windows 10 Pro  (X64)Boot Mode: Normal****************************************************************Internet Services:============Connection Status:==============Localhost is accessible.LAN connected.Google IP is accessible.Google.com is accessible.Yahoo.com is accessible.Windows Firewall:=============Firewall Disabled Policy:==================System Restore:============System Restore Policy:========================Action Center:============Windows Update:============Windows Autoupdate Disa... Read more

Read other 1 answers
RELEVANCY SCORE 36.4

hi,
i have a problem in writing macro for comparing two sheets in a workbook in such a way
if first row of first sheet match with any row of second sheet then copy that row on another sheet and then if second row of first sheet match with any row of second sheet then copy it to third sheet
this process must continue till all the row compared one by one of first sheet with second sheet
means i just need to compare 1st row of first sheet with all the rows of second sheet then 2nd row with all then 3hird row and so on
please help me to slove this problem i have attached the excel file that have two sheets i want to compare rows of sheet 700days with sheet Nifty BB-1 Long 250 days 60min
 

A:how to compare two sheets

Please attach the file.
 

Read other 1 answers
RELEVANCY SCORE 36.4

Hey ladies and gents,

Looking for your views on the uses of style sheets on a website, I have tried in vain to find a site that will explain to me exactly how they work and why I should use them so I thought I'd ask u guys!

Thanx for your help

Rutter
 

A:Style Sheets

Read other 9 answers
RELEVANCY SCORE 36.4

hey everybody,
is there anywhere that i can find a good tutorial on creating CSS Style Sheets. i have searched and have found plenty of VERY beginner ones which i understand pretty well but im loking for one that has some more advanced stuff like background pictures and stuff like that.

thanx
 

Read other answers
RELEVANCY SCORE 36.4

I can't write macros so your help would be appreciated.

I have an Excel Workbook with a Paid sheet and an Outstanding sheet both sheets have a File Number column.

I would like to create a macro that looks through the Outstanding sheet and if the File Number from the Outstanding sheet is also in the Paid sheet the entire row will be deleted from the Outstanding sheet.

I've tried copying some macros but I keep getting them wrong.

Please help!
Cheers,
Ang
 

A:Maro between sheets

Read other 7 answers
RELEVANCY SCORE 36

How do I copy a formula from sheet 2 to sheet 1 of the same workbook and get the same result even after changing the values on sheet 2?
 

A:Copy formulas between sheets

Not 100% sure what you're aiming to do: do you mean you want to replicate and display, in Sheet 1, the current value returned by a formula that's in a cell in Sheet 2?

If that's the case, then don't try to copy the formula as it would reference the corresponding cells in Sheet 1 rather than Sheet 2 (as you've probably discovered).

Instead, link the Sheet 1 cell to the relevant Sheet 2 cell using a simple reference formula:

1. Type an = sign in the desired cell on Sheet 1.

2. Activate Sheet 2 and click in the cell whose formula you want to refer to (this is termed the precedent cell).

3. Press Enter.

If the Sheet 2 formula is in cell D12, for example, the Sheet 1 formula will read: =Sheet2!D12

Hope that covers it.
 

Read other 3 answers
RELEVANCY SCORE 36

How can I get tables in excel to add up total hours beyond 24?
I,ve created a little table at work to total up ,"Hours actually worked", by several sub-contractors and employees.
Problem is, it wont total up beyond 24hrs per day.

IE: If two employees work 07:30 Hrs it will total 15:00Hrs no problem.
But if the total =more than 23:30 it wnt work.
 

A:Solved: Time-sheets

please delete this thread as it is duplicated.
 

Read other 1 answers
RELEVANCY SCORE 36

Yesterday I was working on 2 different Excel worksheets and had them on my desktop arranged anyway I wanted individually. Today I opened the same worksheets but instead of being individual worksheets I now have an Excel empty screen and my 2 worksheets opens inside this worksheet and can arrange them as tiled, horizontally etc..

Itís nothing wrong with the above setup and perhaps I like it better but I was just wondering why this happened. I have tried all I know to have my 2 worksheets open individually as before but without success.
The menu Windows/Arrange does not give me the option I want

How can I have 2 different worksheets opened at the same time?
 

A:Solved: Arrange Sheets

Read other 16 answers
RELEVANCY SCORE 36

Is there a VBA Macro to alphabetize multiple sheets in an Excel single Workbook or other code? I do timecards for my employees and someone helped me with a macro that is amazing from a template page. Once transfered though I send it in and it's like 25 people and they need to be alphabetized. I see some people say they can online but what I have tried has not worked and I spend a lot of time just alphabetizing sheets when I would assume a programmer would have figured out how to automate that. Essentially I feel like I'm doing too much unnecessary work. Anyone know a code, filter, or maybe simply an edit tool I never knew about in Microsoft Excel 2003 or 2007? Any help is much appreciated, thanks.
 

A:alphabetize sheets in excel?

Read other 6 answers
RELEVANCY SCORE 36

Here is my situation

I am working a workbook with 78 different sheets (tabs). The format for each tab is the same. Rows 1-4 are header information that is unique to each tab.

row 5 is my column titles (same for all tabs)

rows 6-??? (varies on each tab) is my data (unique data on each tab)

I am trying to devise a way to pull in all of this information combined where it will list the unique header information for each tab along with the information from rows 6 on. Once in a sheet, I would like to set this up in a pivot table because some of the data from rows 6 on may be the same on different tabs, so I would like to see that combined, but also be able to expand to see which tab each piece of info came from.

I know this is complicated, but I have been reading through the forums and if this can be solved it will be by the knowledgeable people in this forum.
 

Read other answers
RELEVANCY SCORE 36

it may sound dumb, but i use excel on my pocket pc often. one of the things i really find lacking is the letter tabs found on most contact software. i'm not sure what they're called, but they are at the top of a long list of contacts, usually the first row, and they contain the alphabet, grouped abc in the first tab, and def in the next, etc. i want to port this feature into excel. i have excel sheets with more than 50 names in column A, and i need to scroll all the way down to access the names beginning with the higher letters of the alphabet. in order to save time, i'd much prefer the little letter tabs (i wish i knew the correct name), so i could just click the appropriate tab to quickly bring me to the names beginning with that letter. for example, if i wanted to bring up Mrs. Tanner, i could just click the 'T' tab, and i would be brought to all the names beginning with T.
 

A:can i add a 'letter' tab to excel sheets?

Read other 16 answers
RELEVANCY SCORE 36

Hi,

Need a help message box, whenever my given criteria is matching the cell it should pop up message.

I have written my queries in the sheet attached so that you will be able to help me on the same.
So please have a look at the attached sample sheet
 

A:Message box for the given Criteria on all the sheets

Read other 13 answers
RELEVANCY SCORE 36

If i have 2 excel sheets
Sheet a
computer15
computer2
computer37
computer40
computer9

Sheet b
computer16
computer2
computer39
computer48
computer5
computer40

is there a way to compare sheet b with sheet a to make a sheet of all computers that occur in both documents?
such as

sheet c
computer2
computer40
it would be really cool if i could figure out a way to pull sheet c computers that are in sheet a out of sheet a.

such as
sheet d (sheet a's list - sheet c)
computer15
computer37
computer9

If anyone could figure out how to do this it would be extrmley helpful.
 

A:Pulling data from sheets

Read other 16 answers
RELEVANCY SCORE 36

My boss wants me to create a time sheet collector in Access. The templates that Microsoft offer are concerned about charging to a specific department rather than collecting time-in/time out and such. (I would want to ask for the time and collect the actual time it was reported, as I know I'll get asked about it at some point.)

Has anyone already created something like this?

I ran the numbers, and with 250 employees clocking in and out twice a day (before and then after lunch) for a year would be 130,000 records. I don't know at what point it would be better to go to a bigger platform.

I figure it will need a log in, probably something like Scott Gem?s https://scottgem.wordpress.com/2010/01/12/creating-login-security-using-access-vba/
This would help keep people somewhat honest. Right now we fill out a an excel spreadsheet and then print it out, sign it, then hand it to our supervisors.

The user table would need to include a specific department that the user is assigned to.

A Supervisor table that would assign a manager to approve the timesheets for each department. (Only their department)

A time table, recording the in and out times.

It would also need to track time-off for paid vacations and such. (Following rules such as vacation time must be used in 4 hour increments, sick leave must be used in 30 minute increments, etc.)

Due to job locations in remote areas, it would also need an admin assist position that could enter multiple people?s information.... Read more

A:Time sheets in Access

Read other 9 answers
RELEVANCY SCORE 36

Hi,

I think what I need to do is a vlookup but I'm not sure how to go about it. I have an edited set of data in one worksheet and a more detailed version of the same data in a second worksheet. I need to add a column into the first sheet and populate it with information from the second sheet which corresponds to the reference number. I have mocked up a sample sheet to demonstrate.

Daniel
 

A:Searching data between sheets

=VLOOKUP($A2,Sheet2!$A$2:$D$10,4,FALSE)

would be the formula in Sheet1 column D, which you can then drag down

$A2 is the reference you are looking up in the second sheet

Sheet2!$A$2:$D$10 is the range containing the data - you can extend this range, but you would always need to match the $A2 reference in the first column of the range. Clearly if your sheet 2 is going to contain more than 10 rows of data you would need to alter $D$10 to a different row number.

4 is the column you are returning data from

FALSE - the data is not in an ordered list

Hope this gets you started. Once you get the hang of vlookup, you'll find it an invaluable tool.
 

Read other 1 answers
RELEVANCY SCORE 36

I can't link to a cell in another sheet in the same workbook (as in '=target'). I can link to another cell in the same sheet, but not to another sheet. This function works okay on my work computer, but not on my laptop. Seems like it's a setting in excel. Has anyone experienced this problem before?
 

A:Excel won't link between sheets

No havent experiened that. I have a laptop and don't get that problem.

On your laptop,can you actually type the = in a cell, and then click on the tab of a different worksheet within the same workbook and then click on a cell and press enter?

If not, then can you upload the workbook using your laptop, obviously removing any sensitive data, so that we can have a look and see if we can see what the problem is.
 

Read other 1 answers
RELEVANCY SCORE 36

My dad has a canon pixma MP540

he wants to know how to print images over a few sheets of A4 so they can make on whole larger picture to hang up

half on one sheet and half on the other

what software would he have to use?

thanks

 

A:how do you print large pic over many sheets?

Any of the good Image Viewers n Editors should be able to do this ... The freeware Irfanview can do this.

You could crop the original to get the four corners .. or the Top n Bottom .. (for example)
Then tell Irfanview how big to Print the parts.

Using a little math .. You could use the Irfanview Batch Processor to precisely Crop the big picture, in terms of the pixel size ...
To make the separate picture parts ... And maybe upsize the parts.
 

Read other 3 answers
RELEVANCY SCORE 36

Hope I am in the right topic....

I am looking for spread sheet software to download...free of course.
My Microsoft Excel program is acting up and the disc to download is no longer available to me.
I don't want a huge program such as Open Office...just basic spread sheets....don't need Word Perfect and all that jazz
Google documents provides a good basic one but I want this to be on my hard drive and not on the WWW.

Thanks for any info.

Tildy
 

A:Basic Spread Sheets

Read other 7 answers
RELEVANCY SCORE 36

This is more of an interestign question than a problem, so I apologise if I've posted in the wrong place.

Anyway, CSS. Cascading Style Sheets, right? I understand why the "Style Sheet" part came about, but why on earth did they put the "cascading" part? What is "cascading" in these sheets?
 

A:CASCADING Style sheets?

Read other 16 answers
RELEVANCY SCORE 36

i want a vba code for combining sheets
with condition
sheet1 :
column a = 101 , 102 , 105, 108 , 115
column b = 5, 2 , 3 , 4 , 5
sheet2 :
column a = 101 , 102 , 103 , 104 , 105 , 106 , 107 , 108 , 109 ..........
column b = 10 , 20 , 30 , 40 , 20 , 35 , 30 , 15 , 0 .........
ans could be :
column b = (10+5)15 , (20+2)22 , 30 , 40 , (20+3)23 , 35 , 30 , 15 , (0+5)5 .........
 

A:combine two sheets with condition

Read other 6 answers
RELEVANCY SCORE 36

I have multiple (80 or so) sheets were I what to hide certain columns say I:N on all sheets not just the active sheet with out a very length code! Can any1 help.

Sub hidealltest()
Dim ws As Worksheet
For Each ws In Sheets
Columns("I:N").Select
Selection.EntireColumn.Hidden = True
Next
End Sub

It only works on active sheet but highlights all columns to be hidden in sheet 2 and 3 but fails to hide them..
 

A:hide certain columns in all sheets

I posted in wrong place by mistake then it got moved after I made a new 1 sorry
 

Read other 2 answers
RELEVANCY SCORE 36

cannot delete extra sheets in excel document..i have 2 pages of data, and page break shows 2 pages, i go to print preview and there are 4 pages; and page 2 and page 4 are blank....help!!
 

A:excess sheets in excel

in print preview you should see some dotted lines - I would goto the column on the right with the last data entry and then select the next few columns and delete those columns - see if that resolves the issue

what version of excel

also look at the print area used ?
and set that area to the pages you want printed
 

Read other 3 answers
RELEVANCY SCORE 36

I have a workbook with several pages. I want to keep them in alphabetical order by the client name. I add names every day.

I use the Name field from the first sheet for all consecutive sheets.

As I add names and sort the first sheet, it will sort the name field for all consecutive sheets.

How do I sync all of the sheets so when I sort the first, it will sort the entire row from the first?

I had a program through my company for tracking customer calls - date, time, conversations, etc. It also allowed for scheduling future calls, etc.

The program had to be pulled and we are all on our own. I would like to use Access but I am a novice and don't have time to figure it all out.

Do you know of any free programs that tracks customers?

I would appreciate any help you can give.

Thanks,
Linda
 

A:Sync sheets of a workbook

Read other 11 answers
RELEVANCY SCORE 36

Does anyone know if in Excel 2010 can it automatically populate specific information into different sheets? ie. every time that Monday is selected from a drop down box apply it to the sheet named Monday, if Tuesday apply it to sheet named Tuesday, etc. Any and all help is appreciated. Thank you!!
 

A:Automatically populate into different sheets

ccmwader,

Welcome to the forum.
You can use a worksheet change event for what you want.
Attach a copy of the workbook and we'll do what we can to help you.
Be sure you supply the info as to what want copied the the respective worksheets.
 

Read other 1 answers
RELEVANCY SCORE 36

The cover sheetsb arte missing when I try to compose a fax. Looking in folder C:/......documents/fax/personal coverpages, I find it empty. Where can I download the appropriate cover pages?

A:Fax cover sheets missing

Are you using these for a Word program?

If so, see here: Create or edit a fax cover page in Word

Read other 6 answers
RELEVANCY SCORE 36

Is this possible? I have lists that span several tabs in the same workbook, and want to summarize them on one sheet using VLOOKUP.

Any help appreciated!
 

A:Solved: VLOOKUP across several sheets

Read other 8 answers
RELEVANCY SCORE 36

I work from an excel spread sheet daily. This spread sheet has about 4,000 lines. When I delete lines in this spread sheet I get a gray box with the sum symbol in it. No matter what I do, I can't get this to NOT "automaticly appear". If I print the document, it prints. If I move the symbol, it copies and keeps a copy where it began. If I copy a cell it copies with the cell. I tried deleting the symbol and yes it deletes however there are hundreds underneath it which means I am deleting hundreds. How can I delete all of these at one time, or better yet stop this? It really is annoying.
 

A:Excel Spread Sheets

Hi,

Not sure what you have for those boxes, but if they are a shape or OLE control - which a shape is - you may make use of this macro to rid all shapes/OLE objects from your sheet...
Code:
Sub delAllShapes()
For Each Shape In ActiveSheet.Shapes
Shape.Delete
Next
End Sub

or

Sub delAllObjects()
For Each s In ActiveSheet.OLEObjects
s.Delete
Next
End Sub
There's 2 and they should both work just fine. To run, copy code. From Excel press Alt + F11, select workbook in left frame (if not there Press Ctrl + R {xl 2002} or Project Explorer from the View menu), go to Insert -> Module, paste code in right window. Call by (first closing that window, the Visual Basic Editor {VBA}), then press Alt + F8, choose the macro name to run and press 'Run'. HTH
 

Read other 1 answers
RELEVANCY SCORE 36

Hi,

I have data in two different sheets named as 'Sheet1' and 'Sheet2' in the exact format a mentioned below. Inthe attached File I have mentioned only 10 rows. As such data is available in 1500+ rows.

I am looking for macro which will perform the gap analysis between these two sheets and generate the results in new sheet named Sheet3.

Please find the attached file for data reference.

NOTE - Stage value Consist of roman numbers e.g I, II, III etc....

Thanks ,
Akki
 

Read other answers
RELEVANCY SCORE 36

Hi ,

I have data in below mentioned format in two different sheets. there are other columns as well; however, I am interested in only below mentioned values.

Sheet-1

ID Stages Systems
9 Stage-1 System-1
9 Stage-2 System-1
9 Stage-3 System-2
10 Stage-1 System-1
10 Stage-5 System-2
10 Stage-6 System-3
11 Stage-2 System-2
11 Stage-8 System-3
12 Stage-3 System-1
12 Stage-9 System-3
13 Stage-9 System-1
13 Stage-10 System-2
14 Stage-1
15 Stage-2

Sheet-2

ID Stages Systems
9 Stage-1 System-1
9 Stage-2 System-3
9 Stage-3 System-4
10 Stage-1 System-1
10 Stage-5 System-2
10 Stage-6 System-3
11 Stage-2 System-2
11 Stage-3 System-3
12 Stage-3 System-1
12 Stage-9 System-3
13 Stage-9 System-1
13 Stage-10 System-2
14 Stage-1 System-1
15 Stage-2 System-4

1- Create new sheet, showing comparison results and copy the three columns from Sheet-1
2- Check if the ID of Sheet-1 is available in Sheet-2
3- If ID is available then Compare the availability of 'ID' and 'Stage' values pair of Sheet-1 in Sheet-2 . for example "9-Stage-1" and if it is available in sheet-2 give the value as "Available in both sheets" in the same row in new Status column
4- If the 'ID' and 'Stage' values pair of Sheet-1 is not available in Sheet-2 then give the value as "Removed from Sheet-2"
5- Similarly I want the results for 'ID' and 'System' pair as well.

Thanks in advance,
Akki
 

A:Need Help on Macro to compare two sheets

Read other 7 answers
RELEVANCY SCORE 36

Hi,

I have a template that I use every day for every month of the year. Each month I copy the workbook and rename it with the appropriate month and then go in and change every single tab (worksheet) name to correspond to the individual days of the month. For example, for April, I took March's workbook and saved it as April and went in and changed all the sheets to correspond with the days of April.

Is there a way or some type of macro someone could help me with that would copy the appropriate number of worksheets and name them according to the appropriate days for that month??? I was thinking of using an Input Box to determine the month to generate for.

Thanks for reading!
 

A:excel workbooks and sheets

Read other 6 answers