Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by martyzack
at 2024-07-16 16:20:47
ModifyPoint:500 Replies:5 POST_ID:828995USER_ID:11895
Topic:
Office & Productivity Software;;Spreadsheet Software
I am trying to figure out how to compare 2 excel sheets and copy the information from any rows that are not in the master sheet. In this case the Master is the Jun14 sheet I would need it to copy each one to a new sheet Example Jan14 would copy to new sheet 1, Feb14 would copy to new sheet 2, Mar14 would copy to new sheet 3 and so on. I am only looking for a comparison between each sheet and the Jun14 sheet as the master individually. I have attached the workbook I am using as a test.
Attachment:Book1.xlsx
Expert: Ejgil Hedegaard replied at 2024-07-21 14:42:39
Imagine you want to compare the visible columns on the sheet for the last month to the other sheets.
So here is a function to do that.
You will be asked "Select a cell on the sheet to compare the other sheets to".
Now it is Jun14, but then it will also work next month.
Just select any cell on the sheet, and press Ok.
Only the columns that match the headers for the visible columns on the selected sheet will be copied. If the header is missing, you get a warning and the program stops.
The sheets will be named "Jan14 to Jun14" etc.
So here is a function to do that.
You will be asked "Select a cell on the sheet to compare the other sheets to".
Now it is Jun14, but then it will also work next month.
Just select any cell on the sheet, and press Ok.
Only the columns that match the headers for the visible columns on the selected sheet will be copied. If the header is missing, you get a warning and the program stops.
The sheets will be named "Jan14 to Jun14" etc.
Expert: Ejgil Hedegaard replied at 2024-07-20 05:39:06
The sheets are not identical in structure.
Sheet Jun14 has 3 columns A:C more than the others.
For the sheets Jan14 to Apr14 the column headers A:DP match the headers D:DS on Jun14, but for May14 the column headers X:AH and AT:BD are different.
What exactly do you want to compare?
Sheet Jun14 has 3 columns A:C more than the others.
For the sheets Jan14 to Apr14 the column headers A:DP match the headers D:DS on Jun14, but for May14 the column headers X:AH and AT:BD are different.
What exactly do you want to compare?
Author: martyzack replied at 2024-07-17 12:37:28
So what I want to do is compare Jun14 sheet with each of the other sheets (Jan14, Feb14, Mar14, Apr14, May14) individually and if there is a row on Jan14 etc. and it does not exist on Jun14 to copy that row from Jan14 to New Sheet1.
Author: martyzack replied at 2024-07-17 08:04:19
Hello,
Well what I am trying to accomplish here is to compare each sheet individually against the Jun14 sheet and take the rows that are not on the Jun14 but are on the other sheet example the Jan14 sheet and copy those rows from the Jan14 sheet that do not appear on the Jun14 sheet to a new sheet that I can use to see what merchants I have lost since Jan14 each month in comparison to what I have currently on Jun14. Does that make sense?
Well what I am trying to accomplish here is to compare each sheet individually against the Jun14 sheet and take the rows that are not on the Jun14 but are on the other sheet example the Jan14 sheet and copy those rows from the Jan14 sheet that do not appear on the Jun14 sheet to a new sheet that I can use to see what merchants I have lost since Jan14 each month in comparison to what I have currently on Jun14. Does that make sense?
Expert: duncanb7 replied at 2024-07-16 23:05:01
For example, you could copy A1:A10 value from Jan14 sheet into DQ1:DQ10 at Feb14 Sheet
by VBA marco in which you can add any code you want to do any comparsion.
If you write more what you want to compare, that wiil be easier to solve your issue
Hope understand your question completely.if not, please pt it out.
Duncan
by VBA marco in which you can add any code you want to do any comparsion.
If you write more what you want to compare, that wiil be easier to solve your issue
Hope understand your question completely.if not, please pt it out.
Duncan
Sub copy_sheet()Sheets("Jan14").Range("A1:A10").CopySheets("Feb14").Range("DQ1:DQ10").PasteSpecial Paste:=xlPasteValuesEnd Sub 1:2:3:4:
