linked cells

Hi, I have a number of files in Google Drive which many other people have access to for a number of reasons. One is a summary file which is the driver for formulas/value in 15 of the other files. However I have found when I change the driver cells nothing changes in the 15 linked docs until I...

I am trying to create a shopping list with several columns, a column for product name, a column with checkboxes to indicate if item is to be fresh and another if item is frozen, etc. I used the sub routine below to create the checkboxes in the "fresh" column which seems to works as designed...

I am having the hardest time searching google with the correct keywords for my issue. Or maybe it simple cannot be done, but here goes: In worksheet X I keep records of all my sent out invoices. In column A it simply says TRUE or FALSE. TRUE means the invoice was paid. FALSE means it is unpaid...

Hi, I'm trying to set up a spreadsheet of contacts' information with name, country, e-mail address columns and then have the data linked and sorted alphanumerically, by different parameters, on separate work sheet pages. ie Sheet 1 would display the contacts alphabetically by name; Sheet 2...

Hi, Hopefully this is a quick one. I have a pop up UserForm1 which contains 2 text boxes which are linked to B33 and D33 each of Sheet1. So the UserForm1 appears and the contents of these cells are displayed. B33 and D33 are formulas and the text boxes show the results of those formulas, which...

Hi! I'm relatively new to Excel and VBA and I could really need some help with the following problem. I'm truly sorry if I'm posting a question already asked, after hours of googling I haven't found an answer that would suit my situation (although I think this will be relatively easy for someone...

I would like to create a template for inputting 20 pieces of data on a weekly basis. The data will ultimately be presented on a seperate sheet with week 1 to 52 as column titles and the 20 parameter titles down the first column. For the input sheet I would like to have 20 blocks and a dropdown...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Good afternoon, I am trying to simplify usage of a fairly complex spread sheet by helping users understand the various roles of different cells, inputs, linked, formulas, etc...

2 columns from Sheet B are linked from Sheet1. When I sort Sheet1, by Linker#, it changes the display on Sheet 2. The Unlinked column isn’t tied to anything, so gets out of order with the other items on Sheet 2. Do you know how I can keep the rows in Sheet2 intact? Maybe using another...

Hi All, I seem to remember a way to jump to a linked (not hyperlinked cell) but am having trouble. Hope you can help. Here's the application. 12 months of sales data in worksheets - Jan11-Dec11 and a Summary worksheet that is linked to cells (MonthlySales) in each sheet - ie =Jan11!c5...

I have a dropdown list in a cell on, say, sheet1. Then for example, on sheet2 I need the same drop down list, BUT if a value is selected in the dropdown list on sheet1, when I switch to sheet2, I want the value selected to populate the same cell that has the dropdown. Conversely, if a value is...

Hi all, I found the following code that inserts a single column, user entered range of checkboxes. (It works very well and saves much time for those interested) Sub insertCheckboxes_OnCentre() 'Found via Chandoo.org at...

Basically, I have a workbook with several sheets. Sheet 1 is a "master" sheet named UPDATE DRAWING INFO and it contains a ton of numeric and text values. The other sheets reference cells from this "master" sheet. This way, a change on the master sheet is reflected in all the other sheets. When...

I have a workbook with different spreadsheets. The Base Sheet has all the information and other spreadsheets within the workbook are linked to the Base Sheet. I need to have a VBA code that allows me to add a new row by running a macro. And also when I add data to the newly added row, it...

Hi I have a sheet with only cells linking to cells on another sheet. ex (sheet1) a1 = sheet2!a1 The goal is to export those cells to another program The data on sheet2 change every x time (when I import data from another program (2)) When I import new data to sheet2 the data in sheet1...

I apologize if this has already been posted. I am trying to dynamically link two cells, and I don't think equations will do. Essentially, I am trying to acheive the following When I enter a value in Sheet1!A1, I want it to reflect in Sheet2!A1 When I enter a value in Sheet2!A1, I want it to...

I'm using the following code in a worksheet change event but it wont return the Target Offset value. However if I delete the linked value and type in Sun or any other day it finds it. If Not Intersect(Target, Range("D8:D38")) Is Nothing Then If Target.Value = Range("P40").Value Then If...

I remember seeing a workaround for being unable to conditionally format a referenced/calculated cell. eg. A1 contains "Saturday" A2 =A1 CF wont work on A2 as it reads as =A1while displaying " Saturday". Delete A2's link to A1, type in "Saturday" and the CF works fine. Any & all help...

I have several worksheets in .xlsx format that link to other workbooks. Does anyone know why only certain pieces of data link and the others show 0 until I open the source book? I can click on "Edit Links" and update the data, but the cell stays as "0" until I open the source book and everything...