Search results for query: *

Thank you Skip. Not sure how yet but I'll look into it.

Yes, eventually. I think I know how to move sheets from different work books into one & then combine them into one big worksheet. Thanks, Saki

Hi Skip: I have over 100 cost center managers submitting their budget requests (in five different workbooks by division) and I need a way to combine them and analysis. I would review and make some changes to their requests and then send back to them. They (cost center managers) will have to...

Thank you, Here’s what I want to accomplish: I want to combine all data from different worksheets, all with same structure, into one big worksheet. The combine worksheet will be my master for analysis. I want to be able to change values in other worksheets and have the changes updated in the...

I got this code: Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = "Combined" ' copy headings Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy...

Thank you. I'll re-post my question there. I tried macro recorder and I got this snippet, ActiveSheet.Paste Link:=True. I don't know where modify the code above with this code. Thans, Saki

I got this code: Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = "Combined" ' copy headings Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy...

Thank you for pointing me to the right Forum. I found it in thread707-935461. Thanks, Saki

How do I get Excel to put the value in a cell (AA1) from all active worksheets into the header and format it to Arial, Bold 18 pts? Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = "" ActiveSheet.PageSetup.CenterHeader =...

Is there a way to separate contents of a memo field into multiple fields based on when a return is press, i.e. every paragraph in the memo field will get its own field? Thank you, Uong Saki

Hi Skip, Thank you for your help. The code you wrote is foreign to me since I’m not a programmer. Here are the error Excel returns: For Sub1 Run time error 1004 Method ‘Range’ of object ‘_Global’ failed For Sub2 Run time error 9 Subscript out of range Thank you for you help! Saki

I have a large workbook with multiple worksheets and numerous range names used in calculation. over time and with all the changes I made, I've last track of which range names are still is in use. How can I find the unused ones and delete them from the workbook? Thank you, Uong Saki

I have a table with two date fields, date1 & date2. How dow I get Date2 automatically entered for me when I enter Date1 by adding 15 days to Date1? I was able to have Date2 entered automatically on a form but was not able to have it updated in the table. Thanks, UongSaki

I heave several Excel 2000 workbooks and each workbook has several worksheets of similar columns. Is there a way in Excel that I can combine all workbooks and their worksheets into one worksheet without having to copy and paste each worksheet? Thank you, UongSaki

Hi Michael, You are correct that the data (retirement, replacement, and other transitions) are in employee table or related employee tables. I don't know how incorporate them in the calculation that why I just want to project the cost of employees salary assuming that they were to stay with...

Hi Skip, Thank you for taking the time to help me. These are the portion of data in tables that I'm trying to project salary cost for each employee. I copied&Pasted from WordPad. TblEmployee Persno UnionGroup PayGroup PayLevel HourlyRate LastSalatyIncreaseDate DateOfHire 11527 B B420 1...

That date is coming from the Employee data, Employee table. Thank you, UongSaki

Hi Skip, Sorry, the time between step in Union C should be blank. This is the last step and any employee who reaches that step will no longer get a step increase. Union C employees have either 3 or 7 steps. And yes, the current step defines the current pay and I do have the date of last pay...

I need help in writing a visual basic codes to make a salary projection for my company budget. The cost would include an annual increase as agreed with different unions and an employee date of hired or date of last salary increase due to a step increase. Time between steps for: Union Code Job...

I was able to make Access print reports to PDF file using basPDFSaver from FAQ703-2533. But how do I make the PDF document properties title field blank instead of the name of Access Report it was generated from? I have a report name RptVariance and the PDF being created with basPDFSaver has a...