Inter Link Sheets In Same Book?
Jan 27, 2014
spread sheet training matrix. The subjects to be trained on are plentiful so I have broken these down into different sheets. I produced this to my boss and the first thing he asked was "can we link the sheets so I can get information about one single employee" in other words I have a list of employees in the first column and this list is the same on each sheet, the headings on the sheets are different but instead of having a set of columns about forty headings wide I have split them down to ten headings on four sheets. The big question! Is it possible to print one sheet with one employee but all of the headings? When I say headings I mean the columns under the headings as well.
View 4 Replies
ADVERTISEMENT
Jul 18, 2014
I made the following code to merge 2 workbooks together.
The code is to be executed when the user has Workbook A opened. (All sheets in workbook KPISWD are supposed to be moved after all worksheets in workbook KPICustomers).
I keep getting a debug error on the code that is supposed to do the actual move and loop until it is finished with all of the sheets in Workbook B.
Code:
Dim KPICustomers, KPISWD As String
KPICustomers = ActiveWorkbook.Name
Workbooks.Open Filename:= _
"W:FacturatieKPI per periode SWD.xls"
KPISWD = ActiveWorkbook.Name
[Code] ..........
View 3 Replies
View Related
Aug 3, 2009
I know how to create a text link to other cells within a work book but how can I create a button which will do the same?
View 2 Replies
View Related
Mar 19, 2005
got work book that has about 20 sheets in it.....there are links throught the workbook. ......one sheet in particular when i go to it, it freezes up...and i get the dreaded "Send Error Report to Microsoft" window"...and we all know what happens next.....excel shuts right down.
I can open the workbook and click on ANY sheet....but when i click on this one particular sheet in the book i get the error message
This work book is a template....its the estimating work book i use at work...and whenever i get a new job to estimate i open up this template.....put in my data and save the workbook as the job title.....so basically i have about 50 of these workbooks......and it doenst matter which one i open.......whenever i go to this one same sheet in any workbook i get the freeze
and the freaky thing about this is it does it randomly....I make save this template (as a new work book) when i get a new job to estimate.....and i never have any problems.......but today for some crazy reason its doing what i mentioned above......it did this about a month ago too.......same exact problem.
when it happened the first time i tried all kinds of stuff, and the only thing that worked was i had to go to windows explore...save all the files to a memory chip.......go to a different pc with my version of windows (XP)....open each file up......re-save it.......go back to my pc...reload it
View 9 Replies
View Related
Feb 1, 2007
i want to do a macro, that will copy and transfer Selected worksheets to a new Workbook? so guessing, you select the sheets, then click the button and it copies then opens new blank workbook and puts them in?
View 9 Replies
View Related
Oct 6, 2009
I'm having an issue with a macro that copies sheets from one workbook into a new workbook. The issue is it doesn't copy all the sheets. It only copies the first 10 and doesn't capture the the remaining 15. I've checked the range of the translation table and the issue doesn't appear to be there.
Sub SBGFiles()
Application.Calculation = xlCalculationManual
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim a As Worksheet
Set a = Sheets("Input")
Dim Fpath As String
Fpath = ThisWorkbook.Path & ""
Dim SBG As Range
Dim RU As Range
Run ("UnPro")
For Each SBG In a.Range("B44:D44")
Workbooks.Add
newbook = Workbooks.Count
Workbooks.Item(newbook - 1).Activate
On Error Resume Next
View 9 Replies
View Related
Jun 9, 2007
I want to create a form and use VBA to make a combo box list all the sheets in a book. Is it possible to select multiple entries like in HTML? I would like the user to be able to select the sheets they do not want to delete before a macro runs.
View 2 Replies
View Related
Nov 16, 2009
I'm trying to copy rows from one workbook that is exported from access to multiple worksheets in multiple workbooks. I used a macro I found here from JBeaucaire that will copy the data for me but it over writes the information I have in rows 1-3 and also the rows below, 28-35.
Is there a way to copy the data without loosing the information in the first three rows and the rows below where the data goes?
View 6 Replies
View Related
Jun 5, 2007
I have a workbook that I would like the same operation on all sheets except the first sheet in the book every time I update it (which is once a week).
I get data (currency format) for all of my employees on a weekly basis. Unfortunately this data is shown as a negative number and I need to invert these values. (So I use the formula below)... but I have to do this manually for about 35 sheets and I figure I could automate this somehow with a macro. Here's what I do usually and what I would like the macro to do automatically:
I want to insert a column after column G.
I would like to enter the following formula into H2:
=IF(G4="u", "u", IF(G4
View 9 Replies
View Related
Aug 26, 2012
I'm trying to write a macro that selects cell A1 in each sheet within the book. I've written the following code:
Code:
Sub a1()
For i = 1 To Sheets.Count
Sheets(i).Cells(1, 1).Select
Next i
Sheets(1).Select
End Sub
However, it produce this message: "Run-time error '1004': Select method of Range class failed."
If I slightly modify the code to
Code:
Sub a1()
For i = 1 To Sheets.Count
Sheets(i).Select
Cells(1, 1).Select
Next i
Sheets(1).Select
End Sub
It works fine. I'm curious why this happens.
View 6 Replies
View Related
Oct 4, 2009
I have worked out (through reading and what not) how to link a combo box to a range in a worksheet. What I need to do is relate what is selected in that combo box, to another combo box which picks from another range. I have a data spreadsheet called "Offices". It's set up as follows
(Sorry, it's really frustrating trying to format it to a table type thing but you get the gist)
ROW NUM______COLUMN A____________COLUMN B
---------------------------------------------------------------
1_____________DistrictOffice1_______...fice1@test.com
---------------------------------------------------------------
2_________________________________OFFICE 1
3_________________________________OFFICE 2
4_________________________________OFFICE 3
5_________________________________OFFICE 4
---------------------------------------------------------------
6_____________DistrictOffice2_______...fice2@test.com
---------------------------------------------------------------
7_________________________________OFFICE 2...............
View 4 Replies
View Related
Jun 22, 2007
I have the below code, which now looks to see if a file is open or not, if it is, then copy and past 'Data' and if not open the book and copy 'Data'.
I think the code is sort of right, but im missing something, as i keep getting runtime error when i try and copy. Here is the
Sub PrintSaveKPIUpdate()
Dim sFilName As String
sFilName = "C: estCashSales_KPI.xls"
Set Main = ThisWorkbook
If IsOpen(sFilName) Then
' Book is Open.
Worksheets("Setup Data"). Range("Data").Activate
View 9 Replies
View Related
Aug 29, 2007
i have done a search on this topic and found many similar answers to many similar questions. All specify using Application.Run "workbookname.xls!macroname".
In my code, the filename has an assigned value as the master code goes out to many secondary files - the user selects the particular one they want at the start of the macro. The variable assigned is called "UpdateKAMsFile".
how do i get the macro called KAMsRandomColour to run in the workbook designated by UpdateKAMsFile?
View 9 Replies
View Related
Jan 29, 2010
I have a cell that a I want to get the results of a SUM to 20 cells in 20 worksheet out of 60 worksheets. When I enter my' =sum( shows up with serial_numbers. When I go to each sheet and select the cell I want (same in all worksheets) like in sheet 2 it shows my sheet name and cell. But when I go to my sheet 3 and select that cell it replaces sheet 2 with sheet 3 it does not keep adding the sheets with the cell numbers. When I select all sheet tabs it still only changes the sheet number in stead of running a range. I could type all the sheets names and cell but lots of work and I have a lot of this type of ranges to do.
View 2 Replies
View Related
Jun 20, 2007
“Pre” is where the user type information and these information would then shared throughout all the sheets. There are a total of 5 things that I need to be done… (Those indicated with numbers are the ones that need to be done).
1st thing: How to highlight the days for all the TERM BREAKS?
2nd thing: How to link the dates for the Public holidays to “P1_B1” and highlight it red. Without using conditional formatting because there maybe more than 3 public holidays.
3rd thing: Number of groups entered here would create rows of group according to the number of groups entered in “Pre”
4th thing: The number of classes entered here would create the number of rows for each particular subject. Eg. English has 3groups so there are a total of 3 rows.
5th thing: The number entered for the number of programmes would create new sheets with respective to the number entered there.
*I have to only enter no the “Pre” sheet and it will automatically link the information across the rest of the sheets without the need to press RUN. *
View 2 Replies
View Related
May 8, 2014
I build a tool in excel to make an analysis per industry (30 industries). I want to compare the results on the first sheet, as a summary. All the information is now scattered over the sheets, but what I want to do is when you change the ticker in column A, it automatically retrieves the information from on of the sheets for the specific company. I will try to make myself clear to attach a screenshot.
So if you change ticker in column A, I want to fill columns C:D:E, G:H:I, K:L:M, O:P:Q, etc automatically according to the company name.
View 5 Replies
View Related
Mar 12, 2014
I have a macro that copies a sheet and renames it:
Copies "Q114" and renames it to "Q214".
Q114 is defined as OLD in my VBA code
Q214 is defined as NEW in my VBA code.
I also have a third sheet, call it "results", which picks up cell values, ie cell A1 in "Q114", but now I want it to use cell A1 "Q214". The values hasn't been filled in, so I need a link between them:
[Code] ......
View 2 Replies
View Related
Jan 15, 2008
I need to link two text boxes on two different sheets. Is there a excel formula or macro to do this. I am entering text in textbox 1 on sheet1 and same text needs to show in textbox2 on sheet2.
View 4 Replies
View Related
May 28, 2009
I have an excel file containing three sheets(1,2,3). And each sheet has 9 Columns (A,B,..,I). Now for the first sheet i have a functioning mask (userform) through which i can edit the columns live and add new rows.
Now i have a userform which is devided into three parts. The third and the last part is working fine which is linked to Sheet 1. Now i want the first part(on the top) of the form to be linked to Sheet 2 and the midpart to sheet 3.
In first and second part of the userform there is button (copy this to sheet 1 as new). This button should be coded in a way that if its clicked then the active entry (in sheet 2 or in Sheet 3) should be pasted at the end of the sheet 1 rows and the textboxes linked to sheet 1 should jump therer so that the new entry can be edited directrly in sheet 1.
The mask can be opened by the button in Sheet1 column A1! I am using 1280x1024 pixels for my grafikcard.
I am attaching two files. Excel file 2003 xls in zipped form and an image of the mask as jpg.
View 9 Replies
View Related
Jun 28, 2007
Is it possible to somehow link sheets in excel to different tables in Access so when I update the sheets in excel it can automatically update the tables in access?
Doesn't have to be on line but I want to avoid the continous copy paste or exporting and trying to automate this process.
View 4 Replies
View Related
Jul 16, 2014
so to start off im not able to attach things due to security reasons, what i need is either 1 of 2 macros. if its possible, both are related. one possible is as follows: i need it to go through a certain column (say I for example) and look at the information in it, this information can vary from peoples names along with dates and other stuff, i want it to look through these and if anything has a date today and prior i need the cell to be highlighted. problem is sometimes it might have 2 dates, or no dates. it should have todays date, their name, other information, and future date of something. but not everyone does, this is the macro i dont think that can exists.
2nd macro possibility the other macro uses the first sheet, AFTER been highlighted, normally by hand, and takes it to another workbook and puts in in certain spots. so the first sheet has names of everyone in column K. what i need is it to look at column I and if its highlighted take entire row to other book, and put into sheet under the person name in their tab. the second book has a tab for each person (at this time 18 tabs) which can fluxuate, and each tab is the persons first and last name, without spaces. since when i put sums on main page it didnt want to work with the spaces i had to omit them. again im not sure this is possible.
View 6 Replies
View Related
Aug 31, 2009
I would like to link students for the 1st Nine Week list to the correct grade level as shown. I have attached a file.
View 2 Replies
View Related
Dec 19, 2012
I am very new to using excel and I need connecting the information between two sheets. I have a weekly schedule that I want to use for my employees. I want that information to automatically be moved to a daily schedule. I need to be able to see how many openers closers and mid-shifts I have and how many hours I am consuming from my budget. I want the shifts from the schedule to be moved to the daily schedules in order in chronological order (morning shifts first, then mid-day/closers). If at all possible how I would like to have the span of their shift to be highlighted in the cells on the daily schedule.I will attach what I have so far to provide as much info as possible.
example.xlsx
View 1 Replies
View Related
Nov 1, 2013
I have a excel workbook with One Master Sheet.
The data entered in the master sheet is automatically updated in the sub worksheets through direct links created . Each sub worksheet is a branch of organization. almost 100 branches are there.
The data is entered for all the branches in the Master Sheet at different periods continuously which is to be kept as such.
For example In first day 10th, 15th branch data may be entered in master sheet first and second row, which is getting automatically updated in the respective branch worksheets. But the problem is when the data is entered for any branch( for example 6th branch) in 5th row of Master sheet, in the respective 6th branch sheet also, it is updated only in 5th row only, leaving the first four rows blank. But i want the updation in the branch sheet continuously without any blank rows.
For updation i have used the simple direct link between the cells of Master worksheet and Branch sheets.
How to get the updation in branch worksheets while entering the data in Master sheet without any blank rows.
View 6 Replies
View Related
Jul 24, 2007
I have a sheet with 3 macros. It consists of two macros to produce results, and the third to bridge the two together where is all starts. I have built a userform in the sheet and am trying to get the variables in both sheets, to be user changeable and selectable via the userform.
In the attached data, the userform allows for the selection of two sheets, A and B. The user would select in A the sheet with data which is equivalent to Oval_An and in B the sheet with the data equivalent to Oval_DMA. The first macro, Find_75 runs, followed by the second macro, kTest, all working to produce results when hitting the Subtract button on the form. The Find_75 tolerance are also defined via the useform box, as well as kTest's compare tolerance.
View 6 Replies
View Related
Apr 21, 2009
I have a list of items in column A of Sheet1 and the same list in column A of Sheet2. Both list will contain the same items, however not necessarily in the same order.
What I want the book to do is; when I click on an item in the list on Sheet1, it takes me to the same item in Sheet2.
Is this possible with VBA?
View 10 Replies
View Related
Aug 20, 2009
I would like to know if there is a way to copy a spreadsheet and paste it into a new tab on another spreadsheet. We currently download 2 lots of spreadsheets from SAP and would like to create another spreadsheet to act as a 'central' preadsheet. What I would like to happen is that the data from the 2 downloaded spreadsheets will be automatically pasted into 2 new tabs on the central spreadsheet, then run some formatting macros (which I can do fine).
View 3 Replies
View Related
Jun 17, 2008
I have a workbook with about 200 sheets.
Each sheet contains lots of links to the other sheets, so the user can clink the link and then go to the new sheet.
But, how do I make a "return-function"? That can return the user to the sheet that was active before the link was followed? If possible I would like this do be doable for 5-10 sheets back.
This "return-function" is gonna be used by clicking a button on a floating toolbar I have connected to the sheet.
View 9 Replies
View Related
Jun 28, 2013
I have two worksheets, one with detail monthly information and one with YTD information. So let's say the three numbers I want to capture in the YTD sheet are in columns B, G and I on the monthly sheet. January's data might be in B5, G5 and I5. February's data is in B12, G12 and I12 and so on.
On the YTD sheet in cell C2 I link to Monthly!B5 and in C3 I link to Monthly!B12 so cells C2 to C13 on the YTD sheet show the monthly totals from column B on the detail sheet. On the YTD sheet, cells C20 to C31 show the monthly totals from column G on the monthly sheet, so cells G5, G12, etc. And finally, cells C40 to C51 on the YTD sheet show monthly totals form column I on the monthly sheet.
In the past I've always created all these links manually. After creating the links in C2 to C13 on the YTD sheet, is there a way to use a formula in C21 that uses the link in C2 to create a link for G5?
View 6 Replies
View Related
Sep 4, 2009
I am trying to link data from multiple sheets in a file into one sheet. This is the following I want to achieve.
1) I want to pull data from the tab - Tab 1 (in the attached sheet) from column F only if the column E cell has 3, into the "Plan" Sheet in cell D5. I want all the 3's information from Tab 1 (F12, F14, F16 and F17) to be in the same cell D5 with alt+Enter spacing. The trick is these cells may not be always 3 they can be either 1,2,3. So the function needs to go through the entire range E10:E69 to find where there are 3 in the E column and then return the corresponding data from the F column to the "Plan" sheet in Tab 1.
View 4 Replies
View Related
