Recent content by UongSaki

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...